[Zope] SQLTEST is case insensitive?

Dieter Maurer dieter@handshake.de
Fri, 9 Mar 2001 20:40:32 +0100 (CET)


The Doctor What writes:
 > ....
 > <dtml-sqlgroup where>
 >   <dtml-sqltest ID type=int optional>
 > <dtml-and>
 >    "val_Protocol"."ID" = "URL"."val_ProtocolID"
 > </dtml-sqlgroup>
 > 
 > If I make that:
 > <dtml-sqlgroup where>
 >    "URL"."ID" = <dtml-var ID sql_quote>
 > <dtml-and>
 >    "val_Protocol"."ID" = "URL"."val_ProtocolID"
 > </dtml-sqlgroup>
 > 
 > 
 > Then ID cannot be optional.  I can't use this object as a 'list all'
 > solution.  Isn't that the whole point of the dtml-sqltest tag?
Then, you wrap it into an "dtml-if":

      <dtml-sqlgroup where>
        <dtml-if ID>
	  "URL"."ID" = <dtml-var ID sql_quote>
	</dtml-if>
      <dtml-and>
      ....



Dieter