|
crosscreek -> RE: strange updating mysql question (3/8/2008 2:01:55)
|
I'm using a pretty basic procedure. I am just adding a dog to the database. Once added people can upate the info.
I looked at the site you posted & I didn't see anything that was relative. Maybe the text where you add the variable at the start & don't change it.
But to test that I added 2 fields to the database
names --- varchar(50) Didn't work (added less then 15 char, but not over) same error as before
namesdog --- text (typed in 50)
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
Below is the origional code
adddog.htm
<form method="POST" Action="adddog.asp">
<p><b>Add Dog: <input type="text" name="doggy" size="50"></b></p><p> </p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
Adddog.asp page
<%
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "tbldog", myConn, , adLockOptimistic, adCmdTable
objRS.AddNew
objRS("name") = Request.form("doggy")
objRS.Update
Response.write "you have added the dog"
objRS.Close
Set objRS = Nothing
myConn.Close
Set myConn = Nothing
%>
Not much to the code...
No sure what to think about this
|
|
|
|
