If your Oracle person is any good they can set up read only views you will call directly from your application so you're not having to parse a file.
-----Original Message----- From: Dana Tierney [mailto:[EMAIL PROTECTED] Sent: Saturday, April 28, 2007 4:43 PM To: CF-Community Subject: need a suggestion I have at long last been given permission to expend brain power on a certain situation rather than merely being the person that the problems happened to when the situation is not resolved. There are um... territorial issues however and I don't get to play with one of the databases (which is Oracle, if it matters). I need data from this database, call it A, to arrive at another database, call it B, which is SQL. I am trying to find out version numbers but since I wont have direct access to either, this seems a bit irrelevant. What I am thinking is this.... I have access to a front end for A, which diplays to me as an HTML file. If I view source on this file I actually see the data I need, not a variable. So if I could find some way to strip out the irrelevant and convert the relevant to say a CSV.... I'd be close to there. I'd also like to automate this process, but for a start let's say the task is extracting certain information from the source of a web page. Is this a regular expressions problem? Php? Perhaps Perl? I have better access to the SQL server. Perhaps tSQl to add the info in.... Any thoughts? Dana ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233483 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
