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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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