I am very familiar with MS Access and VBA, so when my choir's committee said they would like the members details on a database on the website I volunteered to do the programming. Well, 12 months later, I have learnt about FPSE, a little JavaScript, found that VBScript is similar to VBA but different. I have eventually written a simple new member data input form, which worked, adding the input data to my MS Access database on the server. But when I then tried to add data-validation routines, the form stopped adding data to my database. This is just one of many 'problems' I have encountered in the last year, where I do not know whether something is not working as expected because of the code I have written, or whether FrontPage is doing something weird, like swapping over my surname and first_name fields for no seeable reason. I am at the end of my tether with it. So I thought I would investigate alternatives. I have found from the Internet today that one or two other people have had problems with FrontPage! DreamWeaver seems to be favoured, but what I don't understand is how to substitute it for FrontPage, and what the equivalent of FPSEs are? What kind of server am I looking for? What kind of database works with it? I really don't want to go to too much more expense, as we do not have the funds. I am using my own copy of MS Access 2003 and FrontPage 2002. I am sorry if I have posted this in the wrong forum and would be grateful for directions to an appropriate forum. Eddie
In my opinion, FrontPage or Dreamweaver should have nothing to do with this because you are talking about database management. But I could be wrong. You probably need to work on web server, provided by web hosting companies. Based on my understanding of your post, you are running FrontPage and web server from your PC, correct?
I am running FrontPage on my computer, and have my web on a server. So to test my code, I publish to my server and then look to see what happens. I have got a very simple database application, using HTML forms to gather information and then send it to the database. Believe me, the database manipulation is not the problem! I have just tried a very simple HTML form to gather a name. The form is called form.asp: <body> <form ACTION="validate.asp" METHOD="POST"> <p>Your Name: <input TYPE="Text" NAME="name" size="20"><br> Your Email: <input TYPE="Text" NAME="email" size="20"><br> Your ASP skills are: <select NAME="skills" SIZE="1"> <option VALUE="I suck">I suck</option> <option VALUE="Pretty bad">Pretty bad</option> <option VALUE="Bad">Bad</option> <option VALUE="Good">Good</option> <option VALUE="Excelent">Excelent</option> <option VALUE="Better than yours!">Better than yours!</option> </select> <br> Comment:<br> <textarea NAME="comment" COLS="20" ROWS="5" WRAP="VIRTUAL"></textarea><br> <input TYPE="Submit" VALUE="Submit"> </p> </form> </body> When submitted, Validate.asp is called: <% Form_Name = Trim(Replace(Request.Form("name"),"""","""""")) Form_Email = Trim(Replace(Request.Form("email"),"""","""""")) Form_Skills = Trim(Replace(Request.Form("skills"),"""","""""")) Form_Comment = Trim(Replace(Request.Form("comment"),"""","""""")) Validated_Form = true IF len(Form_Name)<2 THEN Validated_Form = false END IF IF len(Form_Email)<6 OR InStr(Form_Email,"@")=0 THEN Validated_Form = false END IF IF len(Form_Skills)<3 THEN Validated_Form = false END IF IF NOT Validated_Form THEN %> <html> <body> <p>Error. Click back in your browser, and fill it out properly! </html> </body> <% ELSE 'Here you can insert the info to a database, or send it 'with JMail to you mail acount. If you send it to a db, make sure 'to remove any possible ' chars. %> <html> <body> <b>Thank you for filling out the form <%=Form_Name%> !</b> <br> <br> You submitted the following information:<br> Name: <i><%=Form_Name%></i><br> Email: <i><%=Form_Email%></i><br> Skills: <i><%=Form_Skills%></i><br> Comment: <i><%=Form_Comment%></i> </html> </p> </body> <% END IF %> This works perfectly. When I modify form.asp do client-side validation: <body> <script type="text/javascript"> <!-- function validate(){ if ((document.example2.name.value=="")|| (document.example2.email.value=="")){ alert ("You must fill in all of the required fields!") return false } else return true } //--> </script> <form ACTION="validate.asp" onsubmit="return validate()" name="example2"> <p>Your Name: <input TYPE="Text" NAME="name" size="20"><br> Your Email: <input TYPE="Text" NAME="email" size="20"><br> Your ASP skills are: <select NAME="skills" SIZE="1"> <option VALUE="I suck">I suck</option> <option VALUE="Pretty bad">Pretty bad</option> <option VALUE="Bad">Bad</option> <option VALUE="Good">Good</option> <option VALUE="Excelent">Excelent</option> <option VALUE="Better than yours!">Better than yours!</option> </select> <br> Comment:<br> <textarea NAME="comment" COLS="20" ROWS="5" WRAP="VIRTUAL"></textarea><br> <input TYPE="Submit" VALUE="Submit"> </p> </form> </body> and submit it, I get the error message to go back and fill in the form, even though the form has been filled in! For some reason, calling the validate function in the first form seems to reset all the form.asp's fields, so that in validate.asp Request.Form returns empty data. I have really struggled to get this far, and when the logic makes no sense I do not know what to do! So then I think maybe it is FrontPage and not me. Can you help?