Hi all,
I have this code:
Dim objConn, objRS, strQ, a, b, stsql, stuser, stpass, stadd, stpost, stfull
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("\test\example.mdb")
Set objconnection = Server.CreateObject("ADODB.Connection")
objconnection.Open strConnection
stuser = request.form("username")
stpass = request.form("password")
stfull = request.form("fullname")
stadd = request.form("add")
stpost = request.form("postcode")
strSQL = "INSERT INTO members(username, pass, fullname) VALUES('" & stuser & "','" & stpass & "','" & stfull & "')"
objConnection.Execute strSQL
which works fine apart from its not adding the stfull part to the database. any ideas anybody?
the form code is:
<tr align="center">
<td width="248" height="17" bgcolor="#C0C0C0" align="right"><font color="#000000"><small>Add
Your Full Name:</small></font></td>
<td height="17" width="123" bgcolor="#C0C0C0" align="left"><input type="text"
name="fullname" size="50" tabindex="3" maxlength="8"></td>
<td width="47" height="17" bgcolor="#C0C0C0" align="center"><a
href="javascript:alert('The password must be between 4 and 8 characters long.')"><small><small>Help</small></small></a></td>
</tr>
thanks
Martin
I have this code:
Dim objConn, objRS, strQ, a, b, stsql, stuser, stpass, stadd, stpost, stfull
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("\test\example.mdb")
Set objconnection = Server.CreateObject("ADODB.Connection")
objconnection.Open strConnection
stuser = request.form("username")
stpass = request.form("password")
stfull = request.form("fullname")
stadd = request.form("add")
stpost = request.form("postcode")
strSQL = "INSERT INTO members(username, pass, fullname) VALUES('" & stuser & "','" & stpass & "','" & stfull & "')"
objConnection.Execute strSQL
which works fine apart from its not adding the stfull part to the database. any ideas anybody?
the form code is:
<tr align="center">
<td width="248" height="17" bgcolor="#C0C0C0" align="right"><font color="#000000"><small>Add
Your Full Name:</small></font></td>
<td height="17" width="123" bgcolor="#C0C0C0" align="left"><input type="text"
name="fullname" size="50" tabindex="3" maxlength="8"></td>
<td width="47" height="17" bgcolor="#C0C0C0" align="center"><a
href="javascript:alert('The password must be between 4 and 8 characters long.')"><small><small>Help</small></small></a></td>
</tr>
thanks
Martin