Classic ASP Discussion - Weird (0x80004005)

Print Page | Close Window

Weird (0x80004005)

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=4791
Printed Date: 30 March 2026 at 2:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Weird (0x80004005)

Posted By: ngaisteve1
Subject: Weird (0x80004005)
Date Posted: 06 August 2003 at 2:53am

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Query-based update failed because the row to update could not be found.
/inventory_system/issue_requisition_issue_selected.asp, line 40

I narrow down the problem and it's a bit weird. When comment this line of code below, it works.

rs_issue("date_issued") = DatePart("YYYY", Date) & "/" & Right("0" & DatePart("M", Date),2) & "/" & Right("0" & DatePart("D", Date),2)

But, the weird thing is I have another file which just exactly the same line of code. This line of code intend to create a transaction log file.

All help really appreciated.

Replies:

Posted By: Mart
Date Posted: 06 August 2003 at 5:43am

rs_issue.Fields("date_issued") = DatePart("YYYY", Date) & "/" & Right("0" & DatePart("M", Date),2) & "/" & Right("0" & DatePart("D", Date),2)

Posted By: ngaisteve1
Date Posted: 06 August 2003 at 8:17pm

Still can't. Same error.

Posted By: pmormr
Date Posted: 06 August 2003 at 9:04pm

did you make sure that you locktypes were set right?

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: ngaisteve1
Date Posted: 06 August 2003 at 9:49pm

Yeah, correct.

Posted By: Mart
Date Posted: 07 August 2003 at 2:49am

Cursor Type?

Posted By: ngaisteve1
Date Posted: 07 August 2003 at 6:46pm

ok also.