Are you trying to loop over the array and query the db based on the current id from the iteration, shouldn't your code then be:
<cfloop from="1" to="#arraylen(custOpsShout_pageID)#" index="i"> <cfquery name="getShoutStories" DATASOURCE="#Application.DSN#"> SELECT * FROM #Application.tablePrefix#TABLESTORY WHERE STATUS ='1' AND PAGEID = '#custOpsShout_pageID[i]#' AND STORYORDER = '0' </cfquery> </cfloop>
or are you trying to do something different?
Andrew
Hickman, Matt wrote:
<!--- let's grab the story from each of the pageID's in the array above --->
<cfquery name="getShoutStories" DATASOURCE="#Application.DSN#">
SELECT *
FROM #Application.tablePrefix#TABLESTORY
WHERE STATUS ='1' AND PAGEID = '(<cfloop from="1" to="#arraylen(custOpsShout_pageID)#"
index="i">#custOpsShout_pageID#</cfloop>)'
AND STORYORDER = '0'
</cfquery>
-- Andrew Muller Senior Macromedia Certified Instructor - ColdFusion, Flash Certified Advanced Macromedia ColdFusion Developer - CF5, CFMX Certified Macromedia Flash Developer - FL5, FMX
Daemon Internet Consultants [EMAIL PROTECTED] http://www.daemon.com.au/training T:61 2 9380 4162 F:61 2 9380 4204 17 Roslyn Gardens Elizabeth Bay NSW 2011 AUSTRALIA
Daemon: Serious Web Development
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
