- see footer for list info -<
Ooops ... that was complete [EMAIL PROTECTED] definately got a loop wrong there
....
This one works in milliseconds ....
<CFQUERY DATASOURCE="#Application.DocAdminDSN#" NAME="OuterLoop">
SELECT Document_ID, ID
FROM tbldetails
</CFQUERY>
<cfoutput query="outerloop">
<b>Outer Loop = <cfoutput>#tmp#</cfoutput></cfoutput></b><br />
<cfset tmp1=#Outerloop.Document_id#>
<cfset tmp2=#OuterLoop.ID#>
<CFQUERY DATASOURCE="#Application.DocAdminDSN#" NAME="InnerLoop">
DELETE FROM tbldetails
WHERE (document_id=#tmp1#) AND (ID <> #tmp2#)
</CFQUERY>
</cfoutput>
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
