Tag Archives: SELECT

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 […]

Posted in Uncategorized | Tagged , , | 4 Comments

Subscript out of range – Err.Number:9

Comersus Version: 7097Database type: AccessFrequency: Permanent issue I'm getting this error only when I'm trying to process payments with comersus_gatewayAuthorizenetAimForm.asp Error in getSettingKey, error: Subscript out of range – Err.Number:9 – SQL:SELECT settingValue FROM settings WHERE settingKey='pSendDigitalGoodsByEmail' AND idStore=1 I have attempted to run the SELECT statement through the backoffice interface and was successful. I […]

Posted in Uncategorized | Tagged | 1 Comment

Err.Number:13 – SQL:SELECT screenMessage

Comersus Version: 702Database type: AccessFrequency: Permanent issue I am getting this message when confirming payment to paypal. I have check the forum and no one has a deifinite answer. Sorry for the inconvenience. Error in screenMessages, error: Type mismatch – Err.Number:13 – SQL:SELECT screenMessage FROM screenMessages WHERE idScreenMessage=717 AND idStore=1

Posted in Uncategorized | Tagged | 1 Comment

Install not creating Settings table

Comersus Version: 700Database type: OtherFrequency: Permanent issue Hi, I'm installing Comersus MySQL on Godaddy hosting and I switched from installing as DSN to installing DSN-less (which may have caused my problem). I keep getting "WARNING (!) It seems that you have not defined database folder permissions" from comersus_backoffice_install0.asp. It seems as if it's trying to […]

Posted in Uncategorized | Tagged , , , | 1 Comment

Dynamic Currency Conversion

Comersus Version: 709Database type: SQL ServerFrequency: Permanent issue I am running the Power Pack for version 709. I switched 'pCurrencyConversion' to DYNAMIC and when I click on the 'Other Currencies' link I get this error from the getSettingKey.asp script: Temporary error Sorry for the inconvenience. Error in getSettingKey error Type mismatch – ErrNumber13 – SQLSELECT […]

Posted in Uncategorized | Tagged , , , | 1 Comment

Error in 'Auction'

Comersus Version: 708Database type: OtherFrequency: Permanent issue To: Sisro From: Sophia When running the query you mentioned: SELECT customers.idCustomer, email FROM auctionOffers, customers WHERE customers.idCustomer=auctionOffers.idCustomer It returned 'No Results' Your time is greatly appreciated! Thanks,

Posted in Uncategorized | Tagged , | 1 Comment

database call issue

Comersus Version: 708Database type: AccessFrequency: Permanent issue I installed a clean installation of 7.08 and then upgraded a 6.x database. However, upon upgrading DB it warned that it did not believe it was a version 6.x DB … not sure why. I get this error when clicking on a category in the left navigation pane […]

Posted in Uncategorized | Tagged , , , | 1 Comment

Bundled items – sorting according to idProduct

Comersus Version: 707Database type: AccessFrequency: Permanent issue How do I sort the listing of the bundled items according to ipProduct-field ? If I insert & " ORDER BY idProduct" in the end of the SELECT products…-line in …viewItemBundle.asp (within get inner products) I get time out – only 6100 items (testing locally ISS, IE7). Thnx […]

Posted in Uncategorized | Tagged , | 2 Comments

Err.Number:5 – SQL:SELECT idProduct FROM products

Comersus Version: 705Database type: SQL ServerFrequency: Permanent issue Hi I have downloaded the free zip file and being studyi it now ,i got a few questions at the same time. 1 I've finished the installion follow the installation wizard, i can browse the backofficelite page on http://localhost/comersus/backofficelite/comersus_backoffice_index.asp, how to add the second store? i didn't […]

Posted in Uncategorized | Tagged , | 3 Comments

Search for item which is in more than 1 category

Comersus Version: 705Database type: OtherFrequency: Permanent issue Hi, I'm trying to modify the 'search' functions so that a customer can search for an item which is in two categories. e.g. search: Keyword: tacx Category: Bottle cage Manufacturer: Campagnolo where the category has the idCategory=60 and the manufacturer has the idCategory=501. I think my only problem […]

Posted in Uncategorized | Tagged , , | 1 Comment

Missing operator

Comersus Version: 705Database type: OtherFrequency: Permanent issue Hi, I'm trying to run the SQL query: pTime = "12:48:00" SELECT idAuction, details, startDate, startTime, endDate, endTime, active, startPrice, endPrice, ebayItemNo FROM auctions WHERE endTime > "&pTime&" ORDER BY endDate ASC, endTime ASC however it returns the error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in […]

