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 )

Reply via email to