[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