[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