from what I see, lists of numbers. 12,45,7,0
On Fri, Jun 13, 2014 at 9:59 AM, LRS Scout <[email protected]> wrote: > Ok, so troll face avatar > > Is this real? > > > On Fri, Jun 13, 2014 at 9:57 AM, Matthew Smith <[email protected]> > wrote: > >> >> What should they be? Thanks! >> >> > On Jun 13, 2014, at 9:40, 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:370937 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
