Which date do you want? You have multiple entries - which one should the query return?
On 10/2/07, Travis Haley <[EMAIL PROTECTED]> wrote: > But I need the date, should I run this in a second query? > > Travis Haley > > -----Original Message----- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Monday, October 01, 2007 6:45 PM > To: CF-Talk > Subject: Re: Adding Small sections of a query > > Remove the date from the query. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4