Hello, I am trying to generate a filelist and feed it to another application. I recursively loop over a directory tree and spit out a file that looks similar to this:
Dir:\\SERVERNAME\WORKINGDIR\currentversion\ ACCESS-signed.html,29561861:-498865152,1929 ACCESS-start.html,29374731:1826202624,2183 ACCESS.html,29580300:-1400836096,970 ApplSubApplWindow.java,29378958:-695524864,2222 CloseWindow.html,29554831:-1278774272,190 It goes like this: Filename,ModDate,Size(bytes) Everything is groovy, except that date... As much as I can figure out from one of the orginal developers the date is number of 100-nanoseconds since January 1st, 1601 - converted to a 64-bit number, the high 32 bits on the left and the lower on the right, concatenated with a ":". Now, I was also told that the calculation is as follows: -figure out seconds since 1601 until file moddate/time. (number like 12510619920) -get 100-nanoseconds by multiplying by 10000000 eg: intNano = 12510619920 * 10000000; For the upper 32 bits, divide intNano by 2^32 and convert to integer For the lower, get intNano mod 2^32 then: intHigh & ":" & intLow CF-RELATED... My problem is that CF chokes on that mod expression: Could not convert the value 1.251061992E17 to an integer because it cannot fit inside an integer. NOT SO CF-RELATED... My other problem is that even when I do the calculation in a stored procedure - it isn't the correct number (this I think is that I was just told incorrectly, mod must not be the path. Also, how would I get that Negative sign? Any help with the large integer thing much appreciated. If you *happen* do know the second part, I will buy you dinner when you're next in town. Thanks! Eric ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
