This content has been marked as final. Show 2 replies
I've managed to tidy this up a great deal and have fathomed a couple ofd places where I'm stuck.
<cfdump label="row content" var="#this_row_content#">
<cfdump label="cell content" var="#this_cell_content#">
are not working
<cfdump label="row content" var="#this_row_content#"> is outputting all rows in the query "table_field_content". whereas it was intended to only contain the single row whose value was set by #request.rowcounter#
<cfdump label="cell content" var="#this_cell_content#"> does the same. In addition when I want to output it I am going to need to refer to the table field names (which are in the query "table_fields"), yet I cannot reference them as the cfloop around the name of the field leaves and extra comma which creates a syntax error.
cfdump will output the entire content of the variable, be it a simple value or struct.
I would quickly build a database viewer like this:
<cfif isDefined("FORM.submit") and FORM.submit neq ''>
<cfquery name="tb_dump" datasource="#your_datasource#">
SELECT * FROM #FORM.db_tables#
<cfform name="db_dump" format="html" action="">
<cfinput type="submit" name="submit" value="Do it">
You could dynamically populate the select list from a query also.