Same thing. I actually started it with that. If I run it in ISQL, it shows the field name returned as nextSequenceNo.
Dan -----Original Message----- From: Ivan Rodriguez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 4:51 AM To: [EMAIL PROTECTED] Subject: RE: Max in query And if you remove " + 1"? -----Mensaje original----- De: Dan O'Keefe [mailto:[EMAIL PROTECTED]] Enviado el: mi�rcoles, 19 de junio de 2002 10:43 Para: Fusebox Asunto: Max in query 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 ==^================================================================
