ToHTML()

This function performs a very highly efficient conversion of a Query object to an HTML table.

Contents 1 Parameters 2 Returns 3 Example 4 Notes 5 Sample Output 6 Engine Compatibility

Parameters

ToHTML( query )

• query: this is main query object

Returns

This function returns back the query as a HTML formatted

Example

<cfset csv = ToHTML( myQry )>

Notes

This function does not touch the underlying query object. It will output the rows in the order to which they appear in the query object. The table is produced has the necessary tags, with classes to match to each of the query.

Sample Output

<table> 
	<thead> 
		<tr> 
			<th class='column1'>Id</th> 
			<th class='column2'>UUID</th> 
		</tr> 
	</thead> 
	<tbody> 
		<tr> 
			<td class='column1'>4044473</td> 
			<td class='column2'>4B26DADB-588C-48C8-A004-18979D9B24FA</td> 
		</tr> 
		<tr> 
			<td class='column1'>4044483</td> 
			<td class='column2'>A24E326A-8A36-4BFD-8D49-CA2BAA065653</td> 
		</tr> 
	</tbody>
</table>

Engine Compatibility

• OpenBD
• BlueDragon