[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