K thanks everybody. i finally nutted out a solution. Thanks to Galipo
for the inspiration.
Here's how i did it:
<cfquery name="getList" datasource="#application.help_dsn#">
SELECT *
FROM tbl_calls
WHERE call_id IN (#form.listids#)
</cfquery>
<cfset something = arrayNew(1)>
<cfloop query="getList">
<cfset tf = arrayAppend(something, listFind(form.listids, call_id,
","))>
</cfloop>
<cfset tf = queryAddColumn(getList, "indexed", something)>
<cfquery name="getList2" dbtype="query">
SELECT *
FROM getList
ORDER BY indexed
</cfquery>
<cfdump var="#getList2#">
cheers
G
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
