Loop through query to find value

Reply

•
•
Join Date: Apr 2007
Posts: 29
Reputation: lafalot is an unknown quantity at this point 
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Loop through query to find value

 
0
  #1
Apr 24th, 2007
Hi all,

I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is the same, have all those records displayed together in a table row.
Is there a way to do this?

Thanks in advance!
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2007
Posts: 28
Reputation: cfAllie is an unknown quantity at this point 
Solved Threads: 0
cfAllie cfAllie is offline Offline
Light Poster

Re: Loop through query to find value

 
0
  #2
Apr 26th, 2007
If you order the query by customer_number you can use cfoutput with the group attribute to group the results together.

Sorry for the poor wrapping

ColdFusion Syntax (Toggle Plain Text) 
  1. -------------------------------------------------
  2. |customer_num# 1      2007-04-26
  3. |                                2007-04-16
  4. -------------------------------------------------
  5. |customer_num# 2      2007-03-10
  6. -------------------------------------------------
  7. |customer_num# 3      2007-03-20
  8. |                                2007-04-06
  9. -------------------------------------------------
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2007
Posts: 29
Reputation: lafalot is an unknown quantity at this point 
Solved Threads: 0
lafalot lafalot is offline Offline
Light Poster

Re: Loop through query to find value

 
0
  #3
Apr 26th, 2007
Yep, that worked! Thank you, CFAllie!
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ColdFusion Forum
Thread Tools Search this Thread



adobe adobelivecyclees alfresco amazon cfquery checkbox coldfusion contentmanagement dreamweaver ebooks insert kindle multiple opensource openstandards pdf select sony sonyreader
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC