[Zope] Cataloging a ZSQL database

[J. Cameron Cooper]

Clara Baiget wrote:

> I am a fairly new user to zope, and although I know the basics, I am
> having problems trying to catalog a zsql database. Fortunately I found 
> this Ho-to on the Zope site, which explains how to do this:
> http://www.my-zope.org/HowtosRating/20020109160026
> But following their example, when I create the getBooksToCatalog
> method, Test then hit the "Submit Query" button, I get the following
> error:
>
> Error, exceptions.SyntaxError: unexpected token sequence.near :: ',
> Title,\nconcat'*'(Description, T' *******************************
> current state = 45 expects: '.', ('nomatch1',) current token = ((-
> 6, '('), '(')

Seems like your database has problems with the concat operator. You'll 
need to find out how you can do a similar operation in your database's 
dialect of SQL. (Of course, you could not have a concatenated field for 
your PrincipiaSearchSource.)

             --jcc

-- 
"My point and period will be throughly wrought,
Or well or ill, as this day's battle's fought."