I don't think there's any mandate about how each recordset is created. Ideally, you'd want one query, but that's not always possible. That's the beauty of FLiP - the architect needn't worry about implementation, only the end result. (My thoughts are to hand off complex qry_ files to a strong DBA developer to develop stored procs, but to each their own)
--- Billy Cravens -----Original Message----- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:13 AM To: [EMAIL PROTECTED] Subject: FLiP/Fusebox Process Question 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 ==^================================================================
