RE: [Zope] [OT perhaps] ZMySQLDA

2001-01-30 Thread Markus Kemmerling 

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 )

Re: [Zope] [OT perhaps] ZMySQLDA

2001-01-30 Thread Oleg Broytmann 

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 )