Author: skools

Float can't update

Comersus Version: 603Database type: OtherFrequency: Permanent issue I want to update my prices, and there are thousands! So I tried:- UPDATE products SET price=17.99 WHERE price=17.9 But it didn't work. I found online that float numbers are not stored exactly as they seem. Would it affect anything if the price was changed from float to

NumPerPage

Comersus Version: 604Database type: OtherFrequency: Permanent issue const pNumPerPage only seems to work on my third category page (the one linked with itemDetailSm.asp). I need to limit the second categories (the one after root) page to 20 and have a next button. How can I do this? I need to do this because I am

change payment dropdown to radio button

Comersus Version: 603Database type: OtherFrequency: Permanent issue Can you tell me how I can change this code in comersus_checkOutSelectPayment.asp from dropdown to radio buttons, I only have two payment options but would prefer them as radio buttons.

stock levels cart recalculate

Comersus Version: 603Database type: OtherFrequency: Permanent issue I have some products (products A) with no stock restrictions, these are all idStock 1 and I put the stock level very high – 9999 so it takes time to run out. I also have some products (products B) where there is only one item of each available,

paypal pending

Comersus Version: 603Database type: OtherFrequency: Permanent issue I have set up my store with paypal using a mysql database, but the order status does not get updated to paid. I get emails from the silent response title 'Silent Response Error #01004' saying 'Cannot find order data based on idOrder' (but ther is an order with