roropacific
IS-IT--Management
Hello
I have created this form for output I do not get any results. What I am doing wrong?
I have a different form that works fine.
<html>
<head>
<meta HTTP-EQUIV="Content-Type" CONTENT="TEXT"/html; charset=windows-1252">
<meta HTTP-EQUIV="Content-Language" CONTENT="en-us">
<title>Customer Service FeedBack Form</title>
</head>
<body>
<h1>Customer Service FeedBack Form</h1>
<FORM method="post" action="insertdata.cfm">
<li>
<p><em>Service Agent</em>
<input TYPE="TEXT" NAME="user_name" SIZE="25"></p>
<li>
<p><em>Model Number</em>
<input TYPE="TEXT" NAME="Product_Model" SIZE="25"></p>
<li>
<p>Issue Title</p>
<p><TEXTAREA name=Summary cols=35></TEXTAREA><br>
</p>
<li>
<p>Issue Description</p>
<p><TEXTAREA name=Description rows=5 cols=35></TEXTAREA><br>
</p>
<li>
<p>Please provide the following contact information:</p>
<p><em>First Name</em>
<input type="TEXT" NAME="Contact_FirstName" SIZE="25"></p>
<p><em>Last Name</em></td>
<input type="TEXT" NAME="Contact_LastName" SIZE="25"></p>
<p><em>Street Address</em>
<input type="TEXT" NAME="Contact_StreetAddress" SIZE="25"></p>
<p><em>Address (cont.)</em>
<p><input type="TEXT" NAME="Contact_Address2" SIZE="25"></p>
<p><em>City</em>
<input type="TEXT" NAME="Contact_City" SIZE="25"></p>
<p><em>State/Province</em>
<input type="TEXT" NAME="Contact_State" SIZE="2"></p>
<p><em>Zip/Postal Code</em>
<input type="TEXT" NAME="Contact_ZipCode" SIZE="10" MAXLENGTH="10"></p>
<p><em>Home Phone</em>
<input type="TEXT" NAME="Contact_HomePhone" SIZE="12" MAXLENGTH="12"></p>
<p><em>E-mail</em>
<input type="TEXT" NAME="Contact_Email" SIZE="25"></p>
<li>
<p>Enter the date of Purchase :</p>
<p><input type="TEXT" NAME="purchaseDate" size="10" MAXLENGTH="10">
</p>
<li>
<p>Location of Purchase</p>
<p><input type="TEXT" NAME="purchaseplace" SIZE="50" MAXLENGTH="50"><br></P>
<OL></OL>
<input type=submit value="Add Customer">
<input type=reset value="Reset Form">
<A href="menu1.htm"> View Reports</A>
<A href="search1.htm"> Search for Product ID</A>
<A href="search2.htm"> Search for Keyword</A>
</LI>
</body>
</HTML>
</form>
and the action form named insertdata.cfm
<CFQUERY NAME="adduser" DATASOURCE="custsrvc">
INSERT INTO complaint
(product_id,
issue_summary,
issue_description,
DateofPurchase ,
LocationofPurchase,
custfirstname ,
custlastname ,
custaddress ,
custaddress2 ,
custcity,
custstate,
custzip,
custphone ,
custemail ,
currentdate,
username)
VALUES
('#form.product_model#',
'#form.summary#',
'#form.description#',
'#form.purchasedate#',
'#form.purchaseplace#',
'#form.contact_firstname#',
'#form.contact_lastname#',
'#form.cont_streetaddress#',
'#form.contact_address2#',
'#form.contact_city#',
'#form.contact_state#',
'#form.contact_zipcode#',
'#form.contact_homephone#',
'#form.contact_email#',
'#form.purchasedate#',
'#form.user_name#')
</CFQUERY>
<html>
<head>
<title> Add Customer</title>
</head>
<body>
Record added.
<br><br>
<A href="customerservice1.cfm"> Back</A>
</br></br>
</body>
</html>
I have created this form for output I do not get any results. What I am doing wrong?
I have a different form that works fine.
<html>
<head>
<meta HTTP-EQUIV="Content-Type" CONTENT="TEXT"/html; charset=windows-1252">
<meta HTTP-EQUIV="Content-Language" CONTENT="en-us">
<title>Customer Service FeedBack Form</title>
</head>
<body>
<h1>Customer Service FeedBack Form</h1>
<FORM method="post" action="insertdata.cfm">
<li>
<p><em>Service Agent</em>
<input TYPE="TEXT" NAME="user_name" SIZE="25"></p>
<li>
<p><em>Model Number</em>
<input TYPE="TEXT" NAME="Product_Model" SIZE="25"></p>
<li>
<p>Issue Title</p>
<p><TEXTAREA name=Summary cols=35></TEXTAREA><br>
</p>
<li>
<p>Issue Description</p>
<p><TEXTAREA name=Description rows=5 cols=35></TEXTAREA><br>
</p>
<li>
<p>Please provide the following contact information:</p>
<p><em>First Name</em>
<input type="TEXT" NAME="Contact_FirstName" SIZE="25"></p>
<p><em>Last Name</em></td>
<input type="TEXT" NAME="Contact_LastName" SIZE="25"></p>
<p><em>Street Address</em>
<input type="TEXT" NAME="Contact_StreetAddress" SIZE="25"></p>
<p><em>Address (cont.)</em>
<p><input type="TEXT" NAME="Contact_Address2" SIZE="25"></p>
<p><em>City</em>
<input type="TEXT" NAME="Contact_City" SIZE="25"></p>
<p><em>State/Province</em>
<input type="TEXT" NAME="Contact_State" SIZE="2"></p>
<p><em>Zip/Postal Code</em>
<input type="TEXT" NAME="Contact_ZipCode" SIZE="10" MAXLENGTH="10"></p>
<p><em>Home Phone</em>
<input type="TEXT" NAME="Contact_HomePhone" SIZE="12" MAXLENGTH="12"></p>
<p><em>E-mail</em>
<input type="TEXT" NAME="Contact_Email" SIZE="25"></p>
<li>
<p>Enter the date of Purchase :</p>
<p><input type="TEXT" NAME="purchaseDate" size="10" MAXLENGTH="10">
</p>
<li>
<p>Location of Purchase</p>
<p><input type="TEXT" NAME="purchaseplace" SIZE="50" MAXLENGTH="50"><br></P>
<OL></OL>
<input type=submit value="Add Customer">
<input type=reset value="Reset Form">
<A href="menu1.htm"> View Reports</A>
<A href="search1.htm"> Search for Product ID</A>
<A href="search2.htm"> Search for Keyword</A>
</LI>
</body>
</HTML>
</form>
and the action form named insertdata.cfm
<CFQUERY NAME="adduser" DATASOURCE="custsrvc">
INSERT INTO complaint
(product_id,
issue_summary,
issue_description,
DateofPurchase ,
LocationofPurchase,
custfirstname ,
custlastname ,
custaddress ,
custaddress2 ,
custcity,
custstate,
custzip,
custphone ,
custemail ,
currentdate,
username)
VALUES
('#form.product_model#',
'#form.summary#',
'#form.description#',
'#form.purchasedate#',
'#form.purchaseplace#',
'#form.contact_firstname#',
'#form.contact_lastname#',
'#form.cont_streetaddress#',
'#form.contact_address2#',
'#form.contact_city#',
'#form.contact_state#',
'#form.contact_zipcode#',
'#form.contact_homephone#',
'#form.contact_email#',
'#form.purchasedate#',
'#form.user_name#')
</CFQUERY>
<html>
<head>
<title> Add Customer</title>
</head>
<body>
Record added.
<br><br>
<A href="customerservice1.cfm"> Back</A>
</br></br>
</body>
</html>