[Zope] Something funny about SQL like?

[Rob Page]

> 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