Re: How well does CF run with mySQL?
I don't know how CF works together with SQL 7 but I run it with SQL 6.5 and it works extremely well ! Uwe - Original Message - From: Mike Sheldon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 12, 2000 12:51 AM Subject: RE: How well does CF run with mySQL? CF runs just fine with MySQL on Linux. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 15:29 To: [EMAIL PROTECTED] Subject: Re: How well does CF run with mySQL? Again, the question was - how well does CF run with MYSQL on a Linux maching, not Microsoft SQL7 on an NT box. At 11:27 PM 4/11/2000 +0100, you wrote: - Original Message - From: "Kevin R. Merker" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 6:10 PM Microsoft makes it pretty simple to migrate an Access DB to SQL7 Server. In theory it might - but if you use Access specific syntax in CF templates, there could be a major editing job to do to actually get it to run with SQL Server. An example is the Access "yes/no" or "true/false" which are reserved column names for SQL Server. SQL Server uses "1/0". This notion of "prototyping" with Access then upsizing to SQL Server has too many issues IMO - especially when it is just as easy to use SQL Server from the outset. Adrian Cooper. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I am doing a prototype app with Access but now need to port to a stronger database program. Any suggestions? I understand Cold Fusion 4.5 still does not have direct native support for mySQL, true or false? Thanks for your help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: how well does CF run with mySQL
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I use mySQL and SQL Server 7 with Cold Fusion 4 on NT and they both run fine. The thing you need to be aware about mySQL is that it does not enforce Foreign Keys. This means you cannot have the database itself enforce data integrity. For example, you might have a person table and a phone table like so: Person Table PersonID Name Age Phone Table PhoneTypeID ( work, home, day, night, mobile ) PersonID Number In SQL Server, Oracle and other relational databases, you can have it setup so that you cannot insert a PersonID into the Phone table unless it exists in the Person Table. In mySQL, there is no way to enforce this except by first checking the Person table with your application, then inserting into the Phone table. mySQL also does not have stored procedures. But mySQL is very, very *fast* because it is missing these features. It was made this way on purpose. There are some surprisingly large sites that use mySQL, none of which I can remember at the moment. I know several start ups that are using mySQL and are very happy. Eventually they'll make the move to SQL Server or Oracle, but for now mySQL does the job well. Roy. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I am doing a prototype app with Access but now need to port to a stronger database program. Any suggestions? I understand Cold Fusion 4.5 still does not have direct native support for mySQL, true or false? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
Actually I was referring to mySQL for Linux:) At 05:10 PM 4/11/2000 +, you wrote: Microsoft makes it pretty simple to migrate an Access DB to SQL7 Server. KM - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 6:14 PM Subject: Re: How well does CF run with mySQL? How well does CF run with mySQL? Is it better to go with SQL7 or Oracle 8i? I am doing a prototype app with Access but now need to port to a stronger database program. Any suggestions? I understand Cold Fusion 4.5 still does not have direct native support for mySQL, true or false? Thanks for your help. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
- Original Message - From: "Kevin R. Merker" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 6:10 PM Microsoft makes it pretty simple to migrate an Access DB to SQL7 Server. In theory it might - but if you use Access specific syntax in CF templates, there could be a major editing job to do to actually get it to run with SQL Server. An example is the Access "yes/no" or "true/false" which are reserved column names for SQL Server. SQL Server uses "1/0". This notion of "prototyping" with Access then upsizing to SQL Server has too many issues IMO - especially when it is just as easy to use SQL Server from the outset. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How well does CF run with mySQL?
Again, the question was - how well does CF run with MYSQL on a Linux maching, not Microsoft SQL7 on an NT box. At 11:27 PM 4/11/2000 +0100, you wrote: - Original Message - From: "Kevin R. Merker" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 6:10 PM Microsoft makes it pretty simple to migrate an Access DB to SQL7 Server. In theory it might - but if you use Access specific syntax in CF templates, there could be a major editing job to do to actually get it to run with SQL Server. An example is the Access "yes/no" or "true/false" which are reserved column names for SQL Server. SQL Server uses "1/0". This notion of "prototyping" with Access then upsizing to SQL Server has too many issues IMO - especially when it is just as easy to use SQL Server from the outset. Adrian Cooper. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How well does CF run with mySQL?
CF runs just fine with MySQL on Linux. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 11, 2000 15:29 To: [EMAIL PROTECTED] Subject: Re: How well does CF run with mySQL? Again, the question was - how well does CF run with MYSQL on a Linux maching, not Microsoft SQL7 on an NT box. At 11:27 PM 4/11/2000 +0100, you wrote: - Original Message - From: "Kevin R. Merker" [EMAIL PROTECTED] Sent: Tuesday, April 11, 2000 6:10 PM Microsoft makes it pretty simple to migrate an Access DB to SQL7 Server. In theory it might - but if you use Access specific syntax in CF templates, there could be a major editing job to do to actually get it to run with SQL Server. An example is the Access "yes/no" or "true/false" which are reserved column names for SQL Server. SQL Server uses "1/0". This notion of "prototyping" with Access then upsizing to SQL Server has too many issues IMO - especially when it is just as easy to use SQL Server from the outset. Adrian Cooper. --- --- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
