This should be simple........ 1

[cpod]

I realize I am just starting to learn but it seems like this should be simple:

I'm just trying to access the maximum value for "ID" and increment by one:

<cfquery datasource=&quot;eci&quot; name=&quot;maxquery&quot;>
select max(ID) as mxid from visitors
</cfquery>

<cfset maxid = mxid +1>

I know the value is there, I can output it by:

<cfoutput query=&quot;maxquery&quot;>
testing #mxid#
</cfoutput>

but if I try to do anything else with it I get a &quot;unable to determine the value of the parameter&quot; error.

I'm sure it's something simple that I am unable to see.

Thank you for any help you are able to give.

 

[calista]

My suggestion would be to enclose your CFSET in CFOUTPUT tags and use # signs.

<cfoutput>
    <cfset maxid = #maxquery.mxid# + 1>
</cfoutput>

Calista :-X
Jedi Knight,
Champion of the Force

 

[cpod]

That did it.

Thank you so much!