That did not seem to make a difference. Thanks. Dan
-----Original Message----- From: Roel van der Hoeven [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 19, 2002 4:46 AM To: [EMAIL PROTECTED] Subject: Re: Max in query Just a thought: You say select max(logicSequence) + 1 as nextSequenceNo i think it is select (max(logicSequence) + 1) as nextSequenceNo Maybe wrong just a quick thought. HTH Roeligan ----- Original Message ----- From: "Dan O'Keefe" <[EMAIL PROTECTED]> To: "Fusebox" <[EMAIL PROTECTED]> Sent: Wednesday, June 19, 2002 10:43 AM Subject: 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 ==^================================================================
