Kinda general, but look for commonalities that can be condensed into a variable ie
If x in (list name) and z in (other list name) etc... -----Original Message----- From: C. Hatton Humphrey [mailto:[email protected]] Sent: Wednesday, November 11, 2009 2:17 PM To: cf-community Subject: Programming Help - aka "Somebody shoot me please!" Working on a program translation, still part of the massive project of taking 88 VFP apps and turning them into something a tad more modern (VB.NET). I working on the current program, I've discovered something that is likely to give me nightmares for days. It's a file conversion program that handles a lot of different clients. Along with finding that there are 8 different hard-coded templates containing the mappings, I've run into some code that is EXTREMELY specific to a single dataset from a single client. I created a generic mapping tool to handle the 8 but now I'm finding things that refer to specific data items and make changes as they go. I mean like "if x in (1, 3, 203, 54) and y is null and z in ('a', 'c', 'g') then set x = 4" (not the specific conditions and action but you get the point. ????? So aside from venting this to people that "feel my pain" I need some suggestions on how to handle these situations. This program is 13 years old and I'm almost positive that I'm going to find more of these kinds of things. I want to keep my stuff as "generic" as possible but have to include the full functionality of the old program. This file processor is running as a Windows service, BTW. I wanted to be able to perform the file conversions (from a CSV or fixed length file to an EDI-type format) asynchronously so I have two different elements - one is the upload page on the web portal, the other is a disk based service. It is that service that is encountering this stuff. Any suggestions on where this code should go? Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:307695 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
