I can not figure out why I cannot reference this returned value from a
cfquery.
<cfquery name="NextSequence" datasource="#request.datasource#">
select max(logicSequence) + 1 as nextSequenceNo
from tblSchedulingLogic
where visitTypeMergeID = #attributes.visitTypeMergeID#
</cfquery>
<cfoutput>#NextSequence.nextSequenceNo# </cfoutput>
The result is an empty space
Dan
-----------------------------------------
Dan O'Keefe
TriPoint Technologies
954.501.3115
==^================================================================
This email was sent to: [email protected]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================
