I totally misinterpreted what you're trying to do, becuase you used
LIKE, where you wanted IN. I didn't look at the what the query was
trying to do as a whole, and realize you're using the wrong operator
like Charlie and Pascal did, I just saw the operator and used that as
my basis for what you we
Thanks Charlie and Pascal, both of yours worked. And thanks to Barney for
your input too. Can someone just quickly tell me again why the cfqueryparam
should be used.
Also Barney, so are you saying that the way mine is at the moment, with this
new code will it not work or will I come across some p
That's a singularly horrible way to store a relation.
First, the LIKE clause needs to have % at the front and back so that
it doesn't search for exactly the string, but rather for the string
with optional "stuff" at either end. Second, if the numbers aren't in
the order you provide them, or they'
WHERE articleID IN ()
Pascal
> -Original Message-
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: 16 November 2004 20:07
> To: CF-Talk
> Subject: WHERE LIKE
>
> Hi guys,
>
> Thanks for the help on the List Contains stuff, once I get the rest of
the
> app done I will try and make t
I think you want IN, not LIKE
WHERE articleID IN (#getArticle.articleRelatedLinks#)
will pull articles 26, 43, and 53.
On Tue, 16 Nov 2004 19:07:29 +, Stuart Kidd <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> Thanks for the help on the List Contains stuff, once I get the rest of the
> app done
5 matches
Mail list logo