Re: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Well folks, I'm a bit stuck with retrieving data from a mySQL-datasource which was exported from ms-access via a little nifty utility called MyAccess. The problem is that the text in the db has german special characters. Since I exported the data to mySQL I'm able to retrieve all the data but the special-chars are shown as symbols 'n' stuff. I took textpad and looked into the data-files mySQL generates for the datasource and they do contain the german chars. Any help out there? Patric PS> Hi Jerry, PS> thanks for your reply. I'll make sure to have a close look at the PS> db-structure before converting. PS> Patric JJ>> I've done this on 5 projects, now. JJ>> The three things that bit me repeatedly: JJ>> Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ>> Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ>> Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ>> But it really wasn't very difficult. JJ>> Jerry Johnson > [EMAIL PROTECTED] 05/21/02 08:33AM >>> JJ>> Hi fellows, JJ>> i looking for some advice on migrating websites of one of my customers JJ>> from windows to linux. The customers has it's own CF4.5Pro-Server and JJ>> 'cause he switched his entire office to linux he's also chenging the JJ>> webserver to linux with apache. The nice thing is, that is will JJ>> purchase/update to CF5 or MX. Now my question is will the applications JJ>> i wrote under Windows+Access run under Linux+MySQL without bigger JJ>> problems??? i have a event-calendar-app which will probably make no JJ>> trouble. but i have a little shopping-cart-like app with session-vars JJ>> and a full-text-search with verity. JJ>> So if anyone can share experience i would be really glad for any JJ>> input! JJ>> TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Hi Jerry, thanks for your reply. I'll make sure to have a close look at the db-structure before converting. Patric JJ> I've done this on 5 projects, now. JJ> The three things that bit me repeatedly: JJ> Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ> Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ> Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ> But it really wasn't very difficult. JJ> Jerry Johnson [EMAIL PROTECTED] 05/21/02 08:33AM >>> JJ> Hi fellows, JJ> i looking for some advice on migrating websites of one of my customers JJ> from windows to linux. The customers has it's own CF4.5Pro-Server and JJ> 'cause he switched his entire office to linux he's also chenging the JJ> webserver to linux with apache. The nice thing is, that is will JJ> purchase/update to CF5 or MX. Now my question is will the applications JJ> i wrote under Windows+Access run under Linux+MySQL without bigger JJ> problems??? i have a event-calendar-app which will probably make no JJ> trouble. but i have a little shopping-cart-like app with session-vars JJ> and a full-text-search with verity. JJ> So if anyone can share experience i would be really glad for any JJ> input! JJ> TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
I've done this on 5 projects, now. The three things that bit me repeatedly: Boolean types in Access were not the same in mySQL. Went with int (1/0). Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) But it really wasn't very difficult. Jerry Johnson >>> [EMAIL PROTECTED] 05/21/02 08:33AM >>> Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists