oracle newbie needs function advice

I have some code which works on SQL server:

<CFQUERY name="get_orderNo" datasource = "#Variables.DSN#">
SELECT Max(orderNo) AS next
FROM slides
WHERE chapterID = #chapterNo#
</CFQUERY>

The orderNo variable gets set based on the result:

<cfif get_orderNo.next IS "">
<cfset next = 1>
<cfelse>
<cfset next = get_orderNo.next + 1>
</cfif>

This doesn't seem to work on a site running Oracle. Does the Max function work with Oracle? Or is there some other problem with the code? Case sensitivity? Received on Thu Jul 12 2001 - 17:51:19 CEST