cfloop and update

[ghanna]

I have a table with fields id, receiverid, cuid (customer unique id) and type.
id is the primary key. Each receiverid is assigned to a single cuid BUT cuid
can have one or more receiverid. I need to loop over the entire table and
assign type of Primary to each record that has a 1 to 1 relationship. If the
cuid has a multiple of receiverid's one type needs to be assigned primary and
the remaining needs to be assigned secondary.

Confused yet? (I am)

So for example:
Customer A has one receiver (one record in the table) so the type would be
primary.
Customer B has three receivers (three records in the table) so 1 record would
have type assigned to Primary and record two and three would have the type
assigned to secondary.

Now for the million dollar question? Can it be done with cfloop and updating
each record or do we have to do it manually?

Thanks in advance for you help!

Gary

[mxstu]

Is this a one time update? If so, instead of looping through each record, it
would be more efficient to create a small sql script to do this, using a temp
table perhaps and one or two update statements. It shouldn't be that complex.

[ghanna]

Thanks... We did it manually with a simple update record page. I don't know enough about SQL to write scripts.

[mxstu]

Glad you got your problem solved!