Cursor and lock type problem

Results 1 to 2 of 2

Thread: Cursor and lock type problem

  1. #1
    Join Date
    Dec 1969

    Default Cursor and lock type problem

    Here is the problem...<BR><BR>I have one RecordSet object used to display records, so I can use a read only cursor...<BR><BR>Within the same code I have a delete button that is supposed to delete the record the user chose...<BR><BR>I know I need a different cursor and locktype, but cannot find which ones I need...<BR><BR>Here is the code for the display RecordSet object:<BR><BR>objRS.Open strSQL, objconn, adOpenStatic, adLockReadOnly, adCmdText<BR><BR>Any help would be great...<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Cursor and lock type problem

    you dont need a recordset to delete a record<BR><BR>dim conn<BR>set conn = server.createObject("ADODB.Connection")<BR>conn.op en "{insert connection string here}"<BR><BR>conn.execute("delete from table where ID = " & request("id"))

Posting Permissions

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