Posted in Uncategorized | Tagged , | 1 Comment

Err.Number:5 – SQL:SELECT screenMessage

Comersus Version: 700Database type: AccessFrequency: Permanent issue Hi! I have this problem when the checkout is at its end, and there is only, confirmation left. When I click on Checkout, after everything is done (and everything else goes well) Error I'm getting is: Temporary error Sorry for the inconvenience. Error in screenMessages, error: Invalid procedure […]

Posted in Uncategorized | Tagged , , | 2 Comments

2147217900 – SQL:SELECT idOrder FROM orders

Comersus Version: 700Database type: SQL ServerFrequency: Permanent issue Temporary error Sorry for the inconvenience. Error in saveorder 10, error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'shipmentDetails'. – Err.Number:-2147217900 – SQL:SELECT idOrder FROM orders WHERE nroRan=76602 AND idCustomer=4 AND orderDate='30/05/2006' I am getting this all the time . I buyed power pack version 7 , […]

Posted in Uncategorized | Tagged | 1 Comment

chartCancelOrdersPerMonth.asp issue.

Comersus Version: 607Database type: OtherFrequency: Permanent issue I just requested the updated script "comersus_backoffice_chartCancelOrdersPerMonth.asp" and it still produces the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax […]

Posted in Uncategorized | Tagged , , | 4 Comments

Type mismatch – Err.Number:13

Comersus Version: 607Database type: OtherFrequency: Permanent issue After adding product to cart, selecting payment method, I press "confirm" on "comersus_checkOutOrderVerify.asp" and I get the following error where I would expect the site to be redirected to the payment site (PayPal). Temporary error Sorry for the inconvenience. Error in getSettingKey, error: Type mismatch – Err.Number:13 – […]

Posted in Uncategorized | Tagged | 7 Comments

forgotpassword

Comersus Version: 607Database type: AccessFrequency: Permanent issue http://www.matimu.com/comersus/store/comersus_optForgotPasswordForm.asp Here is the error: Temporary error Sorry for the inconvenience. Error in screenMessages, error: Type mismatch – Err.Number:13 – SQL:SELECT screenMessage FROM screenMessages WHERE idScreenMessage=581 AND idStore=1 This is the error I get in the comersus_message.asp when I display the SQL. Not sure if this is the […]

Posted in Uncategorized | Tagged , | 5 Comments

Err.Number:424 – SQL:SELECT screenMessage FROM scr

Comersus Version: 603Database type: AccessFrequency: Permanent issue I receive this error Temporary error Sorry for the inconvenience. Error in screenMessages, error: Object required – Err.Number:424 – SQL:SELECT screenMessage FROM screenMessages WHERE idScreenMessage=104 AND idStore=1 when I try to send (email to a friend). I just switch over to godaddy's dedicated server. I receive this error […]

Posted in Uncategorized | Tagged | 1 Comment

Default Billing Country – checkOutCustomerForm.asp

Comersus Version: 600Database type: AccessFrequency: Random issue Hi, I would like to have "United States" as the default in the options list on the comersus_checkOutCustomerForm.asp Following other post I was able to get the Shipping Address Country to default to the United States. however no luck on the billing country. Here is the code from […]

Posted in Uncategorized | Tagged , , , | 2 Comments

Error in BackofficePlus Menu

Comersus Version: 605Database type: AccessFrequency: Permanent issue The Scipt in question is /backofficeplus/comersus_menu.asp . Version is 6.05. After going through the login the system eventually sends you here. I keep getting an error like: There are errors in your BackOffice+: Error (getFromDatabase) in comersus_backoffice_menu.asp, error: – Err.Number:-2147467259 – SQL:SELECT COUNT(*) AS pGarbageRecords FROM dbSession WHERE […]

Posted in Uncategorized | Tagged , | 1 Comment

Shipping Issue – comersus_shippingCostForm.asp

Comersus Version: 5099Database type: SQL ServerFrequency: Permanent issue issue: i'm trying to assign a shipping type for a given state; when i select that state from the dropdown on comersus_shippingCostForm.asp it says no service types loaded for this location. I ran the sql query on mssql2000, and it showed no results , this is query; […]

Posted in Uncategorized | Tagged , , | 1 Comment
© 2017 Comersus Forum. All Rights Reserved.
Powered by WordPress. Download Free Shopping Cart Now
porno porno izle porno izle