• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

Using sql update in asp - returning rows affected

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?

Thanks,
0
akessel
Asked:
akessel
1 Solution
 
ErnariashCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now