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
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
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
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
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,
> 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.
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
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
8 matches
Mail list logo