<!--- Define the iFrame page --->
<CF_IF_IFRAME TITLE="iFrame demo - form" STYLE="#client.i_style#" INCLUDE="/menu/menu.cfm">

<!--- Built the query for "nationality" select box --->
<CFQUERY NAME="nat" DATASOURCE="iFrameDemo">
	SELECT * FROM countries ORDER BY description
</CFQUERY>

<CFQUERY NAME="drivers" DATASOURCE="iFrameDemo">
	SELECT *
	FROM Drivers WHERE id=#id#
</CFQUERY>

<!--- Define the form --->
<CF_IF_FORM TITLE="Edit driver" HELP="help.html" RELOADABLE ACTION="ex_form.cfm" BUTTON="Edit" STATUSTEXT="This the status bar" QUERY="drivers">
	<CF_IF_FIELD NAME="id"  TYPE="HIDDEN" VALUE="#id#">	
	<CF_IF_FIELD CAPTION="Id" NAME="id" DBFIELD="id" TYPE="VISIBLE">	
	<CF_IF_FIELD CAPTION="First name" NAME="firstname" DBFIELD="firstname" SIZE=20 MAXLENGTH="100" TRANSFORM="capitalize" MANDATORY>
	<CF_IF_FIELD CAPTION="Last name" NAME="lastname" DBFIELD="lastname" SIZE=30 MAXLENGTH="200" TRANSFORM="uppercase" LOOKUP="lk_drivers.cfm" LOOKUPVALUEFIELD="pvalue" READONLY>
	<CF_IF_FIELD CAPTION="New id" NAME="pvalue" DBFIELD="id" SIZE=20 MAXLENGTH="100" READONLY DISABLED>
	<CF_IF_SELECT CAPTION="Nationality" RELOADONCHANGE NAME="nationality" DBFIELD="nationality" QUERY="nat" VALUE="code" DISPLAY="description" EMPTY MANDATORY INFO="This select box get his values from table COUNTRIES">
	</CF_IF_SELECT>
	
	<CF_IF_FIELD CAPTION="Date of birth"  NAME="dateofbirth"  DBFIELD="dateofbirth" SIZE=30 MAXLENGTH="200" TYPE="DATE" MANDATORY DATEPICKER>
	
	<CF_IF_FORM_GROUP>
	
	<CF_IF_FIELD CAPTION="Races"        TYPE="integer" NAME="races"       DBFIELD="races" SIZE=2 MAXLENGTH=2>
	<CF_IF_FIELD CAPTION="Races won"    TYPE="integer" NAME="won"         DBFIELD="won"   SIZE=2 MAXLENGTH=2>
	<CF_IF_FIELD CAPTION="WK points"    TYPE="integer" NAME="wkpoints"    DBFIELD="wkpoints" SIZE=2 MAXLENGTH=3>
	<CF_IF_FIELD CAPTION="Fastest laps" TYPE="integer" NAME="fastestlaps" DBFIELD="fastestlaps" SIZE=2 MAXLENGTH=2>
		
	<CF_IF_CHECKBOX CAPTION="Lives in" LINEBREAK>
		<CF_IF_CHECKBOX_ITEM CAPTION="Monaco"      DBFIELD="monaco" NAME="monaco">
		<CF_IF_CHECKBOX_ITEM CAPTION="Own country" DBFIELD="home"    NAME="own">
	</CF_IF_CHECKBOX>
	
	<CF_IF_RADIO CAPTION="Owns a plane?" NAME="plane" DBFIELD="plane">
		<CF_IF_RADIO_ITEM CAPTION="Yes" VALUE="1" CHECKED>
		<CF_IF_RADIO_ITEM CAPTION="No"  VALUE="0">
	</CF_IF_RADIO>
</CF_IF_FORM>

<P>
<I>Please note that this form has no action attached behind.</I> 
<P>
<CFOUTPUT>
	<A HREF="viewsource.cfm?template=#CGI.CF_TEMPLATE_PATH#" TARGET="source">View source</A>
</CFOUTPUT>

</CF_IF_IFRAME>