Re: [Zope] [OT perhaps] ZMySQLDA
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 - [EMAIL PROTECTED] > 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:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.soli-con.com begin:vcard n:Zanger;Olaf Marc tel;cell:+41-76-572 9782 tel;work:+41-31-332 9782 x-mozilla-html:FALSE url:www.soli-con.com org:soli-con Engineering Zanger adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland version:2.1 email;internet:[EMAIL PROTECTED] title:Dipl.-Ing. note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A x-mozilla-cpt:;-32176 fn:Olaf Zanger end:vcard
Re: [Zope] [OT perhaps] ZMySQLDA
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/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] [OT perhaps] ZMySQLDA
AFAIK in MySQL table names are case-sensitive. So, what happens if you say 'select * from STUDENTS'? Markus Kemmerling > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lee > Reilly CS1997 > Sent: Tuesday, January 30, 2001 10:27 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] > 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 ) > ___ Zope maillist - [EMAIL PROTECTED] 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 )