Les, Property#? As in in MLS Real Estate Number? If so, I did this stuff for 5+ years. We found the best way for speed and reference to break inmates into folder was to split the property number itself into folders.
thus 794622 becomes ./7/9/4/6/2/2/ and all the images for that properly are in that location. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com [email protected] www.trunkful.com On May 14, 2012, at 3:02 PM, Les Irvin wrote: > > 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:351141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
