Re: SQL server application porting headache

On Sun, Jun 23, 2002 at 08:44:50PM +0200, Oskar Berggren wrote:
> I have tried this and it seems to work for the query i mentioned in
> my original posting, which is as expected since that one actually
> use correct capitalization. However, shortly afterwards the
> application issue the query:
>
> SELECT "PassWord" FROM "Operators" WHERE Name='...' AND Password='...';
>
> Since the column is called PassWord, you can see why I'm feeling
> I bit down right now...

Would it not be easier if the code simply lowercased everything, including
quoted identifiers. This is totally wrong but will produce the effect you
want (unless ofcourse, the names of the output columns important).

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.