Display a Query on a form

Get Started
1

Hi
Im wondering how I go about displaying a query the same as when I dump it out on screen, so it will display the results on a form for users to see, but not in as much detail as the query itself if that makes sence

for example When I press send on the form I want to see everything it has sent by email

2

<cfquery datasource=“#application.dsn#” name=“yourQuery”>
select * from user
</cfquery>

<table>

[INDENT][/INDENT]<cfoutput query=“yourQuery”>

[INDENT][INDENT][/INDENT][/INDENT]<tr>

[INDENT][INDENT]<td>#ID#</td>[/INDENT][/INDENT]

[INDENT][INDENT]<td>#Name#</td>[/INDENT][/INDENT]

[INDENT][INDENT]<td>#Address#</td>[/INDENT][/INDENT]

[INDENT][INDENT][/INDENT][/INDENT]</tr>

[INDENT][/INDENT]</cfoutput>
</table>

That what you mean?

3

perfect Clarkee21

Thanks

4

If you are new to CF, you might want to download and/or bookmark the documentation.