weeee
asked on
ASP calculation error
Hi guys,
I have a serious problem here , i run a site that process results base on a set of data , the problem is before i process i have ability to FORECAST the result without making changes to DB , but SOMETIMES when after i do processing the results do not match the forecast results
this discrepancies results in much inconvience and also wrong data presented to my clients , i have to undo the process and reprocess again then i will get the same result as the forecast.
this is a headache , the site is quite busy and the only conclusion i can think of is that when some of the client is accessing the site i was processing the data thus resulting in the discrepancies
do any of you guys have any solution or method to resolve this issue ?
regards
I have a serious problem here , i run a site that process results base on a set of data , the problem is before i process i have ability to FORECAST the result without making changes to DB , but SOMETIMES when after i do processing the results do not match the forecast results
this discrepancies results in much inconvience and also wrong data presented to my clients , i have to undo the process and reprocess again then i will get the same result as the forecast.
this is a headache , the site is quite busy and the only conclusion i can think of is that when some of the client is accessing the site i was processing the data thus resulting in the discrepancies
do any of you guys have any solution or method to resolve this issue ?
regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You just change the locktype on the connection with the database.
If he knows any ASP he'll know his locktypes....
If he knows any ASP he'll know his locktypes....
ASKER
ok thks guys will ask him to test this method
ASKER
hi ozo and oilwarner
my programmer asked my to ask you guys what locktype connection do you recomend
thanks
my programmer asked my to ask you guys what locktype connection do you recomend
thanks
I feel ozo would suggest adLockOptimistic for this. u may go ahead and try.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What about adLockReadOnly?
Small example:
sqlString="select * from table1"
set rs=myDB.execute(sqlString)
do while not rs.eof
sqlString="select * from table2"
set rs1=myDB.execute(sqlString )
..... calculation using table1,table2.......
sqlString="update table3 set ......."
set rs1=myDB.execute(sqlString )
rs.movenext
loop
Is it possible to lock database during do while ... loop?
Small example:
sqlString="select * from table1"
set rs=myDB.execute(sqlString)
do while not rs.eof
sqlString="select * from table2"
set rs1=myDB.execute(sqlString
..... calculation using table1,table2.......
sqlString="update table3 set ......."
set rs1=myDB.execute(sqlString
rs.movenext
loop
Is it possible to lock database during do while ... loop?
ASKER
how do i do that ? because i am not the developer , and therefore i need to ask my programmer to work this out , care to tell me what should i tell him so he can work on it?
regards