UNIX with CF and CF with MySQL

[ITGL72]

Hi folks, hope you guys can help me answer some questions and let me know if I should turn down this particular project or not.

I have done mild work with COLD FUSION, SQL7 Server, and Access DB's. I am trying to help someone out with some simple cold fusion apps but all he has on his unix host is a MySQL database.

Anyone know if the same type of SQL code I use in a cold fusion template, can be used exactly the same with a MySQL database as it could with SQLServer and Access?

At this point, I really dont want to take something on that requires me to learn something new. Its just not a good time for me as far as that goes.



ALSO...

He has a dedicated web server from his hosting company. Their database is MySQL.

Anyway my clients comment:

"I don't have any experience with Cold Fusion, but it seems like I've heard
of a lot of problems that various people have had trying to implement
it????"


They would have to install CF on this UNIX machine. Anyone have any info for me I can pass on to this client or his web host about doing such a project?



Thanks!!




Lemme know folks!!

 

[strantheman]

Well installing and administrating Cold Fusion is basically the same on NT and linux. NT installs direct from CD, linux has you copy a compressed file over and expand it. The cost is the same, and the code is all compatible.

SQL wise, how complex are the queries you would port over there? If they aren't complex JOINS and you are creating the tables manually it should only take you a day or so to move everything and test it and make minor changes.

"...seems like I've heard of a lot of problems that various people have had trying ..." ask him for specifics next time he says that. If he has no answer it shouldn't ever come up again. Make sure you charge a good price

good luck