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