> I am using cfpresentation, and I need to pull data from a database to > build the presentation, however how do you write the query to assemble > it. I have the content for cfpresentationslide and it displays on a > slide by slide basis. However, again, how would you write the query > to list the slides. I have a basic query like this: > > <cfquery name="" datasource=""> > select * from table where slidelist = 'some number' > </cfquery> > > Any help is greatly appreciated.
John, Try this: <cfquery name="MAY120700" datasource="Training"> SELECT * FROM dbo.BloodDrive WHERE ApptDate = '05/12/10' and ApptTime = '0700' ORDER BY dbo.BloodDrive.Name </cfquery> ****The datasource="Training" is my database ****The From is my table name I am looking for all appointments on 5/12/10 at 7:00am & Ordering them by the name column. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5028 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
