Error 450

Comersus Version: 509
Database type: Access
Frequency: Permanent issue


Greetings :

I am receiving the following error after an Authorization Code is entered and the update arrow to the right of the text box is clicked to change the status of a purchase from Pending to Paid in the View Order screen.

There are errors in your BackOffice+: Error in updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE products SET sales=sales+1 WHERE idProduct=4086

When I try to Mark All Pending as Paid, the following error is generated:

There are errors in your BackOffice+: Error in updateTransactionResults.asp, error: Wrong number of arguments or invalid property assignment – Err.Number:450 – SQL:UPDATE products SET sales=sales+2 WHERE idProduct=4087

Note: Comersus is sending out email to the store owner, to the purchaser of a product, to indicate inventory is low.

I have commented out the On Error Resume Next in updateTransactionResults.asp.

I have commented out the On Error Resume Next markAllPending Orders.asp.

I have commented out the sendmail.asp in updateTransactionResults.asp. (I saw this suggestion made in another posted message.)

I have made the above changes one at a time and returned the code to original before making the next change.

We are using CdoSys for Win3k server.

The above errors occur for all orders.

Comersus: 5.09 with Power Pack Premium.

Thanks for your help and I will be glad to supply any other info that may help you.

ofb

3 Comments

Add a Comment

Your email address will not be published. Required fields are marked *