Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 18 DEC 2007 11:48:30PM Martin Drenovac wrote:

What's new in 8.0.3 states "Added OLE_GET_WEBPAGE with source as an example of using Microsoft Xmlhttp object"..

Ok, where is it? I've looked in SYSPROG and EXAMPLES?

Thanks


At 19 DEC 2007 09:26AM Bob Carten wrote:

Source should be in SYSPROG

I meant to ship it; must've been stripped out by the build tools

See Below

Note: I tend to use MsXml2.ServerXmlHttp because it has the ability to send logon credentials.

pre.code {

 background-color: #E5E5E5;
 border: 1px solid #000000;
 width: 640px;
 padding: 5px;
 font-family: courier, verdana, arial, serif;
 margin: 0px 10px auto;

}

function Ole_GetWebpage(url, method, payload)

/*
** Wrapper around XMLHttp object
** Used by URLBFS
** Assumes Win2k or better, as MsXml2.ServerXmlHttp is part of MSXML3
**
** 07-07-07 rjc   Created
*/

if assigned(url) else url='
if assigned(method) else method='
if assigned(payload) else payload='

equ sync$ to 0
equ async$ to 1

convert @lower.case to @upper.case in method
if method=POST' else method=GET'
oHttp=OleCreateInstance('MsXml2.ServerXmlhttp')
x=oHttp->Open(method, url, sync$)
x=oHttp->Send(payload)
html=oHttp->ResponseText

return html

At 19 DEC 2007 09:16PM Richard Bright wrote:

Uh,

Does this constitute #923 in bug tracker read?


At 20 DEC 2007 12:07AM Martin Drenovac wrote:

Boom Boom!! - I'll do that in future.

I've not had the exposure for subtlety until now - Thank you Richard…Read BUGS register before whining.


At 20 DEC 2007 12:16AM Warren Auyong wrote:

"The squeaky wheel gets the grease"

Merely reading the bug tracker wouldn't have gotten you the code :)


At 20 DEC 2007 04:21AM Martin Drenovac wrote:

Bob - thanks very much,

What's URLBFS?


At 20 DEC 2007 06:08AM Richard Bright wrote:

We are all (that is, those that where waiting for it with baited breath) grateful to get the code.

What I had meant, was that presumably Bob could mark the bug report off as having been read. But as usual it is foot in mouth - but Martin is forgiving of lesser cousins.


At 20 DEC 2007 11:54AM Bob Carten wrote:

thanks for that Richard.

URLBFS is a bfs which can read and write to a url.

Only read and write are supported.

It is a VERY simple implementation. Write will just POST the record to the website, the website must know how to deal with it.

In 8.03 system monitor try

run ATTACH_TABLE 'URL'

run read_row "http://www.revelation.com"


At 20 DEC 2007 01:37PM Bryan Shumsky wrote:

What I believe Bob _meant_ to say as an example was:

RUN ATTACH_TABLE "URL"

RUN READ_ROW "URL", "http://www.revelation.com"

(Note the specification of the 'table' URL, while the 'item id' is the actual website to read or 'write' to)

As an aside, in addition to implementing a URL BFS, we also (re-)implemented a DOS BFS. So for example:

RUN ATTACH_TABLE "DOS"

RUN READ_ROW "DOS","C:\TEST.TXT"

For the DOS BFS, you can use either the table name "DOS" or "DOSTXT". The DOS table reads/writes records to the filing system in a "raw" format, while the DOSTXT table reads/writes records after converting @FM to cr/lf (and vice versa). You can even "read" directory information by specifying a directory path (with or without file specs) as the "record" to read, as in:

RUN READ_ROW "DOS","C:\*.TXT"

- Bryan Shumsky

Revelation Software


At 20 DEC 2007 02:36PM dsigafoos wrote:

BFS BFS .. those other mv guys are really missing the boat

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/1c185235c163e4db852573b6001a69d2.txt
  • Last modified: 2024/01/04 20:57
  • by 127.0.0.1