On Fri, Jun 13, 2014 at 8:48 AM, Matthew Smith wrote: > EXEC PROC QRY_PERSONGET <cfprocparam type="In" >
First, there is probably not any good reason to be using a proc for this site. I would stick to regular inline SQL queries. I think that you could be providing a little better debugging information. Here's a good way to give more complete information about the errors you are seeing... Wrap any erroring queries in CFTRY like this, screenshot the resulting, then post it somewhere and provide a link (DropBox's public folder is good for this sort of thing). <cffunction> <cftry> <cfquery> [your query goes here] </cfquery> <cfcatch> <cfdump var="#arguments#" /> <cfdump var="#cfcatch.sql#" abort="true" /> </cfcatch> </cftry> </cffunction> Then, copy the entire function code that is causing the error and post it as a Gist here and send the list the link. That way we can see a nicely formatted example of the code and even post fixed examples back to you (also using Gists). https://gist.github.com That should give a complete picture of the problem and folks will be able to help you much quicker. -Cameron ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:370918 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
