I have an application that pulls a customers record. There are some cases
where the customer will have more then one record. What I thought about
doing was query the customer table for the creationdate based on each
customerkey returned. Then compare the results for the record with the
newest creationdate and use that record.
I am getting stuck after I return the creationdates. Below is the query I
am using.
<cfloop index="i" list="#sKeys#" delimiters=",">
<cfquery>
SELECT CustomerKey, Creationdate
FROM Customer
WHERE CustomerKey = #i#
</cfquery>
<cfoutput>
</cfloop>
I guess I am stuck on how to determine which of the creationdates returned
is the most current. The CreationDate column in the DB is a DateTime
field.
Thanks in Advance.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
