Supposedly with the FLiP/FuseBox process, an application architect goes through and "designs" the entire application and in the end has a collection of fusedocs. Now the database fusedocs get handed off to the DB guy and he/she is supposed to design the database and all the queries - right?
What happens, since the architect does not know anything about the database design, if the query fusedocs specify something that cannot be accomplished using just a single query? For example, say I want to retrieve a list of books in a certain genre from a library, but one of the fields I want returned in the recordset is a the author of the book. Now, a book can have multiple authors though, so the author field would actually be a list that would need to be generated from a seperate query. To solve this, can a single query file contain more than one query and some other CF logic to generate the required result or what happens here? I am running into a situation like this where I have a set of query fusedocs and a pre-existing database and there is not a method to use a single query to generate the required results (unless someone knows how to make a single field in a recordset actually be a comma seperated list of values from another query?). Thanks Jeff Chastain ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
