Post reply

(1 row(s) affected) messages - turing them off?

  • July 30, 2003 at 9:27 am

    #80766

    Hello, I'm having a bit of a problem with ADO and I believe its something to do with the (1 row(s) affected) messages that you can see after executing a sql statement in query analyzer.

    I am using a cursor to insert some data into a temporary table then display it.

    For each row I insert I get the (1 row(s) affected) message in QA.

    When I try to access the data through asp using ado I have to use set rs = rs.nextrecordset command for every (1 row(s) affected) message I get in QA.

    Can I turn these messages off and anyone got any ideas what’s causing this problem?

    Cheers

  • July 30, 2003 at 9:41 am

    #467779

    hi

    SET NOCOUNT ON

    should do the trick

    Paul

  • July 30, 2003 at 9:50 am

    #467785

    Thats just the job - Cheers 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply