Updating Records 1

[jags22]

Is there a way to find out how many records where just updated without writing a new query? Thanks...

 

[FALCONSEYE]

sure.

<cfquery name="myUpdate" ....>

your query

select @@ as recordsUpdated
</cfquery>

<cfoutput>#myUpdate.recordsUpdated#</cfoutput>

hope it helps...

http://www.jetansolutions.com

 

[ecobb]

Or, if you're on CF 7(.02), just use RecordCount like any other query. I think it only work in the RESULT structure, though.

http://www.forta.com/blog/index.cfm...CORDCOUNT-For-INSERT-UPDATE-DELETE-Operations

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[GUJUm0deL]

ECAR, interesting link. I was not aware of that also. Have you used this yet?

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[ecobb]

I actually wasn't aware of it either. I was curious about jags22's question and wondered whether or not a query's recordcount would work. I Googled something like "ColdFusion Update Query RecordCount" and came up with that link.

I haven't tried it out, and don't really know if I'll get the chance to. I've pretty much abandoned Queries in favor of Stored Procedures, especially for Inserts, Updates, and Deletes. Not to say there's anything wrong with Queries, I'm just a big fan of letting the database to the database work, and just have CF hand off the variables to a stored procedure.

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[jags22]

Thanks guys but I don't think it will work with an Oracle database.

 

[ecobb]

I'll bet you could write a Stored Procedure that would return the number of updated records.

Just out of curiosity, were you able to try the RecordCount from the result structure?

Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher