Why not just use libraryResources.purchaseDate[1]?
On Wed, Jul 18, 2012 at 9:22 AM, Rob Voyle <[email protected]> wrote: > > Hi Folks > > I have a sales table where a customer may purchase the same item several > times. Each row is an instance of the purchase being made. > > I want to find the first instance of the sales item in the query. > Here is the query > > <cfquery datasource="library" name="libraryResources"> > SELECT customerName, > emailaddress, > item, > password, > purchaseDate > FROM Login > WHERE customerName = <cfqueryparam cfsqltype="cf_sql_varchar" > value="#customer#"> and > password = <cfqueryparam cfsqltype="cf_sql_varchar" value="#password#"> > ORDER BY item > </cfquery> > > I just need the first time an item appears. > > Thanks > Rob > Robert J. Voyle, Psy.D. > Director, Clergy Leadership Institute > For Coaching and Training in Appreciative Inquiry > Author: Restoring Hope: Appreciative Strategies > to Resolve Grief and Resentment > http://www.appreciativeway.com/ > 503-647-2378 or 503-647-2382 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5867 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
