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 problems? Thanks, Stu On 16/11/04 7:15 pm, "Pascal Peters" <[EMAIL PROTECTED]> wrote: > WHERE articleID IN (<cfqueryparam list="yes" cfsqltype="cf_sql_numeric" > value="#GetArticle.articleRelatedLinks#">) > > 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 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 >> >> <cfquery name="relatedArticles" datasource="user020"> >> SELECT articleID, articleTitle >> WHERE articleID LIKE '#GetArticle.articleRelatedLinks#' >> </cfquery> >> >> <cfif relatedArticles.RecordCount GT 0> >> Other articles that may relate to this story are:<br> >> <cfoutput query="relatedArticles">#articleTitle#</cfoutput> >> <cfelse>NOTHING here. >> >> </cfif> >> >> When I CFOUTPUT the relatedArticles it shows me 26,43,53 however when > I >> use >> the I try show the results in the <cfif> tag it actually thinks that > no >> articles have been pulled??? Strange, can anyone see what I am doing >> wrong? >> >> Thanks, >> >> Stu >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184449 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
