[Zope] Something funny about SQL like?
Rob Page
rob.page@digicool.com
Mon, 2 Aug 1999 21:54:05 -0400
> Error, exceptions.SyntaxError: unexpected token sequence.near
> :: 'where
> firstname'*' like "%Donald%'
> ******************************* current state = 45 expects:
> ',', 'UNION',
> 'FLOAT', 'GROUP',
> 'VARCHAR', 'DESC', 'SELECT', 'ORDER', 'WHERE', 'AS', 'IN',
> 'INTERSECT', 'ASC',
> '*', '+', '(', ')', '.',
> '/', 'EXCEPT', '-', 'AND', 'FROM', '*', ';', 'INTEGER',
> 'NOT', '>', 'OR', '=',
> 'BETWEEN', 'HAVING', '<',
> 'VALUES', ('nomatch1',) current token = ((-8,
> 'user_defined_name'), 'LIKE')
>
> SQL used:
>
> select *
> from Users
> where firstname like "%Donald%"
> order by firstname
>
> Like I said, it looks to me like the SQL it's trying to
> use is fine.
> Does GadflySQL not support the "like" keyword?
Hmmm:
http://www.chordate.com/kwParsing/gffaq.html#like
Guess not... :^(
Sure was fun trying to solve the problem though! :^))
--Rob