[Zope] "Like" in Z SQL methods (Z ODBC+MS Access)

Farrell, Troy troy.farrell@wcg.com
Wed, 18 Apr 2001 12:48:56 -0500


Make note to use <dtml-var name=3D"sql_delimiter"> instead of ending =
your
queries with a ;

Troy

-----Original Message-----
From: Thomas B. Passin [mailto:tpassin@mitretek.org]
Sent: Wednesday, April 18, 2001 12:33 PM
To: zope@zope.org
Subject: Re: [Zope] "Like" in Z SQL methods (Z ODBC+MS Access)


Mariusz B=B3o=F1ski wrote -

> >Oh and try % not *.
> Thanks. It works. Correct quoting was also necessary, but real =
problem was
*
> instead of %.
>
 Yes, the "%" is standard SQL syntax.

Tom P


_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -=20
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )