return rows 
Author Message
 return rows
guys please help me!
we have a delete statement to be incorporated into asp scripts.
i want to know whether it is possible to find out(and display)
count of how many rows were deleted
please reply urgently
thanks

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.***.com/



Wed, 04 Dec 2002 03:00:00 GMT
 return rows

There are a number of ways to run SQL statements from an ASP.  How you
return the number of rows deleted depends on the method you use.

The example VBScript below uses the ADO connection execute method and
returns the number of rows as a result set.


AS RowsDeleted")
RowsDeleted = RS.Fields("RowsDeleted")

If you are using an ADO command, you can pass a variable to the execute
method to determine the number of rows deleted

You may want to check out http://msdn.microsoft.com for complete ADO
reference and examples.

Hope this helps.


Quote:
> guys please help me!
> we have a delete statement to be incorporated into asp scripts.
> i want to know whether it is possible to find out(and display)
> count of how many rows were deleted
> please reply urgently
> thanks

> Got questions?  Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com



Wed, 04 Dec 2002 03:00:00 GMT
 return rows
Dan,
Thanks a million!It really worked

thanks
sonia

Got questions?  Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com



Fri, 06 Dec 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. select case return rows in one row (how to group by three column)

2. Return Row X to Row Y

3. Using SELECT without returning rows

4. returning rows in groups of 10

5. Limiting returned rows

6. Getting DBCC Commands to Return Rows Instead of Info Messages

7. How to return row number of insert?

8. different number of returned rows

9. CONTAINS clause not returning rows

10. Max return row size

11. MAX or DISTINCT date and returning row from Joined tables

12. HowTo? return row if child table meets conditions


 
Powered by phpBB® Forum Software