List
On Fri, Jun 13, 2014 at 9:43 AM, 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:370927 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
