OK, I have a bit of a situation that is now going to require me to learn a new language :-(
For some time now we have been checking online prices of our competitors automatically over the Internet to ensure our prices are cheaper. All of our stock control, order processing, etc... Is handled by a CF powered intranet and a MySQL backend. We have reached the stage now where the price check is taking over 2 hours (just) an CF can no longer handle it, it just isn't designed to run a 2 hour template request! Can someone recommend A) The best language to use for this B) A good book to learn from C) A good IDE to code it in? The language should be able to cope with... 1) http requests (similar to a cfhttp) to retrieve the remote web page. 2) regular expressions to search the html for the prices. 3) ODBC to link to the MySQL data source. 4) simple text file management to write lines to a tab delimited text file. 5) http posts to post the finished text file to it's destination (must support https). 6) should cope with running a process for a couple of hours without memory leaks killing the server it's running on. Your suggestions please? -- Jay (\ /) (O.o) (> <) This is Bunny. Copy Bunny into your signature to help him on his way to world domination. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:162796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
