Tag: SET

error updating config through backofficelite

Comersus Version: 500Database type: AccessFrequency: Permanent issue comersus_supportError.asp?error=Error+in+comersus%5Fbackoffice%5FsettingsModifyExec%2Easp%2C+error%3A+%5BMicrosoft%5D%5BODBC+Microsoft+Access+Driver%5D+Too+few+parameters%2E+Expected+1%2E+%2D+Err%2ENumber%3A%2D2147217904+%2D+SQL%3AUPDATE+settings+SET+settingValue%3D%27english%27+WHERE+idSetting%3D29 What do I need to do? Thanks.

Discount Work

Comersus Version: 430Database type: SQL ServerFrequency: Permanent issue I want to to make my discounts work in the following manner: For example if the Discount is for $50 and a customer uses it on an item that is $20 I want it to change the value on the discount in the database to be $50-$20

Stock code

Comersus Version: 429Database type: AccessFrequency: Permanent issue I have seen in several messages that you can use the following code to decrease your stock when people save the order instead of waiting for a response from the payment gateway. the code has to be put in the file comersus_saveorder.asp my question is where exactly. i


Comersus Version: 411Database type: AccessFrequency: Permanent issue I want to be able to make my shopping cart to auto-recalculate the stock quantity as soon as an item has been through the checkout. At the moment the only way the stock changes is when admin enters backofficegold and changes the order to paid. How can I

Sep. Shipping overwrites cust. info

Comersus Version: 3760Database type: AccessFrequency: Permanent issue When I use a separate shipping address (using checkbox in ordeform.asp) it overwrites the customer data in Customer Table in db during saveorder.asp. For some reason it overwrites everything except the email and password fields. If I do not use the seperate shipping feature, all info in the

SQL update error

Comersus Version: 0Database type: Frequency: Hi, I working with shop 3.762 and BOG 3.75. At the start after filling my (access) dBase with a few products everything worked fine. But at this time all the products are in the dBase (approx. 500), everytjing works fine except the modifyprod-exec page. Adding is no problem, butt when