In my solution, I was going to use a DLL wrapper of the Microsoft Script Control, in which I would instantiate an instance of the default browser, set a variable to the DOM of the remote URL and then accessing the pertinent members of the DOM to get the data into respective RBase variables. I don't know any other way to do this.
----- Original Message ----- From: "J BLAUSTEIN" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, May 27, 2011 12:53 PM Subject: [RBASE-L] - Re: receiving HTML datastream into varchar/note :I am using a internet database that capture the data and then, using an : odbc driver to connect to a local Rbase Database : j : On 5/27/2011 9:52 AM, Mike Byerley wrote: : > Adrian, : > Questions in-line: : > : > ----- Original Message ----- : > From: "Adrian Hüssy"<[email protected]> : > To: "RBASE-L Mailing List"<[email protected]> : > Sent: Friday, May 27, 2011 4:09 AM : > Subject: [RBASE-L] - receiving HTML datastream into varchar/note : > : > : > 1. For an application I should read and interpret the result of an : > html-site. : > : > Q. Are you trying to read displayed data from the site as shown in your : > default (non RBASE) browser? : > : > 2. If I call a specific URL with parameter, the URL displays a string in : > html. This value is needed in a RBASE for Windows application. : > Q. Are you trying to capture the URL as shown in your default (non RBASE) : > browser into an RBASE variable or are you trying to pass the value of an : > RBASE variable to the Address bar of your default (non RBASE) browser? : > : > 3. I would be able to present the URL within an internet browser object in a : > form and ask the user to copy and paste to variable/database fields by : > himself, but I would prefer to run this process automatically in the : > background. : > Q. : > : > Has anybody an idea or a tool to pass or receive a html page to RBASE for : > Windows without user interaction? The URL has not to be displayed. : > A. I have experience with filling a remote site page with data from RBase : > and "IF" there are no cross-domain security issues, I should be able to use : > my RMScript.DLL to get displayed data from a remote web page "IF" the text : > objects of the remote page use the same value for the ID property of the TD : > (table_data) in every case. : > : > : > : > : > Example (copy till end of line for testing, the spaces are part of the : > parameters): : > http://tinygeocoder.com/create-api.php?q=3935 Old William Penn : > Highway,%20Murrysville,%20USA : > Returns geo-coordinates for RBase Technologies Inc.: 40.42754,-79.69132 : > : > In another case, other URL, I receive a formatted html table, where I : > should extract some needed values. : > : > Best Regards : > Adrian : > : > : > : > : : : -- : : *J. Blaustein* : : *J Blaustein Associates, Inc.* : : * 12 Herrick Drive* : : * Lawrence, NY 11559* : : *516-371-3445 FAX 516-345-8009* : :
