[Zope] [OT perhaps] ZMySQLDA

[Olaf Zanger]

Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------7B87967F10FE6AB796A6B215
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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

-- 
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:info@soli-con.com
mailto:olaf.zanger@soli-con.com
http://www.soli-con.com
--------------7B87967F10FE6AB796A6B215
Content-Type: text/x-vcard; charset=us-ascii;
 name="olaf.zanger.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Visitenkarte für Olaf Zanger
Content-Disposition: attachment;
 filename="olaf.zanger.vcf"

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:olaf.zanger@soli-con.com
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

--------------7B87967F10FE6AB796A6B215--