[Zope] ZOPE : SQL methods

K H Subrahmanyan subrahmanyan.kalathur@wipro.com
Fri, 12 Jan 2001 13:42:55 +0530


hi,

  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.



 Zope Error
Zope has encountered an error while publishing this resource.
Error Type: SyntaxError
Error Value: unexpected token sequence.near :: 'est\012where \012Emp_name'*'
like "*rama*"' ******************************* current state = 57 expects:
'HAVING', 'UNION', 'GROUP', 'VARCHAR', 'DESC', 'SELECT', 'ORDER', 'WHERE',
'AS', 'EXCEPT', '*', 'IN', 'INTERSECT', 'FLOAT', '+', '(', ')', '.', '/',
',', '-', 'AND', 'FROM', '*', ';', 'INTEGER', 'NOT', '>', 'OR', '=',
'BETWEEN', 'ASC', '<', 'VALUES', ('nomatch1',) current token = ((-8,
'user_defined_name'), 'LIKE')



kindly help
thanks
bye
subrahmanyan.