CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Moving Store app from MS Access to MySQL

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.