Coldfusion MySQL multiple values in where statement

[demiancurran]

Hey there, I am trying to populate a cfloop using the following.

<cfquery name="notice" datasource="#DSN_DATASOURCE#" username="#DSN_USERNAME#" password="#DSN_PASSWORD#">
Select    *
From	  notice
Where 	id = "1,5,7"
</cfquery>

The problem is the 1,5,7 obviously. This info is coming through the url.id and I need to be able to loop through 1,5,7. Is there a way to do this?

Thanks in advance!

 

[r937]

WHERE id IN ( 1,5,7 )




r937.com | rudy.ca
Buy my new book Simply SQL from Amazon