Author: richard

Distinct Visits

Comersus Version: 707Database type: AccessFrequency: Permanent issue can you let me know why this SQL will not execute in the Generic SQL script: Select Count(Distinct userIP) From Visits

Advise needed…

Comersus Version: 708Database type: AccessFrequency: Permanent issue Hi there, I have almost finished my site, and have migrated all the scripts from my test environment to it's live domain, although now i;m getting some weird results when adding products and throughout the checkout process, could i ask you to take a look at the following:

bonus points not working

Comersus Version: 708Database type: AccessFrequency: Permanent issue i'm trying to pay for an item using bonus points, although i have enough points and select the right option, the 'cost' of the item is not being taken from the bonus points, so the bonus points amount for each client doesn't change.

Paypal adding on

Comersus Version: 708Database type: AccessFrequency: Permanent issue i'm testing my site with a 'live' transaction, everything seems to be fine, until i enter my login details into paypal to 'pay' for the items.. paypal then adds on a

scripts not working…

Comersus Version: 708Database type: AccessFrequency: Permanent issue i've been using comersus for a while but never seen this happen: the scripts listCategories.asp and customerShowOrders.asp are not displaying any data – even though categories and orders exist in the db… should i just replace the db or could something else be creating this?

payment email

Comersus Version: 708Database type: AccessFrequency: Permanent issue i'm trying to format the 'look' of the payment approved email, but i think i may be modifying the wrong script, could you confirm which script i should be affecting

new customer discount

Comersus Version: 708Database type: AccessFrequency: Permanent issue how can i add a one-time discount for all customers, basically a 'new' customer discount

number of items in cart

Comersus Version: 708Database type: AccessFrequency: Permanent issue how can i display how many item are in the cart alongside the variable… i'm sure i've seen this answered before, but can't find the thread

Protx Exec not sending email to admin

Comersus Version: 708Database type: AccessFrequency: Permanent issue Hi there, i'm having problems with Protx exec page, it doesn't seem to be sending an authorized email to the admin of the site – how come this isn't working???

empty the cart function

Comersus Version: 708Database type: AccessFrequency: Permanent issue i'm trying to create a script based upon the showCart.asp script in which people add items to a quote basket ( not ordering only wanting quotes for certain items ) – i have created the form ok, but when i submit the form the items are still inside

3 columns on homepage…

Comersus Version: 708Database type: AccessFrequency: Random issue how can i change the homepage to display 3 or even 4 coloumns instead of the standard 2 column display

rental error

Comersus Version: 708Database type: AccessFrequency: Permanent issue i get the following error when ry to add a rental product: Sorry for the inconvenience. Error in addItem, error: Type mismatch – Err.Number:13 – SQL:SELECT weight, cost, listPrice FROM products WHERE idProduct=16117 AND active=-1

random record

Comersus Version: 708Database type: AccessFrequency: Permanent issue i've create a new table with the comersus db called offers, with the following field names: idOffer OfferName OfferImageUrl active what i want to do is fill this table with records relating to offers on the site, kinda like an image banner… and then have a random selector

PayPal Silent Response error..

Comersus Version: 705Database type: AccessFrequency: Permanent issue i get the following error in an email when completing a 'test' transaction: PayPal IPN warning. Different order total $ – real order total: $0.01 – STR: VERIFIED how can i rectify this error ASAP?

Protx Payment Gateway

Comersus Version: 708Database type: AccessFrequency: Permanent issue I have just downloaded the Protx payment gateway, but i'm getting missing include files can you please help?

Bundles with Variations

Comersus Version: 705Database type: AccessFrequency: Permanent issue I'm trying to add several items into a bundle, which i have managed to do – but each of these 'bundled' items need to have variations on them – which don't get specified within the bundle – how can i get this to work?

silent response

Comersus Version: 708Database type: AccessFrequency: Permanent issue can someone tell me what silent response does and how i can configure it to automatically set orders as paid

changing Related Products

Comersus Version: 705Database type: AccessFrequency: Permanent issue could you advise me on how to change the display of the related products, i would like to display them side by side like this: prod1 prod2 prod3 prod4

error in search…

Comersus Version: 705Database type: AccessFrequency: Permanent issue i keep getting the following error when i run a search on my site. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'idCategory='. /mysites/finder/includes/databaseFunctions.asp, line 38 although if the search returns no results i get