[ic] query sql question?
Topastro
topomorto at email.it
Tue Sep 14 07:41:36 EDT 2004
Hi to everybody,
just a question:
I need to find the greatest card number from all my cards.
I have a table called card (sku, name ecc....)
if I do:
[query sql="SELECT sku FROM products WHERE sku >= ALL (SELECT sku
FROM products)"
type=list]
[list][sql-code][/list]
[/query]
work fine, but if I try the same with card table:
[query sql="SELECT sku FROM card WHERE sku >= ALL (SELECT sku FROM
card)"
type=list]
[list][sql-code][/list]
(or inside of sql-code I use sql-param code)
[/query]
it dosn't work.
In my error_log, I've got:
Query was: SELECT sku FROM card WHERE sku >= ALL (SELECT sku
FROM card)
ip-102-202.sn1.eutelia.it Qop2dutK:eutelia.it -
[14/September/2004:13:52:35 +0200] cart /cgi-bin/cart/process.html Query
rerouted from table products failed: Bad SQL statement: Parse error near
ALL (SELECT sku FROM card) at /myicdir/Vend/Scan.pm line 600.
>
> Query was: SELECT sku FROM card WHERE sku >= ALL (SELECT
sku FROM card) at /myicdir/Vend/Table/DBI.pm line 1956
any suggestion?
In admin direct-sql : SELECT sku FROM card WHERE sku >= ALL (SELECT
sku FROM card)
work fine....
Thanks in advance....
Roland
More information about the interchange-users
mailing list