[Zope] ZOPE : SQL methods

Dieter Maurer dieter@handshake.de
Fri, 12 Jan 2001 23:34:07 +0100 (CET)


K H Subrahmanyan writes:
 >   I am using zope and gadfly for my project.
 > but while using the SQL methods, I get the error if I use the "like" option.
 > 
 > E.g..   select  *
 >         from  table
 >         where
 >              Emp_name   like   "*rama*"
 > 
 > I will get the following error.
Maybe, you should look at an SQL book or other SQL description...

 1. strings are surrounded by '...' not "..."
 2. the "match sequence" wildcard is "%" not "*"


Dieter