[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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
0
weeee
Asked:
weeee
2 Solutions
 
ozoCommented:
How about locking the data accesses so that only one person can process the data at any one time?
0
 
weeeeAuthor Commented:
hi ozo ,

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
0
 
OliWarnerCommented:
You just change the locktype on the connection with the database.
If he knows any ASP he'll know his locktypes....

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
weeeeAuthor Commented:
ok thks guys will ask him to test this method
0
 
weeeeAuthor Commented:
hi ozo and oilwarner

my programmer asked my to ask you guys what locktype connection do you recomend

thanks
0
 
prashantagarw10Commented:
I feel ozo would suggest adLockOptimistic for this. u may go ahead and try.
0
 
OliWarnerCommented:
No, no no no no...

Optimistic allow people to play with the data until you've called the update()... which isnt very helpful here...


You want to use adLockPessimistic because that locks the data until it is updated or the connection is broken/finished.

If your programmer want to read up on the differences between the locktypes send him here: http://www.blueclaw-db.com/asp_ado_connection_string/
0
 
weeeeAuthor Commented:
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?
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now