[Zope] Re: ZSQL Woes....HELP!

The Doctor What docwhat@gerf.org
Sun, 11 Mar 2001 23:57:06 -0600


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!

-- 
Computers are not intelligent.  They only think they are.

The Doctor What: A really hip dude               http://docwhat.gerf.org/
docwhat@gerf.org                                                   KF6VNC