Defining table relationships


show more Defining table relationships provides you with in-depth training on Developer. Taught by Daniel Short as part of the ColdFusion 9 New Features show less
please wait ...

Defining table relationships

So far we've been dealing with a single object at a time. But in the application world you never have objects that act in isolation. The key to any good application is how it handles related bits of information, using links between tables. In this video we are going to cover how to define foreign key relationships between your objects and how those objects get returned to you when pulling the entities out of the database. So in Chapter5 open up tablerelationships.cfm. Like before, all we are doing is loading a single entity and dumping it out to the screen.

All of our work in this case is going to be done inside of our cfcs. So in order to define relationships, we need to have two things to relate to each right other. Right now we only have an Artist.cfc. Let's create the art component, so I can relate artist and art to each other. In the cfcs folder, right- click and choose New and File. We'll name the file Art.cfc and click Finish. Inside here we'll say cfcomponent persiste...

Defining table relationships
Video duration: 5m 13s 2h 40m Intermediate

Viewers:

Defining table relationships provides you with in-depth training on Developer. Taught by Daniel Short as part of the ColdFusion 9 New Features

Subjects:
Developer Web
Software:
ColdFusion
Author:
please wait ...