invalid syntax

Traceback (innermost last):
  File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 222, in publish_module
  File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 187, in publish
  File C:\PROGRA~1\ATIANY~1\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook
    (Object: TeamDates)
  File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 171, in publish
  File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\mapply.py, line 160, in mapply
    (Object: manage_edit)
  File C:\PROGRA~1\ATIANY~1\lib\python\ZPublisher\Publish.py, line 112, in call_object
    (Object: manage_edit)
  File C:\Program Files\ATIAnywhere\lib\python\Shared\DC\ZRDB\DA.py, line 242, in manage_edit
    (Object: TeamDates)
  File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_String.py, line 383, in cook
    (Object: <string>)
  File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_String.py, line 228, in parse
    (Object: <string>)
  File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_String.py, line 292, in parse_block
    (Object: <string>)
  File C:\PROGRA~1\ATIANY~1\lib\python\DocumentTemplate\DT_String.py, line 126, in parse_error
    (Object: <string>)
Document Template Parse Error: (see above)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi,

 

Arguments |  team

 

Query template

 

<dtml-if "team == '5'">

  select *

  from data

<dtml-else>

  select *

  from data

</dtml-if>

 

this is normal

 

but may it helps if you post the traceback of the error message

 

Jens Grewen

 

----- Original Message -----

From: Yvonne Totty

To: zope@zope.org

Sent: Thursday, October 26, 2000 3:22 PM

Subject: [Zope] Z SQL Objects (Newbie)

I have the O'Reilly book, but can't seem to find more

complete information on how to do 'if's' in a SQL thing.

 

Here's the scenario:

I have three different 'teams' and want to run a call

specific to each team. I am passing in three parameters,

two of which go in the sql statement, the other goes in

the if statement:

<:if "team='S"'>

sql statement

<:elif "team='C'">

blah, blah

</:if>

 

It tells me it doesn't like the syntax of the 'if' (I have

stuff in the python file that lets me use ':' in place of

'dtml-'). I have tried all the flavors: "team=='S'",

"team=S", "team==S", etc. and it doesn't like any of

them.

 

If you guys know of another reference, please let me

know!

 

TIA,

Yvonne 8)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Yvonne Totty

Database Engineer

-------------------------

Wolverine: You actually go outside in these things?
Cyclops: Well, what would you prefer? Yellow spandex?