they see, and comprehend, then can
take that knowledge with them for the next time they run into that prob.
in case you didn't already know this :)
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:33 AM
To: CF-Talk
Subject: RE: cfquery + list
Misunderstood what your email was asking.
The <CFQUERYPARAM VALUE="#attributes.myList#"
>CFSQLTYPE="CF_SQL_VARCHAR" LIST="Yes"> suggested by Mike Townend was
>the
solution I first tried to implement and worked. All the other solutions
may be valid; I'm unsure since I haven't tested them.
Once again thanks.
At 11:22 AM 10/7/2003 -0400, you wrote:
>and the winner was?
>
>...tony
>
>tony weeg
>senior web applications architect
>navtrak, inc.
>www.navtrak.net
>[EMAIL PROTECTED]
>410.548.2337
>
>-----Original Message-----
>From: Won Lee [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 07, 2003 11:23 AM
>To: CF-Talk
>Subject: RE: cfquery + list
>
>We got a winner.
>Thanks.
>Thanks to everyone else that helped as well.
>
>At 04:13 PM 10/7/2003 +0100, you wrote:
> >something like
> >
> >
> ><cfquery name="blah" ...>
> >select PKID
> >from myTable
> >where name not in (<CFQUERYPARAM VALUE="#attributes.myList#"
> >CFSQLTYPE="CF_SQL_VARCHAR" LIST="Yes">) </cfquery>
> >
> >
> >altho make sure that there is something in the list... an empty list
> >will throw an error
> >
> >
> >HTH
> >
> >-----Original Message-----
> >From: Won Lee [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, October 7, 2003 16:06
> >To: CF-Talk
> >Subject: cfquery + list
> >
> >Hello,
> >
> >Let's say I have a list:
> ><cfset attributes.myList = "John, Amy">
> >
> >How can I do a query that would take that list and do a not in?
> >
> ><cfquery name="blah" ...>
> >select PKID
> >from myTable
> >where name not in ('#attributes.myList#') </cfquery>
> >
> >(This codes doesn't work)
> >
> >CF 5.0
> >
> > _____
> >
> >
> >----------
> >[
>________________________________
>
>
>----------
>[
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
