I figured it out. Simple and obvious now that its done. This isn't
the whole code of course but the essence is there. I have the full
routine wrapped in a more thorough try/catch and I'll probably add
cfrethrow into the inner one if I get ambitious. The cfoutputs inside
of the loop aren't the most efficient but I don't run something like
this very often so I can live with it. The whole thing, tables,
sequences and all ran in about 3 minutes.
<cfloop
from="1"
to="#ArrayLen(request.TableList)#"
index="ArrayRows">
<cftry>
<cfquery
username="#myDBUserName#"
password="#myDBPassword#"
datasource="myDSN#">
DROP TABLE #request.TableList[ArrayRows]#
</cfquery>
<cfoutput>#request.TableList[ArrayRows]#
deleted<br></cfoutput><cfflush>
<cfcatch type="Any">
<cfoutput>Table #request.TableList[ArrayRows]# not
found<br></cfoutput><cfflush>
</cfcatch>
</cftry>
</cfloop>
On Tue, 16 Nov 2004 09:19:23 -0800, Matt Robertson
<[EMAIL PROTECTED]> wrote:
> > hmmm.. if you don't have access then how can you maintain the tables
> > without the rights to alter them?
>
> I have the rights to alter them via ColdFusion. Only.
>
>
>
> --
> --Matt Robertson--
> President, Janitor
> MSB Designs, Inc.
> mysecretbase.com
>
--
--Matt Robertson--
President, Janitor
MSB Designs, Inc.
mysecretbase.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184409
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
