Let me clarify by saying we have, what is supposed to be duplicate name and address information stored in four files. We also have no way of updating all files to keep them synched. Also, out of the four files, there is no real "master" file from which to query.
The data here is so f**ked! M!ke -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 3:01 PM To: CF-Community Subject: RE: Worst database... ever! We have name and address information stored in about four separate files on our AS400 system. It was home-built by one guy over the last 30 years. Now we are converting away from that creation. -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:47 PM To: CF-Community Subject: Re: Worst database... ever! Well, I get to deal with a DB that has about 38 tables that are supposed to give us basic employee info. If you want to find out where someone works, you have to traverse, at minimum, 5 of those tables. But, don't forget that there at least 3 paths by which you can get this data - take a guess which one is the "right" one. Take another guess as to why that path is the right one, cause I sure don't know. Practically every join is like that. Oh, and primary flags on stuff like phone numbers and addresses - sure, you can have more than one "primary" address - no problem. Which one is mail supposed to get sent to? I dunno. I guess all of the ones marked primary. Oh wait, unless it's the one ones marked primary and "mailing address," except for when you have more than one marked primary mailing address. You get the idea. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:170470 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
