probably a missing double quote some place.
On Fri, 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:370924 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
