Leonard, Works perfectly. Thank you very much. :-) John > Date: Wed, 23 Jun 2010 18:24:42 -0400 > Subject: Re: cfpresentation > From: [email protected] > To: [email protected] > > > Hi John, > > Try something like this: > > Perform for lack of better title a "Master Query" of the information that is > to be included in your presentation. Then do a query of a query to get > specific slide information to display respective to each slide > > - - Master Query - - > <cfquery name="rs_master" datasource="[dsn here]"> > SELECT > [what ever you need from database], > FROM > [table_name] > </cfquery> > > Then within each cfslidepresenation tag do something like below to query for > specific slide information: > > - - Query of Query - - > <cfquery name="rs_slide01" dbtype="query"> > SELECT * > FROM > rs_master > WHERE > [db_field] = <cfqueryparam value="[Enter Value]" cfsqltype="[Enter Type"> AND > [db_field] = <cfqueryparam value="[Enter Value]" cfsqltype="[Enter Type"> > </cfquery> > > This process should give you specific slide information for displaying. > > Leonard > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5030 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
