what does #request.sqlObjectPrefix# render out to?
On Fri, Jun 13, 2014 at 3:47 AM, Matthew Smith <chedders...@gmail.com> 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 <chumph...@gmail.com> > 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 <chedders...@gmail.com> > > wrote: > > > > > > > > How do you mean? Thanks! I tried a = as well... Didn't work either. > > > > > > > On Jun 12, 2014, at 23:03, LRS Scout <lrssc...@gmail.com> 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:370911 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
