Re: [Zope] Z SQL Objects (Newbie)

[Jens Grewen]

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: [EMAIL PROTECTED] 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?