Roy_
asked on
Upload Script not uploading information
ok i will put 2 posts of code from 2 different sheets.
I have a problem where the code i have written isn't writing the information onto the database.
(the database has read and write permission to everyone.)
I have a problem where the code i have written isn't writing the information onto the database.
(the database has read and write permission to everyone.)
<%
Dim adoCon 'Holds the Database Connection Object
Dim rsAddComments 'Holds the recordset for the new record to be added
Dim strSQL 'Holds the SQL query to query the database
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("******.mdb")
Set rsAddComments = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblComments.Drawings_Number, tblComments.Drawing_Title FROM tblComments;"
rsAddComments.CursorType = 2
rsAddComments.LockType = 3
rsAddComments.Open strSQL, adoCon
rsAddComments.AddNew
rsAddComments.Fields("Drawings_Number") = Request.Form("Drawings_Number")
rsAddComments.Fields("Drawing_Title") = Request.Form("Drawing_Title")
rsAddComments.Update
rsAddComments.Close
Set rsAddComments = Nothing
Set adoCon = Nothing
Response.Redirect "dwgreg.asp"
%>
ASKER
(a bit more information)
it doesn't come up with an error message, just enters blank data.
Any ideas?
TIA
-R
it doesn't come up with an error message, just enters blank data.
Any ideas?
TIA
-R
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Open in new window