|
| |
|
|
mfrankel46
Posts: 3
Joined: 12/31/2007
Status: offline
 |
Frontpage & MySQL - 12/31/2007 4:27:27
I'm trying to have a frontpage generated form submit information to a MySQL db. The entire form works EXCEPT for the text area box. It's supposed to be submitting to a text field but doesn't at all. All of the other fields work. Any ideas why?
|
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Frontpage & MySQL - 12/31/2007 7:09:32
Try putting the memo(text area) column as the last column in your database as well as in the form.
_____________________________
William Lee
| |
|
|
|
mfrankel46
Posts: 3
Joined: 12/31/2007
Status: offline
|
RE: Frontpage & MySQL - 1/1/2008 19:29:53
This didn't really seem to work. Any idea why? Any other ideas?
| |
|
|
|
William Lee
Posts: 1041
Joined: 1/25/2002
From: Singapore
Status: offline
|
RE: Frontpage & MySQL - 1/1/2008 19:41:01
quote:
ORIGINAL: mfrankel46
This didn't really seem to work. Any idea why? Any other ideas?
Any URL? Any code?
_____________________________
William Lee
| |
|
|
|
mfrankel46
Posts: 3
Joined: 12/31/2007
Status: offline
|
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>
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
