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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233480 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
