Clara Baiget wrote:

Hi JCC, Thank you very much for your help - the problem was actually the location of one of the scripts - I looked for some documentation on the concat SQL command - you were right, it seems it's not cut out for gadfly. Unfortunately the option of using My SQL with zope seems too buggy, as I keep getting errors with the MySQL DA....(it seems like a common problem). The reason I wanted to use MySQL was to be able to reuse the data, but I'm not sure this is possible with Postgres or gadfly. Can data be transferred into a MySQL database? Thanks again for your help! Clara

I'm also including the list: we might as well have the info out there for posterity, no? I know Postgres to work very well with Zope. The only problem I've ever seen is that frequent use of the "refresh" function will sometimes cause connection leakages, and I'm not even sure this isn't just a general behaviour. Gadfly also interacts well, but frankly I wouldn't use it for anything other than demonstration or the most trivial of applications. (Which is its job description, after all.) If you must have information available in some external relational database, Postgres will usually work every bit as well as MySQL. I'm sure there are ways to transfer data between the two (if you already have data in one) if that's in question. (And since you appear to have good reasons, I'll withhold the usual tract about where I think data should usually be stored (hint: ZODB). If you care, you can look it up in the list archives.) I don't know about the errors you get with the MySQL DA: perhaps the list or the author can help clear those up and solve the whole problem. --jcc

...

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.)

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