RE: [Zope] Zope is not getting MySQL SELECT results ...

2001-01-24 Thread Tom Jenkins
Hello Gerald, Hi all. [snip] but it does not seem to be able return any data through a SELECT query. This does not work in the "test" table nor in a SQL method. Using a query, such as "select * from test", it always replies with:

RE: [Zope] Zope is not getting MySQL SELECT results ...

2001-01-24 Thread Dave Woolston
Hello Gerald, Hello Gerald, Hi all. I have set up, in a clean Zope installation, a MySQL database adapter. My connection string is "test test test", indicating a user test with password test connection to the test database. The adapter indicates that it can connect to the database, and I

RE: [Zope] Zope is not getting MySQL SELECT results ...

2001-01-24 Thread Gerald Gutierrez
This may seem like a silly response, but have you tried the same select statement from outside zope - say from the mysql client? perhaps your select statement is truly returning an empty set. We use zope with PostgreSQL and MySQL (and have been for a few years) and haven't had any