Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Qasim Rasheed
You could use JDBC Statement for this purpose which I believe is called PreparedStatement. I have recently written a similar application using the above mentioned technique. I can send you the code tomorrow morning if you are interested. Thanks On 5/10/05, Sergey Croitor <[EMAIL PROTECTED]> wrot

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
excerpt from Access help: If you want to know which records were updated, first examine the results of a select query that uses the same criteria, and then run the update query. Ugly but works. SELECT count(*) as rowsAffected FROM your_table WHERE your_previous_update_where_clause DM> No recor

RE: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Damien McKenna
You know it'd work better if I was checking against the correct DSN... -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include ~| Discover CFTicket - The

RE: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Damien McKenna
clude > -Original Message- > From: Sergey Croitor [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 10, 2005 3:14 PM > To: CF-Talk > Subject: Re: OT: AFFECTED_ROWS from sql server update cfquery? > > or check query_name.RecordCount :) > There is a chance it holds you

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
or check query_name.RecordCount :) There is a chance it holds you need for UPDATE query as well. DM> Is there any way to find the number of rows affected by the last query DM> when using SQL Server 2000 and a cfquery UPDATE statement? I'm stumped DM> on this one. Thanks. -- Best regards,

RE: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Dave Watts
> check the metadata..if not you could do something like > > Set nocount on > update stuff > Select @@rowcount as AffectedRows > Set nocunt on I've been running that last option for years! (Bah-dum-bum!) I'll be here all week! Try the veal. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
UPDATE ... SELECT @@ROWCOUNT AS rowsAffected DM> Is there any way to find the number of rows affected by the last query DM> when using SQL Server 2000 and a cfquery UPDATE statement? I'm stumped DM> on this one. Thanks. -- Best regards, Sergeymailto:[EMAIL PR

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Adam Haskell
check the metadata..if not you could do something like Set nocount on update stuff Select @@rowcount as AffectedRows Set nocunt on Adam H On 5/10/05, Damien McKenna <[EMAIL PROTECTED]> wrote: > Is there any way to find the number of rows affected by the last query > when using SQL Server 2000 a