Author: Mvu

class screenMessage

Comersus Version: 709Database type: AccessFrequency: Permanent issue I need to customize screenMessage.vb in a very simple way . (ASP.NET) I would like to include a filter out of a request.querystring. Here is my code Public Shared Function getMsg(ByVal pIdScreenMessage As Integer, ByVal pMem As String) As String Dim pLang As String pLang = Request.querysting("Lang") Dim

Page browser

Comersus Version: 603Database type: AccessFrequency: Permanent issue Currently, to browse from one page to the next one, it is done via a button. What should I do to modify this in order to have something like Page 1 2 3 4 5 6 Next on the screen.

Query error

Comersus Version: 604Database type: AccessFrequency: Permanent issue With Firefox, on comersus_addItem.asp I get the following message: Temporary error "Sorry for the inconvenience. Error in addItem, error: [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same. – Err.Number:-2147217900 – SQL:SELECT MAX(idCartRow) AS maxIdCartRow FROM cartRows WHERE idDbSessionCart=20" I do not

CDont

Comersus Version: 604Database type: AccessFrequency: Permanent issue I am running may store in French. The problem is with the french caracter like ',

Firefox and DHTMLEditor

Comersus Version: 604Database type: AccessFrequency: Permanent issue Is anyone aware of some kind of incompatibility of the DHTML editor of comersus_backoffice_addProductForm.asp and Firefox browser ? The same with Netscape and Opera

Multilanguage store

Comersus Version: 603Database type: AccessFrequency: Permanent issue Although it is described on page 32 of Comersus User's Guide.pdf I do not understand very well how it works.For example I would like to setup a second store in Dutch. Do I need to copy and paste all .asp files currently under comersus/store/ into comersus/dutch/ ? What

pInterWidth

Comersus Version: 604Database type: AccessFrequency: Permanent issue In settings, what is the use of pInterWidth

sub getFromDatabasePerPage

Comersus Version: 603Database type: AccessFrequency: Permanent issue On my page comersus_listCategoriesAndProducts.asp I always get an error #13, but if I remove the follwing code from databaseFunctionsContent.asp then it works fine. Why ? if err.number 0 then response.redirect "comersus_supportError.asp?error="&Server.Urlencode("Error in " &scriptName& ", error: "&Err.Description& " – Err.Number:"&Err.number&" – SQL:"&mySQL) end if

comersus_showCart.asp manages

Comersus Version: 603Database type: AccessFrequency: Permanent issue The page comersus_showCart.asp manages the cart. Is this script working as long as the session is open, or can de customer logoff, and lets

Cannot modify from modifyCustomerForm

Comersus Version: 603Database type: AccessFrequency: Permanent issue Ecah time I want to modify something from backoffice_modifyCustomerForm.asp I got this error message: Erreur de compilation Microsoft VBScript error '800a0401' Fin d'instruction attendue /iisHelp/common/500-100.asp, line 11 Dim objASPError, blnErrorWritten, strServername, strServerIP, strRemoteIP Dim strMethod, lngPos, datNow, strQueryString, strURL ^ Microsoft OLE DB Provider for ODBC Drivers error

Optional checked as default

Comersus Version: 603Database type: AccessFrequency: Permanent issue I have created an option group (the selection method is a check box). Via the settings, I set pForceSelectOptionals on YES.It works fine as long as pItemShown = 0. If pItemShown >1, then on Comersus_index.asp, we have the items on screen, but the one that has options has

Forced options

Comersus Version: 603Database type: AccessFrequency: Permanent issue I have created an option group (the selection method is a check box). Via the settings, I set pForceSelectOptionals on YES.It works fine as long as pItemShown = 0. If pItemShown >1, then on Comersus_index.asp, we have the items on screen, but the one that has options has

Shipping processing

Comersus Version: 603Database type: AccessFrequency: Permanent issue Hi, Could you help me ? I need to discriminate my customers in my country (Belgium) into 3 categories. Category 1: if (zip = 1000 or zip = 1050) AND (PriceFrom=0 to priceUntil=249) then priceToAdd=8 Category2: if (zip = 1000 or zip = 1050) AND (PriceFrom=250 to priceUntil=9999)

Syntax error in update statement

Comersus Version: 603Database type: AccessFrequency: Permanent issue Each time I try to modify the profile of a customer, I get the following erreur message: Syntax error in Update statement. It does not like in the file includes/databaseFunctions.asp the line 84, that is set rsTemp=connTemp.execute(mySQL) What should I do ?

Error when marking as paid

Comersus Version: 603Database type: AccessFrequency: Permanent issue When I want to manually update an order and mark it as paid, (I have no gateway installed my customers pays via their bankaccount), I go trough Store, List all. I select the order that I want to mark as paid. As far as I understand, I must

Table Categories_1

Comersus Version: 603Database type: AccessFrequency: Permanent issue Hi, What is the point to have a table with the name Categories_1 that seems to be a duplicate of Categories ?