Hi guys,
I'm trying to create a loop for a query below. Instead of doing 5
queries I'd like to do just one loop.
Can anyone point out what I am doing wrong. How do I tell the process
to loop from the beginning stringList to the last?
<!--- this is the list containing tables names--->
<cfset stringList =
"Employment,Accommodation,Entertainment,LoveConnections,NoticeBoard">
<cfloop from="1" to="#StringList#" index="i">
<CFQUERY NAME="Get#StringList#Postings" DATASOURCE="020">
SELECT *
FROM #StringList#
WHERE UserListID = #URL.ViewID#
</CFQUERY>
</cfloop>
Thanks,
Saturday
---
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/
