<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"> On Fri, Jun 13, 2014 at 8:43 AM, LRS Scout <[email protected]> wrote: > > Thing is every time you change something you need to post the new error and > code. > On Jun 13, 2014 8:31 AM, "Matthew Smith" <[email protected]> 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> > > > > > > On Fri, Jun 13, 2014 at 8:02 AM, Matthew Smith <[email protected]> > > wrote: > > > > > I fixed that, thanks. > > > > > > > > > On Fri, Jun 13, 2014 at 7:57 AM, Zaphod Beeblebrox < > > > [email protected]> wrote: > > > > > >> > > >> what does #request.sqlObjectPrefix# render out to? > > >> > > >> > > >> On Fri, Jun 13, 2014 at 3:47 AM, Matthew Smith <[email protected] > > > > >> wrote: > > >> > > >> > > > >> > i have converted to a stored proc: > > >> > > > >> > USE [redhotkitties2005db] > > >> > GO > > >> > /****** Object: StoredProcedure [dbo].[proc_latest24items] > Script > > >> Date: > > >> > 06/13/2014 04:12:02 ******/ > > >> > SET ANSI_NULLS ON > > >> > GO > > >> > SET QUOTED_IDENTIFIER ON > > >> > GO > > >> > > > >> > create PROCEDURE [dbo].[proc_procpersonGET] > > >> > @personKey varchar(8000), > > >> > @emailAddress varchar(8000) > > >> > > > >> > AS > > >> > BEGIN > > >> > SELECT * > > >> > FROM #request.sqlObjectPrefix#tblPeople > > >> > WHERE 1 = 1 > > >> > AND tablePK = @personKey > > >> > AND emailAddress = @emailAddress > > >> > END > > >> > > > >> > > > >> > > > >> > On Thu, Jun 12, 2014 at 11:19 PM, C. Hatton Humphrey < > > >> [email protected]> > > >> > wrote: > > >> > > > >> > > > > >> > > What he's saying is this... in your code snippet: > > >> > > > > >> > > <cfif len(arguments.orderKeyList)> > > >> > > AND o.tablePK = <cfqueryparam > > >> > > value="#arguments.orderKeyList#" > > >> > > cfsqltype="CF_SQL_INTEGER" list="Yes"> > > >> > > </cfif> > > >> > > > > >> > > and the other one that uses the cfqueryparam where list="Yes" > > >> > > > > >> > > you need to treat it as an IN clause instead of an EQUALS. > > >> > > > > >> > > Here's an unparameterized example. > > >> > > > > >> > > select * > > >> > > from table > > >> > > where ID in (3,5,2,6,1) > > >> > > > > >> > > > > >> > > > > >> > > Until Later! > > >> > > C. Hatton Humphrey > > >> > > http://www.eastcoastconservative.com > > >> > > > > >> > > Every cloud does have a silver lining. Sometimes you just have to > > do > > >> > some > > >> > > smelting to find it. > > >> > > > > >> > > > > >> > > On Thu, Jun 12, 2014 at 11:14 PM, Matthew Smith < > > >> [email protected]> > > >> > > wrote: > > >> > > > > >> > > > > > >> > > > How do you mean? Thanks! I tried a = as well... Didn't work > > either. > > >> > > > > > >> > > > > On Jun 12, 2014, at 23:03, LRS Scout <[email protected]> > > wrote: > > >> > > > > > > >> > > > > > > >> > > > > Did you look up the sql "in" > > >> > > > > > >> > > > > >> > > > > >> > > > > >> > > > >> > > > >> > > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:370916 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
