Problem with VB Script

Results 1 to 2 of 2

Thread: Problem with VB Script

  1. #1
    Join Date
    Dec 1969

    Default Problem with VB Script

    Hi<BR>I&#039;m having problems trying to edit a field in a database table using VB Script in ASP.<BR>I can use the rs.AddNew command by typing the following;<BR><BR>set rs = Server.CreateObject("ADODB.RecordSet") <BR>rs.cursorlocation = adUseServer <BR>rs.CursorType = adOpenKeySet <BR>rs.LockType = adLockOptimistic <BR><BR> "tablename",dbConn, , ,adCmdTable <BR>rs.addnew <BR>rs("FieldName") = Request("txtvalue")<BR>rs.Update<BR>rs.Close<BR><B R>When I try to use rs.Edit I get Object doesn&#039;t support this property or method: &#039;rs.Edit&#039;<BR><BR>Any ideas would be most appreciated.<BR>Cheers Guys<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem with VB Script

    Q: Why not use an SQL Update statement?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts