[Zope] dtml-sql case sens. issue
Fri, 16 May 2003 13:44:07 +0200
On Fri, 16 May 2003 14:21:17 +0300 GMT (..13:21 where i live(GMT+2) )
Michael Dexter asked the Zope mailinglist about the following:
MD> I am experimenting with SQL under Zope and have started with the
MD> "Elvis Sighting" tutorial. I've created my own table with obvious
MD> names like "varcharField0" for the first field, which is a varchar. I
MD> used an uppercase "F" to make it a little easier to read. I
MD> understand that SQL is generally not case sensitive. Here's the SQL
MD> to create the table, the "stored procedure" to view all and the DTML
MD> snippet that calls it.
MD> The issue: <dtml-var varcharField0> BREAKS while "varcharfield0" works.
MD> Whose case sensitivity problem is this? Zopes? SQL's? The Browser?
While SQL is case-insensitive, Python (and thus Zope) is not. The
result-object instances you get from calling ZSQLmethods have to have
names for their fields, and as SQL (and the data returned from the
database) is case-insensitive there is no way for the ZSQLmethod to
know that you called your column "varcharField0" and not
IIRC the variables returned in a result-object are accessible both as
uppercase and lowercase names (correct me if i am wrong), but not