Yvonne,
The format of your 'if' is incorrect:
You have <:if .....> it should be <dtml-if.....>
so the whole statement is as Jens says below.
hth
Phil
[EMAIL PROTECTED]
----- Original Message -----
From: Jens Grewen
To: [EMAIL PROTECTED]
Cc: Zope Maillist
Sent: Thursday, October 26, 2000 2:51 PM
Subject: Re: [Zope] Z SQL Objects (Newbie)
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?
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
