Try: SELECT MAX(ID) AS TheID FROM UserInfo
HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "S R" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 1:28 PM Subject: MAX function problem > Hello, > > Everytime I use this function I have problems. My code is below. I keep > receiving an error saying: > > "The column THEID is not present in the query named GETID" > > <CFQUERY datasource="#dsn#" name="GetID"> > SELECT MAX(ID) FROM UserInfo AS TheID > </CFQUERY> > > <CFOUTPUT>#GetID.TheID#</CFOUTPUT> > > thanks for your help, > > Sal > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists