Hi, I wonder if someone could comment on what they think my problem with the following may be. I have the ZMySQL DA installed, which works fine (I think). Testing my database in UNIX I created a table and populated it with some values. From the 'Test' page of the database connection in Zope I queried this table and it returned the correct values. So the connection string's fine. Now, here is where I ran into problems. Entering the following into the 'Test' page executes no problem. CREATE TABLE STUDENTS ( matric float (7), fname varchar(20), lname varchar (30), uname varchar (8) ) when i try and query it from Zope or Unix (select * from students) I get "OperationalError: (1146, "Table 'lreilly.students' doesn't exist")" and (table lreilly.students does not exist" respectively. I've even tried changing the tablename to lreilly.students but still no luck. Can anyone see what my problem is? Thank you very much in advance. - Best regards, Lee
On Tue, 30 Jan 2001, Lee Reilly CS1997 wrote:
CREATE TABLE STUDENTS when i try and query it from Zope or Unix (select * from students) I get
SELECT * FROM STUDENTS; Oleg. ---- Oleg Broytmann http://www.zope.org/Members/phd/ phd@phd.pp.ru Programmers don't die, they just GOSUB without RETURN.
AFAIK in MySQL table names are case-sensitive. So, what happens if you say 'select * from STUDENTS'? Markus Kemmerling
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Lee Reilly CS1997 Sent: Tuesday, January 30, 2001 10:27 AM To: zope@zope.org Cc: lreilly@cs.strath.ac.uk Subject: [Zope] [OT perhaps] ZMySQLDA
Hi,
I wonder if someone could comment on what they think my problem with the following may be.
I have the ZMySQL DA installed, which works fine (I think).
Testing my database in UNIX I created a table and populated it with some values. From the 'Test' page of the database connection in Zope I queried this table and it returned the correct values. So the connection string's fine.
Now, here is where I ran into problems. Entering the following into the 'Test' page executes no problem.
CREATE TABLE STUDENTS ( matric float (7), fname varchar(20), lname varchar (30), uname varchar (8) )
when i try and query it from Zope or Unix (select * from students) I get "OperationalError: (1146, "Table 'lreilly.students' doesn't exist")" and (table lreilly.students does not exist" respectively.
I've even tried changing the tablename to lreilly.students but still no luck.
Can anyone see what my problem is?
Thank you very much in advance.
- Best regards,
Lee
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
mysql is case sencitive olaf Lee Reilly CS1997 schrieb:
Hi,
I wonder if someone could comment on what they think my problem with the following may be.
I have the ZMySQL DA installed, which works fine (I think).
Testing my database in UNIX I created a table and populated it with some values. From the 'Test' page of the database connection in Zope I queried this table and it returned the correct values. So the connection string's fine.
Now, here is where I ran into problems. Entering the following into the 'Test' page executes no problem.
CREATE TABLE STUDENTS ( matric float (7), fname varchar(20), lname varchar (30), uname varchar (8) )
when i try and query it from Zope or Unix (select * from students) I get "OperationalError: (1146, "Table 'lreilly.students' doesn't exist")" and (table lreilly.students does not exist" respectively.
I've even tried changing the tablename to lreilly.students but still no luck.
Can anyone see what my problem is?
Thank you very much in advance.
- Best regards,
Lee
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com
participants (4)
-
Lee Reilly CS1997 -
Markus Kemmerling -
Olaf Zanger -
Oleg Broytmann