The cffunction tags in my example for cftry were just placeholders. > On Jun 13, 2014, at 9:38 AM, Matthew Smith <chedders...@gmail.com> wrote: > > > weird error, it has a stupid name > > 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 CFFUNCTION. It requires the attribute(s): NAME. > > The CFML compiler was processing: > > - A cffunction tag beginning on line 832, column 4. > - A cffunction tag beginning on line 832, column 4. > > The error occurred > in*D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/cfcs/qry-todatabase.cfc: > line 832* > *Called from* D:/Inetpub/redhotkitties/cfcs/paypal.cfc: line 242 > *Called from* > > > On Fri, Jun 13, 2014 at 9:21 AM, Zaphod Beeblebrox < > zaph0d.b33bl3b...@gmail.com> wrote: > >> >> i dunno, I call them stupid procedures ;) >> >> >>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout <lrssc...@gmail.com> wrote: >>> >>> >>> 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:370925 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
