Forgot the code
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="special" username="Admin">
INSERT INTO Prom_USA (First, Last, Address, City, State, Zip, Phone, Email)
VALUES (
<cfif IsDefined("FORM.First") AND #FORM.First# NEQ "">
'#FORM.First#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Last") AND #FORM.Last# NEQ "">
'#FORM.Last#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Address") AND #FORM.Address# NEQ "">
'#FORM.Address#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.City") AND #FORM.City# NEQ "">
'#FORM.City#'
<cfelse>
NULL
</cfif>
<cfif IsDefined("FORM.State") AND #FORM.State# NEQ "">
'#FORM.State#'
<cfelse>
NULL
</cfif>
<cfif IsDefined("FORM.Zip") AND #FORM.Zip# NEQ "">
'#FORM.Zip#'
<cfelse>
NULL
</cfif>
<cfif IsDefined("FORM.Phone") AND #FORM.Phone# NEQ "">
'#FORM.Phone#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.Email") AND #FORM.Email# NEQ "">
'#FORM.Email#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<cflocation url="http://www.promusa.biz">
</cfif><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>Prom Dresses Prom Gowns Shoes Handbags Shawls Dresses and Special
Occasion Accessories from PROM USA</title>
<!-- TemplateEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<META HTTP-EQUIV="Content-Language" CONTENT="EN-US">
<meta name="KEYWORDS" CONTENT="prom, prom dress, prom dresses, dress, dresse
s,
special occasion dress, special occasion dresses, prom gown, special, occasi
on
gown, shoes, prom shoes, prom dress shoes,
special occasion shoes, special occasion dress shoes, handbags, prom handbag
s,
prom dress handbags, special occasion handbags, shawls, prom shawls, prom dr
ess
shawls, special occasion shawls, accessories,
prom accessories, prom dress accessories, special occasion accessories">
<meta name="description" content="Prom dresses, Prom gowns, shoes, handbags,
shawls and special occasion dress and prom accessories at PROM USA">
<meta name="ROBOTS" content="INDEX, FOLLOW">
<meta name="rating" content="general">
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<SCRIPT type="text/javascript"></script>
<SCRIPT type="text/javascript" src="/Navigation/mm_menu.js"></script>
</head>
<body>
<div align="right" class="Addresstxt"><a
href="http://www.promusa.biz/sitemap.htm">Site Map</a></div>
<table width="100%" border="2" cellspacing="2" cellpadding="2">
<tr>
<td><a href="http://www.promusa.biz"><img src="/images/Logo.jpg"
width="360" height="126" border="0" alt="Prom Dresses Prom Gowns Shoes Handb
ags
Shawls Dresses and Special Occasion Accessories from PROM USA"></a></td>
</tr>
<tr>
<td><div align="center">
<SCRIPT type="text/javascript"
src="/Navigation/mm_menu.js">mmLoadMenus();</script>
<SCRIPT type="text/javascript">mmLoadMenus();</script>
<img name="promusa" src="/Navigation/images/promusa.jpg" width="600"
height="40" border="0" usemap="#m_promusa" alt="Prom Dresses Prom Gowns Shoe
s
Handbags Shawls Dresses and Special Occasion Accessories from PROM USA">
<map name="m_promusa">
<area shape="rect" coords="482,7,600,32" href="#" alt=""
onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0302015249_0,482,32,null,'promusa');
" >
<area shape="poly" coords="0,7,118,7,118,33,0,33,0,7" href="#" alt=""
onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0302001057_0,0,34,null,'promusa');"
>
<area shape="poly" coords="362,6,480,6,480,32,362,32,362,6" href="#"
alt="" onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0123160143_0,382,32,null,'promusa');
" >
<area shape="poly" coords="118,7,236,7,236,33,118,33,118,7" href="#"
alt="" onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0123155339_2,149,32,null,'promusa');
" >
<area shape="poly" coords="118,7,236,7,236,33,118,33,118,7" href="#"
alt="" onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0123155339_2,115,32,null,'promusa');
" >
<area shape="poly" coords="239,7,357,7,357,33,239,33,239,7" href="#"
alt="" onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0123155953_1,239,33,null,'promusa');
" >
<area shape="poly" coords="238,7,356,7,356,33,238,33,238,7" href="#"
alt="" onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0123155953_1,236,33,null,'promusa');
" >
<area shape="poly" coords="0,7,118,7,118,33,0,33,0,7" href="#" alt=""
onMouseOut="MM_startTimeout();"
onMouseOver="MM_showMenu(window.mm_menu_0302001057_0,0,8,null,'promusa');"
>
<area shape="rect" coords="363,32,368,33" href="#" alt="" >
</map>
</div></td>
</tr>
<tr>
<td><!-- TemplateBeginEditable name="Body" -->
<div align="center">
<form method="post" name="form1"
action="<cfoutput>#CurrentPage#</cfoutput>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">First:</td>
<td><input type="text" name="First" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Last:</td>
<td><input type="text" name="Last" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Address:</td>
<td><input type="text" name="Address" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">City:</td>
<td><input type="text" name="City" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">State:</td>
<td><input type="text" name="State" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Zip:</td>
<td><input type="text" name="Zip" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Phone:</td>
<td><input type="text" name="Phone" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Email:</td>
<td><input type="text" name="Email" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_InsertRecord" value="form1">
</form>
<p> </p>
</div>
<!-- TemplateEndEditable --></td>
</tr>
</table>
<div align="center">
<p><a class="footer" href="http://www.promusa.biz/Sitemap.htm">Site map</a>
|
<a class="footer" href="http://www.promusa.biz/">Prom Dresses</a> |
<a class="footer" href="http://www.promusa.biz">Bridemaid Dresses</a> |
<a class="footer" href="http://www.promusa.biz">Wedding Dresses</a><br>
<a class="footer" href="http://www.promusa.biz">Pageant Dresses</a> |
<a class="footer" href="http://www.promusa.biz">Closeout</a> |
<a class="footer" href="http://www.promusa.biz">Accessories</a><br>
2080 (Suite G) Fairburn Road Douglasville, Ga 30336<br>
(770) 942-2896 (Phone) (770) 920-2513
(Fax) <a href="mailto:promusa1@aol.com">Contact us</a></p>
</div>
</body>
</html>
|