<cfquery name="views" datasource="#application.DSN#"> select * from tblindexpics where id IN (#piclist#) </cfquery>
You could even replace this with :
<cfquery name="views" dbtype="query"> SELECT * FROM GetPics WHERE ID IN (#piclist#) </cfquery>
That'll save you another hit on the db - seeing as you have all the data in memory already.
Stephen
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
