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