Asp vbscript DB question.

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?
If I take out the , fullname part it works fine.
the fullname is a field in the db.

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 did a response.write and got this:

INSERT INTO members(username, pass, add) VALUES('uytr','67456546','546')

SQL looks ok to me.
Can anybody shed any light on please as its driving me nuts

thanks

Martin

Copy/paste that into a SQL window and run it.

Hi,

works fine in access in sql window.

any ideas on why it doesn't work in asp?

thanks

Somethings wrong. In your code sample, you have this:


Yet in your response.write you say you're getting this:



How is that possible, that "fullname" is now "add" (the parts I bolded) ?

The other thing you could do is some error trapping, to see if an error is being generated. Do a Google for:


I found this:
http://stackoverflow.com/questions/472558/is-try-catch-like-error-handling-possible-in-asp-classic

Hi,

that must have been a typo, i probably was trying different fields before i did the reponse.write.

I'll have a look at error trapping now. It is a strange one.

Could you post your table structure?
In the past I've had random intermittent issues with Memo fields in the past and it might be something there.