[ic] query sql question?

[Lyn St George]

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)"
>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.

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

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....
>Roland


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