Posted - August 18 2004 : 11:58:06
| I remember having this problem too, but I can't remember how I got round it. Sorry that's not much help, but at least it might give you a pointer towards what needs changing:
When you enter a value into the "where" field for a query on the standard table-query admin screens, it always treats those values as character strings, so the generated sql will end up something like:
select * from products where cprice='50'
select * from products where cprice like '50%'
this means that the sql engine will automatically try to translate one datatype to the other, in this instance it'll try to turn the cprice column value from money to varchar (character) for the query, which sqlserver obviously doesn't like.
what you could do is try the advanced query admin menu and enter your full sqlstatement in there as:
select * from products where cprice=50
that should give you the summary results, and with that you can also use <, <=, >, >= etc.
select * from products where cprice<=50
Web Design, Online Marketing and VPASP addons
Edited by - devshb on August 18 2004 12:00:11