I was wondering what people use to determine the number of records a query has deleted.Basically, how would you make the following code different in order to increase performance?
cfquery datasource=#mydsn2# name=dsn1
select count(*)
frommytable
/cfquery
cfquery datasource=#mydsn#
delete
from
cfquery datasource=#mydsn# name=dsn1
select count(*)
from mytable
where mycity = 'Boston'
/cfquery
cfquery datasource=#mydsn#
delete
from mytable
where mycity = 'Boston'
/cfquery
HTH
Dick
On May 5, 2004, at 8:09 AM, Michael Hodgdon wrote:
I was wondering what
That will work also, minimizes the query and the math involved in the original solution.Thank you for taking a look
cfquery datasource=#mydsn# name=dsn1
select count(*)
from mytable
where mycity = 'Boston'
/cfquery
cfquery datasource=#mydsn#
delete
from mytable
where
3 matches
Mail list logo