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?