----- Original Message ----- From: "Francois Desarmenien" <[EMAIL PROTECTED]> To: "Jose Blanco" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 3:29 PM Subject: Re: case sensitivity when creating a table.
> On Thu, 20 Feb 2003 14:44:02 -0500 > "Jose Blanco" <[EMAIL PROTECTED]> wrote: > > > Any ideas why SQL statements like this one: > > > > SELECT collid FROM Collection where collid= '123' and (userid = 'JoseA' or > > userid = 'JoseB') > > > > Are not working with SQL::Statement version 1.005, but are with version > > 0.1021? Is this another bug with this release. > > Bug or not, it is dartabase dependend and you should double quote "Collection". > It's the safe portable way when mixing uppercases and lowercases in table > names (or columns). You should try instead something like : > > q/SELECT collid FROM "Collection" where collid= '123' and (userid = 'JoseA' or > userid = 'JoseB')/; > Actually got it to work by adding some parenthesis: SELECT collid FROM Collection where ((collid= '123') and (userid = 'JoseA' or userid = 'JoseB')) > F. >
