biggail
Head Administrator
Global user
Registered: 03-2005
Posts: 13
Karma: 0 (+0/-0)
|
|
Reply | Quote
|
|
Cursor in ASP.Net
I wrote a page that continually monitors a SQL file to ensure that all files get processed and sent out, based on a status code. So that if a file didn't connect with the mail server the first time it would get a code 2 and repeatedly try to send it until it was successfully sent. Similarly, if a pdf wasn't processed (code 0) it would go back and create it. I learned that I had to set the connection string cursor to adOpenStatic to allow the dataset to go backwards to clean up prior transactions that hadn't been sent.
|
|
9/23/2008, 1:14 pm
|
Send Email to biggail
Send PM to biggail
Blog
|
