Tag: Frequency Comersus

error in SQL at saveorder.asp

Comersus Version: 0Database type: Frequency: Comersus version: 3.80 Database: SQL Server Frequency: Sometimes Do any one know how to fix the following error: supporterror.asp?error=Error+in+saveorder+2%2E+Error%3A+%5BMicrosoft%5D%5BODBC+SQL+Server+Driver%5D%5BSQL+Server%5DString+or+binary+data+would+be+truncated%2E+SQL%3AINSERT+INTO+customers+%28name%2C+lastName%2C+customerCompany%2C+phone%2C+email%2C+address%2C+zip%2C+state%2C+stateCode%2C+city%2C+countryCode%2C+shippingAddress%2C+shippingZip%2C+shippingState%2C+shippingStateCode%2C+shippingCity%2C+shippingCountryCode%2C+password%2C+customerType%29+VALUES+%28%2734343%27%2C%2743434%27%2C%27%27%2C%27343434%27%2C%27lwest26%40hotmail%2Ecom%27%2C%273434%27%2C%27343434%27%2C%27%27%2C%27MI%27%2C%273434%27%2C%27US%27%2C%27%27%2C%27%27%2C%27%27%2C%27%27%2C%27%27%2C%27%27%2C%27%7C194%7C235%7C211%7C113%7C215%7C244%7C107%7C16%27%2C0%29%3Cbr%3EIf+you+are+using+Jet+connection+try+to+use+default+connection+instead%2E

Payment Type: Credit Cards

Comersus Version: 0Database type: Frequency: Comersus version: 4.10 Database: Access Frequency: Always Hi, When buying an item and selecting 'Credit Cards' from the order screen, when the invoice is displayed, the following field is not populated. Payment type: Credit Cards $0.00 Is the Payment Type setup incorrectly, or is this a bug? Regards

Separate Shipping Address

Comersus Version: 0Database type: Frequency: Comersus version: 4.10 Database: SQL Server Frequency: Sometimes Could one change the script so the separate shipping address is stored permanently in the database? It seems to last only until the customer's session expires. Or is that the way it's meant to be? cheers

MySQL

Comersus Version: 0Database type: Frequency: Comersus version: 3.80 Database: other Frequency: Sometimes Will MySQL work with version 3.80?

Pay Pal?

Comersus Version: 0Database type: Frequency: Comersus version: 4.10 Database: Access Frequency: Sometimes I don't see where PayPal is a configurable option in the downloadable distribution.. your "features" list claims that it IS supported in this distribution.. Am I missing something?

please disregard

Comersus Version: 0Database type: Frequency: Comersus version: 4.10 Database: Access Frequency: Sometimes please disregard my last post.. thanks. (figured it out)

Access To MySQL

Comersus Version: 0Database type: Frequency: Comersus version: 4.10 Database: Access Frequency: Always I would like to use MySQL instead of Access, however I've been having trouble making it happen. What in particular do I need to do to make this work?

exclude characters "&" and '

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: SQL Server Frequency: Sometimes Hi When a customer fills out the orderform, and uses either an ampersand (&) or an apostrophe (') they get an error after submitting. Is there any way to exclude these characters from the orderform?? Thanks! Comersus Rules!

Too many items in your cart

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access Frequency: Always It keeps telling me "Too many items in your cart", but there is nothing in their. I can't add anything to my cart. I'm using the demo database, and have cookies turned on. All the tests in "tools" check out OK.

Sub Select in MySql

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: other Frequency: Sometimes I m working with my_sql. How transform the subselect found in backoffice_comersus_ModifyProductForm.asp: – SELECT * FROM categories WHERE idCategory>0 AND idCategory NOT IN (SELECT A.idCategory from categories A, categories B WHERE A.idcategory=B.idparentcategory) to mysql ????

suffix $0.00 US or $0.00 CAN

Comersus Version: 0Database type: Frequency: Comersus version: 4.00 Database: Access Frequency: Always How do I get an item price to indicate either US dollars or Canadian (CAN) dollars. I tried adding US or CAN in the list price column but it only allows numbers. Thanks Rodge

Search question

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: SQL Server Frequency: Always Hello there, Well, I have a question. In the Comersus Search, what or where we search is only the fields, products details and products description. It is possible I find in more that only two fields? Thanks very much!

Cannot Send Any Emails

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access Frequency: Always I cannot send emails at any time, including time of purchase and when payment status changed to paid. I need to be able to configure offline payment with email reciept. Please Help. I tried the email diagnostic that you provide, and I can

coments

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access hi when you recive a coment in one producto with review system, the manager of the comersus recibe a e-mail with the review? like a foro? or not? thnks

Setting Up Offline Payment

Comersus Version: 0Database type: Frequency: Comersus version: 3.90 Database: SQL Server Hello I am trying to setup Comersus to collect payment information offline and let my staff process the credit card at a POS terminal. I have looked through the instructions and cannot find the information on how to do this. I have purchased BackOffice

driver error 80004005

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access Frequency: Sometimes Hi,i need your help to resolve this problem: Comersus Diagnostics and Tools Database write test Trying to insert one new product named: Product 552 Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key

justufy??

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access Frequency: Sometimes hi again, can i justify the text of product description in dynamicindex.asp and viewitem.asp thank you

No Shipping Needed

Comersus Version: 0Database type: Frequency: Comersus version: 4.051 Database: Access Frequency: Sometimes How do I disable the shipping all together so it is not part of the checkout? We do catering local and so I do not need it and would like to cleanup the checkout process….