What should they be? Thanks! > On Jun 13, 2014, at 9:40, Cameron Childress <camer...@gmail.com> wrote: > > > 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:370935 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
