Re: "good code": I've done this once (and am about to do it again) so I'll share a few bits that I learned re: code changes:
99% of my code was fine. But I had to adjust some syntax. MSSQL vs MySQL: LEN needs to be LENGTH CHARINDEX needs to be LOCATE There probably are more differences like that but those are the two I bumped into. There's also the aforemented "timestamp" data type. If you use a "datetime" or "timestamp" field with "getdate()" as the default, you'll need to switch it to a "timestamp" field with a "current_timestamp" default. Queries are also case sensitive so make sure your column names (and, IIRC, table names) match up. I also had issues with how certain joins worked - I don't recall exactly what these issues were so I won't speculate. I just recall having to rewrite some queries to get them to function properly. --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
