SEO

#1 (**permalink**) 02-28-2008, 07:11 AM

I've been scratching my head with this. I'm using a select query
to locate a record from a table based upon its primary key.
I then set some field values to those returned from a web page
form. I then do a recordset.update.

If the web form details differ from the saved values in the database
then the update works just fine. If they are the same, an error is
returned, being

"Query-based update failed because the row to update could not be found."

Now, I know this is not the generally accepted way to do things, but I
still want to know why it fails... I've tried all combinations of cursors
and locks. It's totally retarded in my opinion.

any thoughts?

regards,

paolo

#2 (**permalink**) 02-28-2008, 07:11 AM

"Don Paolo" <pkorosi@redpepper.com.au> wrote in message
news:4396c19d$1@duster.adelaide.on.net...
> I've been scratching my head with this. I'm using a select query
> to locate a record from a table based upon its primary key.
> I then set some field values to those returned from a web page
> form. I then do a recordset.update.
*snip*

never mind - sussed it out.

#3 (**permalink**) 02-28-2008, 07:11 AM

"Don Paolo" <pkorosi@redpepper.com.au> wrote in message
news:4396c51d$1@duster.adelaide.on.net...
> "Don Paolo" <pkorosi@redpepper.com.au> wrote in message
> news:4396c19d$1@duster.adelaide.on.net...
>> I've been scratching my head with this. I'm using a select query
>> to locate a record from a table based upon its primary key.
>> I then set some field values to those returned from a web page
>> form. I then do a recordset.update.
> *snip*
>
> never mind - sussed it out.

thanks, me.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode