Steven wrote:
> Hopefully someone has an idea of how to solve this. I have a 3rd
> party application that generates something similar to the following
> query:
>
> select a,b from points where a = 2 and a = 10;
>
> It really should be:
> select a,b from points where a is between 2 and 10;
>
> But the problem is (since I don't have access to the 3rd party source
> code of course) only the name of the table is configurable (the where
> clause is the same everytime just with different numbers and generated
> via the app).
>
it is nonsense trying to fix that outside that application;
if the query sent by that app is wrong, take that as a bug of the app
and try to get a bugfix from your vendor;
everything else is the straight road to hell;
if on the other hand the app is ok (which is most unlikely after taking
a look at the query), but you try to misuse it, stop that;
Received on Tue Sep 02 2003 - 11:49:15 CDT
