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