[Zope] dtml-sql case sens. issue

Bobb rawbobb@hotmail.com
Sun, 18 May 2003 11:54:00 -0400


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