That should have read stored, not stupid, sorry On Jun 13, 2014 9:07 AM, "LRS Scout" <lrssc...@gmail.com> wrote:
> That's the big int vs int thing again. > > Also, your error messages are gonna suck in a stupid procedure. > > If I were you I would write the sql out side of query tags and output it > to the screen so you can see all the values. > On Jun 13, 2014 8:49 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"> >> >> >> >> >> On Fri, Jun 13, 2014 at 8:43 AM, LRS Scout <lrssc...@gmail.com> 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" <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> >> > > >> > > >> > > On Fri, Jun 13, 2014 at 8:02 AM, Matthew Smith <chedders...@gmail.com >> > >> > > wrote: >> > > >> > > > I fixed that, thanks. >> > > > >> > > > >> > > > On Fri, Jun 13, 2014 at 7:57 AM, Zaphod Beeblebrox < >> > > > zaph0d.b33bl3b...@gmail.com> wrote: >> > > > >> > > >> >> > > >> what does #request.sqlObjectPrefix# render out to? >> > > >> >> > > >> >> > > >> On Fri, Jun 13, 2014 at 3:47 AM, Matthew Smith < >> chedders...@gmail.com >> > > >> > > >> 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 < >> > > >> chumph...@gmail.com> >> > > >> > 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 < >> > > >> chedders...@gmail.com> >> > > >> > > wrote: >> > > >> > > >> > > >> > > > >> > > >> > > > How do you mean? Thanks! I tried a = as well... Didn't work >> > > either. >> > > >> > > > >> > > >> > > > > On Jun 12, 2014, at 23:03, LRS Scout <lrssc...@gmail.com> >> > > 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:370919 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
