[Zope] [OT perhaps] ZMySQLDA

[Markus Kemmerling]

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