Thanks a lot that did it. I can now stop banging my head against the wall
----- Original Message -----
From: Stephen Hait
To: CF-Talk
Sent: Tuesday, December 16, 2003 2:39 PM
Subject: Re: SQL Problem
> 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]
