<!---
Name:        insert2.cfm
Author:      Ben Forta (ben@forta.com)
Description: Table row insertion demo
Created:     4/20/01
--->

<!--- Insert movie --->
<CFQUERY DATASOURCE="ows">
INSERT INTO Films(MovieTitle,
                  PitchText,
                  AmountBudgeted,
                  RatingID,
                  Summary,
                  ImageName,
                  DateInTheaters)
VALUES('#Trim(FORM.MovieTitle)#',
       '#Trim(FORM.PitchText)#',
       #FORM.AmountBudgeted#,
       #FORM.RatingID#,
       '#Trim(FORM.Summary)#',
       '#Trim(FORM.ImageName)#',
       #CreateODBCDate(FORM.DateInTheaters)#)
</CFQUERY>

<!--- Page header --->
<CFINCLUDE TEMPLATE="header.cfm">

<!--- Feedback --->
<CFOUTPUT>
<H1>New movie #FORM.MovieTitle# added</H1>
</CFOUTPUT>

<!--- Page footer --->
<CFINCLUDE TEMPLATE="footer.cfm">


