Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty.
I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained "we don't have one, it just happens automatically". Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
