Tag: 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

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

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

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

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

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,

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

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

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

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

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

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

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 ,

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

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 –

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

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

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

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

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;