my 2 cents FYI: Although SQL is not case sensitive in the context of command structure, it _IS_ case sensitive as to database, table, and column names. Bobb ----- Original Message ----- From: "Michael Dexter" <dexter@ambidexter.com> To: <zope@zope.org> Sent: Friday, May 16, 2003 7:21 AM Subject: [Zope] dtml-sql case sens. issue
Hello,
I am experimenting with SQL under Zope and have started with the "Elvis Sighting" tutorial. I've created my own table with obvious names like "varcharField0" for the first field, which is a varchar. I used an uppercase "F" to make it a little easier to read. I understand that SQL is generally not case sensitive. Here's the SQL to create the table, the "stored procedure" to view all and the DTML snippet that calls it.
The issue: <dtml-var varcharField0> BREAKS while "varcharfield0" works.
Whose case sensitivity problem is this? Zopes? SQL's? The Browser?
create table tutorial_table( varcharField0 varchar, varcharField1 varchar )
spViewAllRecords:
select * from tutorial_table
<dtml-in spViewAllRecords> <p>varcharField0 contents: <dtml-var varcharfield0></p> <p>varcharField1 contents: <dtml-var varcharfield1></p> </dtml-in>
Thanks,
Michael.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )