<!--- Define the iFrame page --->
<CF_IF_IFRAME TITLE="iFrame demo - detail, detailform and barchart tags" STYLE="#client.i_style#" INCLUDE="/menu/menu.cfm">

<!--- Check the status of the detailform --->
<CFIF isDefined("newstatus_1")>
	<!--- The parameter "newstatus_1" was passed through --->
	<CFIF newstatus_1 IS "open">
		<!--- The status for the detailform is now "open", so we need to run the query --->
		<CFSET runquery = TRUE>
	<CFELSE>
		<!--- The status for the detailform is now "closed", so we don't need to run the query --->
		<CFSET runquery = FALSE>
	</CFIF>
<CFELSE>
	<CFSET runquery = TRUE>
</CFIF>

<CFIF runquery>
	<!--- Select the data which must be viewed --->
	<CFQUERY NAME="detail" DATASOURCE="iFrameDemo">
		SELECT *
		FROM drivers WHERE id = #id#
	</CFQUERY>
<CFELSE>
	<CFSET detail = QueryNew("dummy")>
</CFIF>

<TABLE WIDTH=100%>
<TR>
<TD WIDTH=50% VALIGN="top">

<!--- Call the detailform & detaillines --->
<CF_IF_DETAILFORM QUERY="detail" TITLE="Driver detail" HELP="help.html" EXCEL TABLE XML COLLAPSE COLLAPSEDEFAULT="open">
	<CF_IF_DETAILFORM_LINE CAPTION="First name"    DBFIELD="firstname">
	<CF_IF_DETAILFORM_LINE CAPTION="Last name"     DBFIELD="lastname">	
	<CF_IF_DETAILFORM_LINE CAPTION="Nationality"   DBFIELD="nationality" LOOKUPTABLE="Countries" LOOKUPFIELDVALUE="Description" LOOKUPFIELDID="Code" INFO="This is a lookup to table COUNTRIES">
	<CF_IF_DETAILFORM_LINE CAPTION="Date of birth" DBFIELD="dateofbirth" DBFORMAT="DATE" REPLACEEMPTYBY="No date available">
	<CF_IF_DETAILFORM_GROUP>
	<CF_IF_DETAILFORM_LINE CAPTION="Races"         DBFIELD="races">
	<CF_IF_DETAILFORM_LINE CAPTION="Races Won"     DBFIELD="won">
	<CF_IF_DETAILFORM_LINE CAPTION="WK Points"     DBFIELD="wkpoints">
	<CF_IF_DETAILFORM_LINE CAPTION="Fastest laps"  DBFIELD="fastestlaps">	
</CF_IF_DETAILFORM>
</TD>

<TD WIDTH=50% ALIGN="right">
	<CFIF runquery>
		<!--- Retrieve the data  --->
		<CFOUTPUT QUERY="detail">
			<CFSET driven = #races#>
			<CFSET won = #won#>
		</CFOUTPUT>
	
		<!--- Initialize the chart --->
		<CF_IF_BARCHART_INIT>
		
		<!--- Call the chart and define the bars --->
		<CF_IF_BARCHART TITLE="Races" SCALE="10" WIDTH=150 HEIGHT=200>
			<CF_IF_BARCHART_ROW DATA="#driven#"  LEGEND="Races driven">
			<CF_IF_BARCHART_ROW DATA="#won#" LEGEND="Races Won">
		</CF_IF_BARCHART>
	</CFIF>
</TD>
</TABLE>

<CFOUTPUT>
	<A HREF="viewsource.cfm?template=#CGI.CF_TEMPLATE_PATH#" TARGET="source">View source</A>
</CFOUTPUT>
</CF_IF_IFRAME>