[Zope] Re: ZSQL Woes....HELP!
The Doctor What
docwhat@gerf.org
Mon, 12 Mar 2001 00:02:45 -0600
* The Doctor What (docwhat@gerf.org) [010311 23:59]:
> Setting the arguments doesn't fix everything:
> ZSQL Object 'tmp'
> Arguments: ID:int=2
> -------------------------
> select * from url
> <dtml-sqlgroup where>
> <dtml-if expr="ID != 2">
> ID = '<dtml-var ID>'
> </dtml-if>
> </dtml-sqlgroup>
> -------------------------
>
> The normal case, of setting ID = to something other than 2 works
> great.
>
> URL:
> http://docwhat.gerf.org:9673/pi/links/tmp/manage_test?ID%3Aint=2&SUBMIT=Submit+Query
> Produces:
> select * from url
>
> URL:
> http://docwhat.gerf.org:9673/pi/links/tmp/manage_test?SUBMIT=Submit+Query
> Produces:
> select * from url where ID = '2'
>
> Which is WRONG! It's brimming over with wrongability.
>
> What is going wrong. I just want to be able to have default
> variables that cause large portions of the ZSQL query to remove
> themselves.
>
> Waaah....I'm tired.
>
> Ciao!
This is a ZOPE bug, isn't it. I bet the ID is stowed someplace that
DTML-IF can't reach it, but DTML-VAR can....or somesuch.
I'm using Debian UNSTABLE's Zope (2.3.0-3) on POTATO.
I'm going to bed.
Ciao!
--
LEGO DEFINITION 105
BURP: Big Ugly Rock Peice
The Doctor What: Guru to the Gods http://docwhat.gerf.org/
docwhat@gerf.org KF6VNC