Re: WHERE LIKE

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

Re: WHERE LIKE

ECTED] >> 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 the separate Relations table. >>

Re: WHERE LIKE

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'

RE: WHERE LIKE

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 >

Re: WHERE LIKE

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

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 the separate Relations table. I'm having problems with the LIKE function in SQL. In my relatedArticles field I have numbers like 26,43,53 SELECT articleID, articleTitle WHERE articl