Im trying to logic through how to do the following. Any input would be
appreciated.
I understand in the end I can just use <cfquery> to call this data when I am
ready to build an app to do this but for now I am trying to get a grip on
how to structure this logic.
I have 2 pieces of data:
A: Original exported data from a DB from the below venor. Included are:
PartNo, my OLD cost, our sales price, text formula of how to turn my OLD
cost, into our sales price.
B: New price sheet in csv form from the vendor showing PartNo, and my cost.
My goal is to update our sales price to new prices based on our new costs,
and the formula.
To do that I need to:
1 Populate the formula field with a "REAL CF READABLE formula".
Where can I get info on how to structure these kinds of formula?
2 Build guidelines for updates. I see there are many pitfalls in
selecting, and updating data. I wonder if some patient folks out there could
share with this normally Friday only guy.
Thanks in advance for your patience and guidance.
Robert P. Reil
Managing Director,
Motorcyclecarbs.com, Inc.
4292 Country Garden Walk NW
Kennesaw, Ga. 30152
Office 770-974-8851
Fax 770-974-8852
www.motorcyclecarbs.com <http://www.motorcyclecarbs.com/>
