This soooo not going to happen though.... welcome to my world ;) It's just not. There is no way that would happen. If I had cooperation from that end the two databases would be talking already. The Oracle person *is* the problem I am trying to solve here.
>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233485 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
