RE: TO USE SQL or something entirely different.

[Elizabeth Marcotte - Selphcotte Web Designs]

Jeff

If I understand you correctly - you could create arrays - loop through the
arrays comparing whatever fields you are using to determine the same records
going to the same place, do the calcs on those records - update another
array with the totals for each "same place" - this new array will have one
record for each same place - they loop through the new array and insert into
wherever you need to insert only once.

I am sorry that is confusing - I might not be understanding what you need -
but Arrays are a good way to group data.  Hope that helps.  If you post the
code you are using - it might be easier for people to help?
E

-----Original Message-----
From: Jeff W [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 8:29 AM
To: CF-Talk
Subject: TO USE SQL or something entirely different.

I need a good starting point.

I am looking to streamline our shipping procedures. Right now I generate two
queries that divide out packages that are going UPS and US mail. Thats the
easy part.. These insert easily into our standard UPS software. LOL

What I would like to do.

Each business card order is shipped pretty much separately (for drop ship
purposes and the fact that not every color is produced everyday). So A UPS
query may have multiple sets of cards (records) going to the same place. How
in the world can I take that query, combine all the records that are the
same, add their weights up and insert them back into the list only once???

I am open for suggestions.

Jeff
Priority Business Cards
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists