> 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 is most probably a problem with Access and not your SQL
statement or ColdFusion. Try a search in Google Groups for "The
search key was not found in any record". There appear to be any
number of scenarios that can lead to this vague error message -
replication, memo fields, Jet version, etc.You are definitely not
the only one who has experienced this.
Here's something else you might try if it's feasible:
Try creating a new (blank) Access database.
Immediately turn off Name AutoCorrect (Tools | Options |
General).
Then import everything from the old database (File | Get External
| Import).
Recreating everything like that may solve the issue.
Stephen
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: SQL Problem Tony Weeg
- RE: SQL Problem Adrian Lynch
- sql problem John McCosker
- Re: sql problem S . Isaac Dealey
- RE: SQL problem Tyagi, Badal
- SQL Problem Mickael
- RE: SQL Problem Tangorre, Michael
- Re: SQL Problem Mickael
- RE: SQL Problem Tangorre, Michael
- Re: SQL Problem Mickael
- Re: SQL Problem Stephen Hait
- Re: SQL Problem Mickael
- RE: SQL Problem Dwayne Cole
- Re: SQL Problem Mickael
- Re: SQL Problem kpeterson