I have setup my first Model Glue application and am using Reactor for the persistence layer. I have 3 tables: Vehicle, VehicleMake and VehicleModel. A Vehicle "has one" VehicleMake and is setup that way in the reactor.xml. The data is currently stored as makeId in the Vehicle table. My question is this: What is the _best practice_ to get the make description (another field in the VehicleMake table) when I am retrieving all (or some subset) of the vehicle records? Right now I am using the VehicleGateway.getAll() command to get a query with all the vehicles, but simply outputting that data gives me only the modelId. Do I simply override the getAll() function with a function that does a join with the other table?
Thanks, Mark ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
