Thanks, it worked. I've been staring at the screen too long and I had the sql statement backwards.
Thanks again. Sal >From: <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: MAX function problem >Date: Wed, 13 Mar 2002 14:22:04 -0800 > >Try: > ><CFQUERY datasource="Contacts" name="GetNewUser"> >SELECT MAX(ID) as MAXID >FROM ContactInfo ></CFQUERY> > > > >Regards, >Pardeep. > > >----- Original Message ----- >From: "S R" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, March 13, 2002 2:08 PM >Subject: MAX function problem > > > > I keep getting an error resolving parameter MAXID when I do the >following > > > > <CFQUERY datasource="Contacts" name="GetNewUser"> > > SELECT MAX(ID) FROM ContactInfo AS MAXID > > </CFQUERY> > > > > <CFSET UserID = #GetNewUser.MAXID#> > > > > I've also tried > > > > <CFSET UserID = '#GetNewUser.MAXID#'> > > <CFSET UserID = '#MAXID#'> > > <CFSET UserID = #MAXID#> > > > > with the same error resulting. > > > > Sal > > > > _________________________________________________________________ > > MSN Photos is the easiest way to share and print your photos: > > http://photos.msn.com/support/worldwide.aspx > > > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
