raghusharma
Posts: 4
|
Posted: 11/27/2009, 8:23 AM |
|
Hi
I have created an application based on the store template, in ASP. This work when connected to MS Access.
However when I configure it to use MySQL I getback the following error loading the home page.
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch
/myStore/Header_events.asp, line 21
Windows XPSP3, MySQL 5.1.41, ASP + templates.
Please advise if there are any thoughts
|
|
|
Edd
Posts: 547
|
Posted: 11/27/2009, 3:22 PM |
|
You have done something in the Header file
Look at line 21 in the events you probably used MSACCESS syntax to retrieve data.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
raghusharma
Posts: 4
|
Posted: 11/27/2009, 11:47 PM |
|
Fixed issue by adding CStr
Before:
Cart_ID = CCDLookUp("COUNT(shopping_cart_id)","store_shopping_carts","shopping_cart_id="&InternetDB.ToSQL(Request.Cookies("shopping_cart_id"),ccsInteger), InternetDB)
After:
Cart_ID = CStr(CCDLookUp("COUNT(shopping_cart_id)","store_shopping_carts","shopping_cart_id="&InternetDB.ToSQL(Request.Cookies("shopping_cart_id"),ccsInteger), InternetDB))
Not sure this is the correct way.
Could it be an problem with mySQL setup
|
|
|
|