[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)"
>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
+----------------------------------------------------------------------------------
More information about the interchange-users
mailing list