Author: Jay Conaway

MSXML2.ServerXMLHTTP

Comersus Version: 708 Database type: SQL 2008 Web Site: www.yocracing.com My version of MSXML2.ServerXMLHTTP.4.0 in the 708 cart ran fine on my old iis 2003 server, now on iis7.5 (2008 R2) won’t run unless I remove the .4.0 and just use “MSXML2.ServerXMLHTTP” but then gatewayPayPalExpress2.asp cannot find the pEmail in the search string mySQL=”SELECT idCustomer

Credit card table

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue The credit card table seems to be managing itself. Credit card data on older orders disappears without input and the table does not seem to be capturing credit card data if there is more than 2 orders currently in "new orders" Is the first by default? please

Bundles images

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue Bundles main product page does not display images 3 or 4. Is this by design? Easily fixed? Thanks Jay

Clone Product Error

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I am getting an error message just like this post: http://www.comersus.org/displayMessage.asp?mid=61937 This is my error: There are errors in your BackOffice+: Error in comersus_backoffice_cloneProductExec.asp, error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','. – Err.Number:-2147217900 – SQL:SELECT MAX(idProduct) AS maxId FROM products WHERE sku='SPB-08GRL' Do

Password email not sent

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I have configured Jmail and all order emails etc seem to be going out and are being received OK, except for forgot password emails are not…. There is no error message. Diagnostic emails received OK….Please advise

Error message when customer is logged into account

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue When a customer is logged into their account, they are unable to browse next page of items listing or use the search. The following error is displayed trying to search: Temporary error Sorry for the inconvenience. Error in advancedSearchExec, error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary

Importing to subcategories

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I have several subcategories which are named the same under different parent categories. What is the proper syntax for the import field "category" to get the products to import to the correct subcategory? If I use the subcategory name it just puts the items into the first

SEO export

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue My SEO export creates pages fine except for the picture and price. There doesn't seem to be a database call in the script for the picture or price. File name: Comersus_backoffice_createHTMLPagesExec.asp Please advise correction…. TIA Jay

Error on Export Products

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I try to export my SQL database table products and get the following: Here is the full error on export to excel: Export Products Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed /comersus708/backofficeplus/comersus_backoffice_exportProductsExec.asp, line 40 Invalid ProgID. For additional information specific to this message please visit

Importing items

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I noticed while importing Customers that the import will not bring in duplicates based on email addresses. Is this the same for the Import Products? Will the import see a duplicate SKU and not import it?

International Zip Codes

Comersus Version: 708Database type: SQL ServerFrequency: Permanent issue I have real time UPS installed and my international customers try to check out, the software replies "ATTENTION: please enter a 5 digit ZIP" Is this comersus software or UPS with the problem? How to correct it? TIA

Search returns $0.00 as price

Comersus Version: 708Database type: AccessFrequency: Permanent issue I am having the same problem as a previous post, but I did not see a final solution posted: Date 4/26/2007 Author Spence Database Access Frequency Sometimes Version 7.0 Subject search tool When I search with a key word the items that show all have a price of

Backoffice Add new order

Comersus Version: 708Database type: AccessFrequency: Permanent issue I need to be able to enter a Phone order and have the order form accept items not in the database. We take a lot of phone orders for items too random to add to the database. is it possible?