How can I return the results text from SQL to ASP W/O a stored proc? 2

[nomofoxpro]

Is there any way to return the results text to ASP? For instance When you run an update query and the results pane says (2 Rows Affected). Can you somehow get this value with out using a stored procedure?

 

[swilliams]

There may be some properties of a recordset you can use - something like RowsAffected

Simon

 

[culshaja]

There is an optional parameter of the Command objects Execute method called RecordsAffected. I think this is what you want. You can issue direct SQL statements via this object (aswell as cretae temporary stored procedures on the fly!!).

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[nomofoxpro]

Thanks James! Where do you find the time?

 

[culshaja]

Time for what?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[nomofoxpro]

The time to make all these postings I mean. It was not a programming question.

Thanks again it worked smashingly!!

 

[culshaja]

It doesn't really take a lot of time. I spend about 1/2 hour to 3/4 hour spread out over the corse of a day which isn't really much when done in 5-10 minute chunks. I just do it while doing other things.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305