What's wrong with this code?

Results 1 to 2 of 2

Thread: What's wrong with this code?

  1. #1
    chrisb@zombie.co.uk Guest

    Default What's wrong with this code?

    I am having the following problem when updating a recordset made up from multiple tables in a relational DB. The database is SQL 7.<BR><BR> dim sqlst, rs<BR> set rs = Server.CreateObject("ADODB.Recordset")<BR> sqlst = "SELECT * FROM table1, table2;"<BR> rs.open sqlst, "DSN=db;UID=username;PWD=password",, 3<BR> rs.addnew<BR> rs("field1") = "field1"<BR> rs("field2") = "field2"<BR> rs.update<BR><BR>Results in the following error message with a reference to the &#039rs.update&#039 line number:<BR><BR>Provider error &#039 80004002&#039 <BR><BR>No such interface supported<BR>

  2. #2
    Franco Guest

    Default RE: What's wrong with this code?

    Chris<BR><BR>Why not use a proper UPDATE statement inside a stored procedure?<BR><BR>Franco<BR>lokidude@hotmail.com

Posting Permissions

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