The resultset is a number not the qry returned ie the default is 1 <cfprocresult name="QRY_PERSONGET" resultset="#QRY_PERSONGET#">
. On Fri, Jun 13, 2014 at 8:48 AM, Matthew Smith <chedders...@gmail.com> wrote: > > <cffunction access="public" name="qry_ordersShippingAddressGet" output="no" > returntype="query"> > <cfargument name="orderKeyList" type="string" required="no" default=""> > <cfargument name="personKeyList" type="string" required="no" default=""> > <cfquery > name="qry_ordersShippingAddressGet" > datasource="#variables.datasource#"> > EXEC PROC QRY_PERSONGET <cfprocparam type="In" > cfsqltype="CF_SQL_BIGINT" variable="arguments.orderkeylist" > dbvarname="@orderkey" value="#arguments.orderkeylist#" > null="no">,<cfprocparam type="In" cfsqltype="CF_SQL_BIGINT" > variable="arguments.personkeylist" value="#arguments.personkeylist#" > null="no"> > > </cfquery> > <cfprocresult name="QRY_PERSONGET" resultset="#QRY_PERSONGET#"> > </cffunction> > > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > > The following information is meant for the website developer for debugging > purposes. Error Occurred While Processing Request Attribute validation > error for CFPROCRESULT. The value of the RESULTSET attribute is invalid. > The value cannot be converted to a numeric because it is not a simple > value.Simple values are booleans, numbers, strings, and date-time values. The > error occurred in > *D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/cfcs/qry-todatabase.cfc: > line 825* > *Called from* D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_settings.cfm: > line 13 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 191 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 33 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30_CF50.cfm: > line 1 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm: > line 9 > *Called from* > D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.cfc: > line 62 > > 823 : , > 824 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" > variable="arguments.orderKeyList" dbvarname="@orderKey" > value="#arguments.orderKeyList#" null="no">*825 : <cfprocresult > name="proc_procpersonGET" resultset="qry_PERSONGet">* > 826 : </cffunction> > 827 : <cffunction access="public" name="qry_ordersShippingAddressGet" > output="no" returntype="query"> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:370930 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm