[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?
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?
RE: [Zope] Z SQL Objects (Newbie)
Error message stuff:
Expression (Python) Syntax error: invalid syntax
, for tag :if "team=='S'", on line 23 of
string
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)
~~~
Yvonne Totty
Database Engineer
-
Wolverine: You actually go outside
in these things?Cyclops: Well, what would you prefer? Yellow
spandex?
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?
Re: [Zope] Z SQL Objects (Newbie)
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 )
RE: [Zope] Z SQL Objects (Newbie)
Jim, Nah, I thought of that, too and it didn't work 8(. I have been using :sqlvar ... inside my statements and those seem to be doing just fine. Yvonne 8) Try it with the dtml-if syntax rather than :if. It made a difference for me. If this works for you, please post a comment. it appears that the newest syntax did not filter into ZSQL methods. ___ 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 )
RE: [Zope] Z SQL Objects (Newbie)
Well, I will be darned, it did work. I must have left out the quotes before when I tried it. That is weird, how, in the very same object, the :sqlvar... works, but :if... doesn't. Thanks so much!!! ~~~ Yvonne Totty Database Engineer - Wolverine: You actually go outside in these things? Cyclops: Well, what would you prefer? Yellow spandex? 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 )
