It's from reddit 4 ever alone > On Jun 13, 2014, at 9:59, 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:370938 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
