MySQL db - data not saved (Using Frontpage ASP)

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I have set up a MySQL db on one server, IIS 6.0 on another. Using
Frontpage I created some forms to input data. On a test page I made, I
have 4 fields. First is the ID which is autonumber (I leave alone). The
second is marked as TEXT, the third is MEDIUMTEXT, and the fourth is
DATE. This is just an example though, the problem exists in no matter
what manner I create the form.

Now here is the issue. In the TEXT fields nothing is saved into the db.
But whatever I put in the DATE field is saved. I played around a bit and
found if I put in a single letter (a for example) it will be saved in
the TEXT fields. If I put in "aa" it will not save.

Now if I create a form that is to accept just 4 fields of a numbers the
form will work properly. I.e. a form made for inputing IP addresses and
telephone numbers will work. Once I add a field for a name then the form
will only save the number.

Yet in the db itself I have no issues putting in long text phrase into
the same field (Using OpenOffice). Therefore I assume this is some issue
on how either Frontpage created the form or the webserver is sending the
data. Is there anything special I need to do to get a from made with
Frontpage to work with MySQL db? I have made numerous forms to use a MS
Access db without any issue.

Below is the code used for a test page-

' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("MySQL_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open "categories", fp_conn, 1, 3, 2 ' adOpenKeySet,
adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(3)
Dim arFormDBFields0(3)
Dim arFormValues0(3)

arFormFields0(0) = "CategoryID"
arFormDBFields0(0) = "CategoryID"
arFormValues0(0) = Request("CategoryID")
arFormFields0(1) = "CategoryName"
arFormDBFields0(1) = "CategoryName"
arFormValues0(1) = Request("CategoryName")
arFormFields0(2) = "ID"
arFormDBFields0(2) = "ID"
arFormValues0(2) = Request("ID")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

FP_DumpError strErrorUrl, "Cannot update the database"


FP_FormConfirmation "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")


<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">


<form method="POST" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp"
S-DataConnection="MySQL" S-RecordSource="categories"
S-Form-Fields="CategoryID CategoryName ID" S-Form-DBFields="CategoryID
CategoryName ID" U-ASP-Include-Url="_fpclass/" startspan
--><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include
file="_fpclass/"--><!--webbot bot="SaveDatabase"
i-checksum="40548" endspan -->
<p> </p>
<table border="1" width="100%" id="table1">
<td><input type="text" name="ID" size="20"></td>
<td><input type="text" name="CategoryID" size="20"></td>
<td><input type="text" name="CategoryName" size="20"></td>
<p><input type="submit" value="Submit" name="B1"><input type="reset"
value="Reset" name="B2"></p>

Re: MySQL db - data not saved (Using Frontpage ASP)

On Sat, 24 Sep 2005 15:26:16 -0500, Sam White wrote:

Quoted text here. Click to load it

Try creating an example form in OpenOffice - it will create html files. I
don't know about its ability to create ASP's, though.  I prefer to develop
using .cgi or .php over .asp.

I think what you are experiencing is one of MS's unadvertised 'features' -
vendor lock-in.  Notice how it works when EVERYTHING involved comes from

Apache, PHP, perl, and OpenOffice are all available (for free) for
Windows, but I would set the whole thing up to run on Linux or FreeBSD and
run completely sans Microsoft.

Ever hear of the LAMP stack?  Linux, Apache, MySQL, PHP.  Very popular,
and works well.  You could run it on Windows, then it would be WAMP.  You
may even be able to get away with IIS instead of Apache - ha ha, then it
would be WIMP! ;-)

Re: MySQL db - data not saved (Using Frontpage ASP)

I think you are absolutely correct in that this is another example of
MS's unadvertised features. I know from past that SQL server has no
issues with Frontpage, but MySQL seems to be a different issue. And
there is not a chance in hell I will switch to that resource hog called
SQL server. I have a MySQL db that is now twice what it was when it was
in SQL, and yet uses less memory.

I have looked all over the internet and the closest I could find is
another person back in 2004 who had the same issue but there were no

I do have openoffice and in fact tried to use that without success.
Basically without programming knowledge of any kind I was trying to set
up forms to update and input data into a db from the web. I think at
this point I am going to look at PHP. There is some software out there
that is supposed to make these forms for you (for code clueless people
like me), but none of the software works at all. ASPRunner doesnt even
bother to generate most of the needed files, what a joke.

Mike A. wrote:
Quoted text here. Click to load it

Site Timeline