[ZDP] BackTalk to Document The Zope Book (2.6 Edition)/Relational Database Connectivity

webmaster at zope.org webmaster at zope.org
Fri Jun 4 05:51:48 EDT 2004

A comment to the paragraph below was recently added via http://zope.org/Documentation/Books/ZopeBook/2_6Edition/RelationalDatabases.stx#3-54


      The *sqltest* tag helps you build correct SQL queries. In
      general your queries will be more flexible and work better with
      different types of input and different database if you use
      *sqltest* rather than hand coding comparisons.

        % Anonymous User - June 4, 2004 5:51 am:
         whenever i use 'like'...zope gives the following error:

         Error, exceptions.SyntaxError: unexpected token sequence.near :: 's\nwhere\n( first'*" like 'A%'\n)"
         ******************************* current state = 57 expects: 'ASC', '=', '<', '>', 'INTEGER', ';', 'VARCHAR',
         '*', '-', 'EXCEPT', '/', '.', ')', '(', '+', '*', ',', 'ORDER', 'SELECT', 'GROUP', 'HAVING', 'VALUES', 'OR',
         'NOT', 'FROM', 'IN', 'AND', 'FLOAT', 'INTERSECT', 'BETWEEN', 'AS', 'WHERE', 'DESC', 'UNION', ('nomatch1',)
         current token = ((-8, 'user_defined_name'), 'LIKE')
         Till now I have been trying everything as explained above.

More information about the ZDP mailing list