SELECT MAX(ID) AS TheID FROM UserInfo Use the above SQL instead.
-Matt > -----Original Message----- > From: S R [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 10:28 AM > To: CF-Talk > 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 > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
