|
mfrankel46 -> RE: Frontpage & MySQL (1/1/2008 21:14:40)
|
http://www.specialsbyzip.com/reviews/review_form.asp
<form METHOD="POST" action="--WEBBOT-SELF--" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="SBZ-MySQL" S-RecordSource="participantreviews" S-Form-Fields="ScoreFoodQuality ScoreFoodTaste Title ScoreService ScoreValue Review Reviewer Statement EmailAddress ParticipantID ScoreAtmosphere" S-Form-DBFields="ScoreFoodQuality ScoreFoodTaste Title ScoreService ScoreValue Review Reviewer Statement EmailAddress ParticipantID ScoreAtmosphere" U-ASP-Include-Url="../_fpclass/fpdbform.inc" startspan U-Confirmation-Url="../subscribers/thankyou-review.asp" U-Validation-Error-Url="../subscribers/sorry-review.asp" S-Builtin-Fields="HTTP_USER_AGENT Timestamp" S-Builtin-DBFields="IPAddress Date" --><!--webbot bot="SaveDatabase" endspan -->
<table border="0" width="43%" cellspacing="0" cellpadding="0" id="table1">
<tr>
<td width="80%" colspan="2"><font face="Verdana">
<font style="font-size: 8pt">Your E-mail Address (optional, will not
appear on site):<br>
</font>
<span style="font-size: 8pt">
<input type="text" name="EmailAddress" size="76" tabindex="1"></span></font></td>
</tr>
<tr>
<td width="30%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">
Establishment:</font></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="64%" colspan="2"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ParticipantID" tabindex="3">
<%
Set SBZRs = Server.CreateObject("ADODB.Recordset")
SBZRs.ActiveConnection = myConnection
SBZRs.CursorType = adOpenStatic
SBZsqlstring = "Select * from specialsbyzip.participant order by participant_name asc"
SBZRs.Open SBZsqlstring
do until SBZRs.EOF
response.Write("<option value="&replace(SBZRs.fields("Participant_id")," ","")&">"& SBZRs.fields("Participant_name") & "</option>")
SBZRs.MoveNext
loop
SBZRs.Close
Set SBZRs = Nothing
%>
</select></span></font></td>
</tr>
<tr>
<td width="30%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td width="30%"><b>
<font face="Verdana" style="font-size: 8pt">
Ratings:</font></b></td>
<td width="34%"> </td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">Taste of
Food:</font></td>
<td width="34%"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ScoreFoodTaste" tabindex="3">
<option selected value=" ">---</option>
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select></span></font></td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">Quality of
Food:</font></td>
<td width="34%"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ScoreFoodQuality" tabindex="4">
<option selected>---</option>
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select></span></font></td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">Value
Received for Price Paid:</font></td>
<td width="34%"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ScoreValue" tabindex="5">
<option selected>---</option>
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select></span></font></td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">Service:</font></td>
<td width="34%"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ScoreService" tabindex="6">
<option selected>---</option>
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select></span></font></td>
</tr>
<tr>
<td width="30%">
<font face="Verdana" style="font-size: 8pt">
Atmosphere:</font></td>
<td width="34%"><font face="Verdana">
<span style="font-size: 8pt">
<select size="1" name="ScoreAtmosphere" tabindex="7">
<option selected>---</option>
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select></span></font></td>
</tr>
<tr>
<td width="30%"> </td>
<td width="34%"> </td>
</tr>
<tr>
<td colspan="2"><font face="Verdana">
<font style="font-size: 8pt">Name
to Appear with Review (optional):<br>
</font>
<span style="font-size: 8pt">
<input type="text" name="Reviewer" size="76" tabindex="8"></span></font></td>
</tr>
<tr>
<td colspan="2"><font face="Verdana">
<font style="font-size: 8pt">
Title of Your Review:<br>
</font>
<span style="font-size: 8pt">
<input type="text" name="Title" size="76" tabindex="9"></span></font></td>
</tr>
<tr>
<td colspan="2">
<font face="Verdana" style="font-size: 8pt">
Write Your Review:</font></td>
</tr>
<tr>
<td colspan="2"><font face="Verdana">
<span style="font-size: 8pt">
<!--webbot bot="Validation" i-maximum-length="25000" --><textarea name="Review" cols="50" rows="10" id="Review" tabindex="11"></textarea></span></font></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><font face="Verdana" style="font-size: 8pt">
I have read and agree to SpecialsByZip.com's review
policy.<br>
</font></td>
</tr>
</table>
<input type="submit" value="Submit" name="Submit" tabindex="13" style="font-family: Verdana; font-size: 8pt"></p>
</form>
|
|
|
|
