Your history tag is invalid ;-) Missing the trailing slash --- Billy Cravens
-----Original Message----- From: Jeff Chastain [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:35 AM To: [EMAIL PROTECTED] Subject: Re: FLiP/Fusebox Process Question Steve, That was the answer I was looking for. I did not know if I had to stick to a query file only contains a sinlge cfquery statement or if I could do some other things as long as I sent out the right results. If anyone wants to look ... here is the fuseDoc. Thanks Jeff -------------------- <!--- --> <fusedoc fuse="qry_getDocumentInfo.cfm" language="ColdFusion" specification="2.0"> <responsibilities> I retrieve information about the given document. </responsibilities> <properties> <history author="david johns" date="2/24/2002" type="create" role="architect"> </properties> <io> <in> <string name="dbPath" scope="request" /> <boolean name="runQuerySims" scope="request" /> <string name="documentID" scope="attributes" optional="Yes" /> </in> <out> <recordset name="documentInfo" /> <string name="documentID" /> <string name="documentName" /> <string name="documentFile" /> <list name="documentAuthors" delimeters="," /> <list name="documentAuthorEmails" delimeters="," /> <string name="documentStatus" /> <list name="approveReviewers" delimeters="," /> <list name="approveReviewerEmails" delimeters="," /> <number name="tallyDisapprove" precision="Integer" /> <list name="disapproveReviewers" delimeters="," /> <list name="disapproveReviewerEmails" delimeters="," /> <number name="tallyNA" precision="Integer" /> <list name="naReviewers" delimeters="," /> <list name="naReviewerEmails" delimeters="," /> <number name="tallyNoVote" precision="Integer" /> <list name="noVoteReviewers" delimeters="," /> <list name="noVoteReviewerEmails" delimeters="," /> </recordset> </out> </io> </fusedoc> ---> -------------------- ---------- Original Message ---------------------------------- From: Steve Nelson <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 28 Mar 2002 11:33:01 -0500 >show us your fusedoc, maybe we can figure it out. > >Often I'll have a single recordset out that will require multiple SQL statements. It doesn't matter if it happens in one cfquery or 5, as long as it outputs the correct data. For that matter you could use the querynew/queryaddrow/querysetcell functions in CF to make your outputted recordset what you want. > >Steve Nelson > >Jeff Chastain wrote: > >> 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 ==^================================================================
