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
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )