77, 101 ish > On Jun 13, 2014, at 9:43, LRS Scout <[email protected]> wrote: > > > What are the values of orderKeyLisy and personKeyList? > > > On Fri, Jun 13, 2014 at 9:40 AM, Cameron Childress <[email protected]> > wrote: > >> >> The cffunction tags in my example for cftry were just placeholders. >> >>>> On Jun 13, 2014, at 9:38 AM, Matthew Smith <[email protected]> >>> 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 < >>> [email protected]> wrote: >>> >>>> >>>> i dunno, I call them stupid procedures ;) >>>> >>>> >>>>> On Fri, Jun 13, 2014 at 8:10 AM, LRS Scout <[email protected]> wrote: >>>>> >>>>> >>>>> That should have read stored, not stupid, sorry >>>>>> On Jun 13, 2014 9:07 AM, "LRS Scout" <[email protected]> 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" <[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> >>>>>>> >>>>>>> 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:370931 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
