I want to edit the defualt databases that come with CF

Thanks all

yeah man it's real real easy. You can also use MS Access to make a database as well for testing purposes. I wouldnt use MS Access in full production because it's slow and it can only handle one client at a time. But for testing purposes I use it all the time, just because it's easy. And I can make sure all my tables are in lined and my relationships are good, then I just reprogram it into MySQL or PostGreSQL. It's easy.

As far as how to go about doing it. Log in to your CF Admin, think it's something like http://localhost:8500/CFIDE/administrator/index.cfm

Go down the menu on the left side til you see something like databases or datasources or something like that, can't remember on the top of my head, i just push the button. Then click add. It's very very basic and simple.

If your doing a MySQL one, you gotta download the MySQL stuff from their site. They got the driver or whatever it's called on there, think it's like 15 to 30 megs. Then DL the Admin software after you set up your local host mysql server. Then it's ready to go. As well if you're really really new. There's software out there that's free that can redo an MS Access database into MySQL and plug it right into your mysql database with little or no effort. The free ones that I have found only handle 10 records, so just dont plug in a lot of info into your tables on access. But I really only use access just to test my relationships and make sure it all works, so it works good for me.

Sometimes they're will be a few bugs, usually in the bolean values and I'll have to go in and manually edit that, as well as in my source code for my web apps. But as far as code, you can always use the CFqueryparam or whatever it's called, I just usually don't unless I'm not 100% positive what database format I'm sending my completed program too. Usually this is a good idea when dealing with clients that don't know anything about their hosting provider.

O yeah, also dealing with MySQL, I've found some of the software that comes with it, I just didn't like it. There's a program that I really enjoy called navicat, its like 40 bucks, but the free version should be more than fine for you if you're just getting started. I'm big fan of navicat, but I don't have any experience with the other software available out there. Navicat is just a program that makes it easier to inspect the tables and records and what not. Make sure all my boolean values and data are correct before I make a dump file.

Yes.

http://www.adobe.com/devnet/dreamweaver/articles/setting_up_php.html

http://www.fordwebs.com/iis7testing.cfm

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com


"nikos101" <webforumsuser@macromedia.com> wrote in message
news:gbtg4i$4to$1@forums.macromedia.com...
>I am not sure how I do that :(
>
> Is it easy to use a local mysql database?

I am not sure how I do that :(

Is it easy to use a local mysql database?

Wouldn't it be easier to write a database on your development machine and add a datasource to cold fusion?

I want to use them to generate a CRUD application in Flex 3 wizard, since I don't have rds to remote server where my database tables are.

What are you trying to do with them?

http://www.forta.com/blog/index.cfm/2007/5/29/More-On-Scorpio-And-Apache-Derby

http://coldfusion.sys-con.com/node/441652

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com


"nikos101" <webforumsuser@macromedia.com> wrote in message
news:gbqrnh$hs3$1@forums.macromedia.com...
>I have installed coldfusion in windows XP and I want to edit the defualt
>databases that come with CF. How do I do this?