Jim McAtee wrote:

> We're moving a number of backend databases from Access2000 to MySQL 3.23
> (MyISAM) tables.  As with Access, we're using ODBC (CF5) to talk to the MySQL
> server.  Any advice or gotchas we should be aware of?  Things that worked in
> Access that won't work in MySQL?

transactions
subqueries
foreign keys
decimal datatype
NOT NULL constraints

Jochem



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
                                

Reply via email to