Author: Len

Unclosed connections

Comersus Version: 705Database type: OtherFrequency: Permanent issue Let me first say I not an expert. But, the way I read the code for closeDB() is that it closes rsTemp and sets it to nothing. But what about all the other connections, especially the heavily used ones like those in the itemsFunctions.asp, such as rstempSPrice that's

Tax per product is added to tax per place

Comersus Version: 705Database type: OtherFrequency: Permanent issue If I have an product to be taxed at a per product rate, the store applies both the per product and the per place rates. It also calculates tax on the tax not a good thing. Souldn't it calculate the tax per place on those item not to

Why dosen't categories table have idStore

Comersus Version: 705Database type: AccessFrequency: Permanent issue Since the categories table doesn't have an idStore field, you can't really run multiple stores from the same db. You could mess around with keeping the cat names unique but that's lame. What am I missing? Is the only answer for me is to add idStore to the

Maximum number of products using Access

Comersus Version: 705Database type: AccessFrequency: Permanent issue I can't find any definitive discussion about when you need to consider upgrading from Access to a professional db such as mySQL. I'm sure the mix of the number of customers, products, and transactions all play a part. I have a store using Access with 4,000 products but

MySQL schema

Comersus Version: 602Database type: OtherFrequency: Permanent issue Are the programs available to create the MySQL database tables available for the free version of the cart? Since the free version install fails looking for the tables, I assume the MySQL files aren't in the standard download.

How to use multiple discounts at checkout time

Comersus Version: 507Database type: AccessFrequency: Permanent issue I know you can set up all sorts of nifty discounts, but it seems that the customer can only use one per order. For instance, if you add 2 offer box items to your cart, you only get the discount on the last one you picked. If you

Bypass shipping options based on weight

Comersus Version: 505Database type: AccessFrequency: Permanent issue The documentation (App D) says you can set a product's weight to zero and this will cause the shipping options to not appear during the checkout process. My product weight is set to zero and and my shipping options weightFrom and weightUntil are both zero. But, I still

Lost session variables with shared SSL

Comersus Version: 500Database type: AccessFrequency: Permanent issue My site uses a shared SSL. I changed the url in comersus_checkout.asp to include my SSL string. When you logon as a returning shopper, the comersus_login page is secure, but of course I've lost my session variables so my cart's empty. Is there an easy workaround to transfer