Using sql update in asp - returning rows affected

Posted on 2008-11-12
Medium Priority
Last Modified: 2012-05-05
Using the standard:

conn.Execute strSql to execute an update routine:

strSql = "Update dbo.Individual Set AppStatus = 'xxxx' Where AppStatus= 'Approved';"

Anyway, works fine, but is there a way to run this where I can get the number of rows affected?

Question by:akessel
1 Comment

Accepted Solution

Ernariash earned 1400 total points
ID: 22945978
Did you try:
conn.Execute (strSql, iRecordsAffected )
iRecordsAffected is the optional RecordsAffected parameter is a long variable in which the provider stores the number of records that were affected by the query

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month15 days, 8 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question