I am having problems with an update statement that used to work fine in Access with CFMX. I have an issue tracking app that used to have the issue numbers stored as TEXT, I converted the column to Number a little while ago and it worked fine. Recently users have been having problems updating the records.
My update statement is pretty simple
Update IssueRegister
SET IssueStatus = '#form.IssueStatus#',
Response = '#form.Response#',
ResponseUserId = '#session.activeuser.USER_NAME#',
DateofResponse = #CreateODBCdate(now())#
Where IssueNumber = #form.issuenumber#
The error that I get from CF is
The search key was not found in any record.
But if I look in the error window it show my statment as follows
Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110
This look correct to me. So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility.
This has me stumped. Any ideas anyone.
Thanks
Mike
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
