RecordCount Issues

[supportcenter]

Hi folks!

Long story short: Within the application, which I'm developing ATM, I have to
do some update- and delete-queries, but it seems that they do not return
anything. I can't even cfdump the queries because they are undefined. All I
want is the number of deleted or updated rows. Does cfquery not support this or
what?

Some examples:

<cfquery name="deltest" datasource="#dsn#">
select * from testtab
</cfquery>
<cfdump var="#deltest.RecordCount#">

<cfquery name="deltest2" datasource="#dsn#">
INSERT INTO testtab( iddi )
VALUES ('asdasd')
</cfquery>
<cfdump var="#deltest2#">

<cfquery name="deltest3" datasource="#dsn#">
delete from testtab where iddi='asdasd'
</cfquery>
<cfdump var="#deltest3#">

[SQLMenace]

If you are using SQL server you can use the @@Rowcount to get the number of
records inserted or updated

you can try this
INSERT INTO testtab( iddi )
VALUES ('asdasd')
select @@rowcount as Rowcount

but I don't know if it will work like that, if not convert your code to stored
procedures

[Dan Bracuk]

run a select count(fieldname) right before you update or delete the records.
As long as the where clauses are the same, it should work.

Originally posted by: supportcenter
Hi folks!

Long story short: Within the application, which I'm developing ATM, I have to
do some update- and delete-queries, but it seems that they do not return
anything. I can't even cfdump the queries because they are undefined. All I
want is the number of deleted or updated rows. Does cfquery not support this or
what?

Some examples:

[supportcenter]

Thx. I think that I've already made enough slow database queries so that I do
not really want to verify those querys by "select count..."
Would have been nice if there was a RecordCount to get the number of affected
rows. Luckily I do not really need it, but it would have been nice to have a
_simple_ method of verification. But thanks anyway.

[mxstu]

supportcenter,

For future reference, it's always helpful to indicate the type of database
you're using. It's possible that your database type does have this capability,
but without knowing which type, it is difficult to definitively answer your
question.

[supportcenter]

I'm sorry...normally I do mention all the required information.
It's MySQL 4.something together with CFMX 6.x

Btw: isn't it possible to use some other username than the first part of my
mail-address?!

[mxstu]

supportcenter,

You might have a look at this thread which suggests a few possibilities:
[url]http://forums.mysql.com/read.php?60,45239,45239#msg-45239[/url]
[url]http://dev.mysql.com/doc/refman/5.0/en/information-functions.html[/url]

>Btw: isn't it possible to use some other username than the first part of my

mail-address?!
I don't know that it is possible to change your screen name after you sign up.
Weren't you given the option to select your username? IF it were possible, it
might be under membership details:
[url]http://www.macromedia.com/cfusion/membership/index.cfm[/url]