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