Coldfusion with Homesite

I currently use Dreamweaver to build Coldfusion web apps but I am keen to gain a little more power and control over interfacing with my databases. So, I have decided to have a look at Homesite. However, I am not famililar with how Homesite connects to Coldfusion for testing purposes.

A quick guide would be helpful.

Homesite can connect to the CF server if you set up a development mapping within the IDE. But you don't need to do this, you can just point your browser at the site to test your changes.

If you want more info, Homesite comes with full documentation built into the IDE. I'd start there.

Thanks Kiteless,

I have started to develop a web based sales order processing system, for my company, that uses MySQL and Coldfusion. I have taken care of all the data modelling aspects and prototyped the system using Access to validate my overall structure. I have found a wealth of examples, magazines and tutorials that offer advice on developing pretty simple applications. What I have not found are any resources, other than odd forum postings, that take a more detailed look at developing more comples sytems.

Specifically, I dont see a great deal of tutorials which look at situations where PHP or Coldfusion have to administer multiple table inserts when dealing with many-to-many database relations. For example, processing an order in which multiple records have to be added to seperate tables, with lots of table joins etc.

Do you know of any sites or tutorials that look at solutions a little more sophisticated than a user entry system, or a bulletin board or a simple address book. All of these examples concentrate on a handful of tables where simple SELECTS, INSERTS and UPDATES are involved. Is it more appropriate to take a look at some of thw turnkey PHP e-commerce systems and simply tailoring these to meet requirements.

I avoid introducing a detailed specification of my requirements but the solution will need to deal with a large number of customer accounts and orders as well as a scheduling system to organise deliveries. Any advice would be most welcome. Many thanks.

The usual way this is done is to wrap the series of insert queries with a <cftransaction> tag, so that the entire set succeeds or fails as a single unit. Other than that the concept is not really different for using a single table or multiple tables. Obviously if you have lots of tables your SQL gets more complex, but that is completely independent of CF (or PHP or any other app server).

Basically it sounds to me like you're asking for info on advanced SQL more than anything. Devshed has some good forums and there are many good books on the subject as well.