<!-- QueryExample.cfm -->
<CFQUERY NAME="QueryExample" DATASOURCE="QueryExampleData" MAXROWS=5>
	    SELECT * FROM Clients 
		     WHERE ClientName = '#ClientName#'
</CFQUERY>

<HTML>
<HEAD><TITLE>Query Example</TITLE></HEAD>

<CFOUTPUT QUERY="QueryExample">
	
<HR>
	
#ClientName# <BR> 
	
#Address1# <BR>
	
#Address2# <BR>
	
Phone ##: #Phone# <BR>
	
Fax ##: #Fax# <BR>
	
#Description#
</CFOUTPUT>

</HTML>


The CFML variable #ClientName# is set by the Web client user
in the following Web form:

<HTML>
<HEAD><TITLE>Query Example
Form</TITLE></HEAD>

<FORM ACTION="QueryExample.cfm" METHOD=POST>

<INPUT TYPE=TEXT NAME="ClientName" size=32 maxlength=80>
<INPUT TYPE=SUBMIT VALUE="Submit">

</FORM>
</HTML>
Which gives ...


[ MENU ]