[Zope] dtml-sql case sens. issue

Michael Dexter dexter@ambidexter.com
Fri, 16 May 2003 14:21:17 +0300


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.