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