Return the largest value - max? 1

[fiber0pti]

How would I return the largest value of a few numbers?
I have categroies, subcategories and product IDs. I want to look up the Category and subcategory of the current product and then return the largest prod ID under those two.
Would I use max for this? It didn't seem like that would do the job.

 

[tlhawkins]

Yes use Max,

like this
<CFQUERY name=&quot;name&quot; datasource=&quot;datasource)>
Select max(myField) as maxMine
From MyTable
</CFQUERY>

Hope that does it for you.

 

[fiber0pti]

I get an error that it's an unknown select funtion.

 

[Bramvg]

Hi fiber0pti,


The max() operator is used like: max(number1,number2), so not realy suited withing a cfquery (I think).

What you could do is:

cfquery...
select prod ID from tabelx
ORDER BY prod ID DESC

in the cfoutput you can select the biggest value by using:

<cfoutput query=&quot;name&quot; maxrows=&quot;1&quot;>#prod ID #</cfquery>

I hope this has helped you

Regards
Bram

 

[tlhawkins]

That's Odd.

Works for me.

Sorry about that.