Operation must use an updateable query.

[techskool]

Hi guys

Ive got a shopping basket on my site

http://www.recordsnorthwest.com

Sessions arent tied up to customer keys, they are just random sessions attached to items in a table for instances of items added to the basket.

I cleared out this table this morning, after a customer has placed an order, the data is no longer needed in the table, so it had a lot of info in here and i decided to clean the table out.

The shopping basket isnt working now.

I dont get it, the db error message is 'Operation must use an updateable query. ' but none of the scripts have changed and the table is blank, like it was originally when i first implemented the shopping basket script and corresponding table.

To confuse me further, it all works in ISS locally fine?

Has anyone experienced anything like this, or know what it might be?

Thanx

Dave

;-)

 

[csniffer]

hi Techskool, sounds like it may be because Fields are NULL, have u tried to put a record in to see if the same happens

To err is human, to completely mess up takes a computer.