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:5866
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
