This task is quite simple to do, but it sounds as if you don't know where to get started.<BR><BR>check some articles on www.4guysfromrolla.com and www.aspin.com for samples on sending and retrieving information to and from a database. <BR><BR>That should give you a good start...<BR><BR>-- Whol
<%<BR>set conn = server.Createobject("ADODB.Connection")<BR>Conn.Op en ("DSN=dsnanme")<BR>set rsm=Conn.execute("SELECT * from tablename where columname = '" & field_form_form &"'") (datatype is string)<BR>set rsm=Conn.execute("SELECT * from tablename where columname = " & field_form_form )(datatype number)<BR>%><BR><BR>in your html code where you've all your field value to be edited have textarea field as below. hope this would help. <BR><BR><tr><td><font face="arial" size=2>Comment:</td><td><TEXTAREA cols=30 name=recuse rows=3><%=recuse %></TEXTAREA></td></tr>
Here is textarea coding:<BR><BR><tr><td> & nbsp;<strong>Comments (Maximum 200 characters)</strong></td><BR> <td> <TEXTAREA id=station_comments name=station_comments cols=40 rows=5> <%= rs.fields("station_comments")%><BR> </TEXTAREA> </td> <BR> <BR><BR>Here is my addrecord (or update record) page code to add to database:<BR><BR>case "station_comments"<BR> <BR>rs.Fields("station_comments") = Request.Form("station_comments")<BR> <BR>And here is the error message I get when I try to submit:<BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. <BR><BR>Line 121 - (which is teh line for the above statement.<BR></tr>
2 questions.<BR><BR>1) Is the field in the database a memo field?<BR><BR>2) What are the total number of charachters you are trying to insert into the field versus what the max value is?<BR><BR>OK 3<BR><BR>3) You ARE making this an UPDATE and not an ADD record statement aren't you? Hard to tell from your post you call it both. It must be an UPDATE and NOT an add.