After following the example in this site and building the form, ASP and FLASH exactly like Kirupa did… I find that the code is creating a ROW in the database but there’s NO data to be found!
As a matter of fact, the code for getting the form data; isn’t!
Here’s my ASP page code:
<%@language = “VBScript” %>
<%
strFirst = Request.Form(“fname”) <-The names of my INPUT fields
strMI = Request.Form(“mi”) <-The names of my INPUT fields
strLast = Request.Form(“lname”) <-The names of my INPUT fields
Response.Write(strFirst) & “<br>” <-- This to…
Response.Write(strMI) & “<br>”
Response.Write(strLast) <-- …here doesn’t show a thing!
MyPath=Server.MapPath("/database/TrainingDatabase.mdb")
Set conn = Server.CreateObject(“ADODB.Connection”) ’
conn.Open “Driver={Microsoft Access Driver (*.mdb)};” & _
“DBQ=” & MyPath
SQL = “INSERT INTO tbl_ALL_DATA (first_name, mi, last_name) VALUES (’”&strFirst&"’,’"&strMI&"’,’"&strLast&"’)"
conn.Execute(SQL)
Response.Write(SQL) <-- This works but there’s no data in the string
%>
I’m using what Kirupa suggests:
on(press){
loadVariablesNum("…/myForm.asp",0,“post”);
}
which produces nothing except inserting a row in the MDB database
or
on(press){
getURL("…/myForm.asp",0,“post”);
}
which does the same as above.
Any thoughts?
Peter
