Try: <CFQUERY datasource="#dsn#" name="GetID"> SELECT MAX(ID) AS TheID FROM UserInfo </CFQUERY>
Please tell me that this query is within a transaction, and that you're only doing this because you're using Access. ----- Original Message ----- From: S R <[EMAIL PROTECTED]> Date: Wednesday, May 29, 2002 11:28 am 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 > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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