Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-27 : 11:19:24
|
Phil B. writes "It's kind of a wierd question but I would like to have ADO return to me the "comments" (I guess you would call it that)
...
(6 row(s) affected)
...
I would like to have this information returned to my ASP code so that I can work with it. Whether it be for debugging purposes or for programmatic purposes.
I've looked around and can not find any references to such a method. I would even like to find a work around...
Here is an example...
---------------------------------------
UPDATE Tblname SET usrStats = '-1'
WHERE emailAddr NOT LIKE '%@%.%'
---------------------------------------
I want to execute this code in ASP and have it tell me how many rows were updated.
I was thinking of using a work around by..
--------------------------------------
SELECT COUNT(*) FROM Tblname
WHERE emailAddr NOT LIKE '%@%.%'
----- then -----
UPDATE Tblname SET usrStats = '-1'
WHERE emailAddr NOT LIKE '%@%.%'
--------------------------------------
But I this process is teadious when the SQL code is generated dynamiclly...
Maybe a possible solution is the answer to the question....
Using ADO, How do you confirm that an UPDATE executed properly?
And If You know that... How many records where UPDATEd or DELETEd?
Thanks For The Help....
Phil B." |
|
|
|
|
|
Returning T-SQL comments