Loop through query to find value

Expand Post »

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!

Similar Threads

Clean Previous Next Script for MySQL results in PHP
how to delete duplicate record in a table by using SQL query in MS SQL
Arithmetic Evaluation and Pipes in BASH in Shell Scripting
help with my for loop in C++
query to find the 10th maximum salary in MS SQL

lafalot

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

35 posts
since Apr 2007

Permalink

Apr 26th, 2007

Re: Loop through query to find value

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)
-------------------------------------------------
|customer_num# 1      2007-04-26
|                                2007-04-16
-------------------------------------------------
|customer_num# 2      2007-03-10
-------------------------------------------------
|customer_num# 3      2007-03-20
|                                2007-04-06
-------------------------------------------------
-------------------------------------------------
|customer_num# 1      2007-04-26
|                                2007-04-16
-------------------------------------------------
|customer_num# 2      2007-03-10
-------------------------------------------------
|customer_num# 3      2007-03-20
|                                2007-04-06
-------------------------------------------------

cfAllie

Reputation Points: 10

Solved Threads: 0

Unverified User

Offline

28 posts
since Mar 2007

Permalink

Apr 26th, 2007

Re: Loop through query to find value

Yep, that worked! Thank you, CFAllie!

lafalot

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

35 posts
since Apr 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ColdFusion Forum Timeline: Passing a structure into an Oracle Procedure

Next Thread in ColdFusion Forum Timeline: Zoom Image

DaniWeb Message

Cancel Changes

User Name
Password