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')/; F.
