cool final is below...
<cfparam name="reportName" default="" />
<cfset reportFile = expandPath("/Powerbase") & "/" & reportName & "." &
reportID & "_sql" />
<cfswitch expression="#op#">
<cfcase value="load">
<cffile action="READ" file="#reportFile#" variable="ff" />
<cfoutput>#ff#</cfoutput>
</cfcase>
<cfcase value="save">
<cfoutput>
<cfdump var="#form#">
<cfset qry = #form.queryToSave# />
<cffile action="WRITE" file="#reportFile#" output="#qry#"
nameconflict="OVERWRITE" />
<cfoutput>#reportName#</cfoutput> saved ...
</cfoutput>
</cfcase>
<cfcase value="list">
<cfdirectory action="LIST" directory="#expandPath('/Powerbase')#"
name="files" />
<cfoutput>
<ul class="treeview" id="treeview_#reportID#">
<li class="list">Saved sql files
<ul>
<cfloop query="files">
<cfif right(name, 4) is "_sql">
<li class="item">#listFirst(name, ".")#</li>
</cfif>
</cfloop>
</ul>
</li>
</ul>
</cfoutput>
</cfcase>
<cfdefaultcase>
</cfdefaultcase>
</cfswitch>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332412
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
