Re: [Zope] SQLTEST is case insensitive?

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