[ic] query sql question?

Lyn St George lyn at zolotek.net
Tue Sep 14 08:33:42 EDT 2004

On Tue, 14 Sep 2004 13:41:36 +0200, Topastro wrote:

>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)"
>work fine, but if  I try the same with card table:
>[query sql="SELECT sku FROM card WHERE sku >= ALL    (SELECT sku  FROM 
>(or inside of sql-code I use sql-param code)
>it dosn't work.

[query sql=|SELECT MAX(sku) AS sku FROM card| type=list]

works well on MySQL 

>any suggestion?
>In admin direct-sql : SELECT sku FROM card WHERE sku >= ALL    (SELECT 
>sku  FROM card)
>work fine....
>Thanks in advance....

Lyn St George
+ http://www.zolotek.net .. build, host, support

More information about the interchange-users mailing list