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:370936 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
