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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
