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