Web fetching ???

You\'ll need a component called ASPTear or ASPHTTP ... but they need to be installed on the server on where you need to do it.

Do you have a example of a script like that ?  Wich saves the information in a database ?

ASPHttp:

Set HttpObj = Server.CreateObject(\"AspHTTP.Conn\")
HTTPObj.Url = \"http://www.eksperten.dk\"
HTTPObj.PostData = \"\"
HTTPObj.RequestMethod = \"GET\"
strResult = HTTPObj.GetURL

But how can you save the information in a database ?

Could you help me with a example script..

In the example you can for example use it to get the five latest jobs from this web site: http://www.eksperten.dk/job/stilling/

Or anything else... Can you please help me ?

Set HttpObj = Server.CreateObject(\"AspHTTP.Conn\")
HTTPObj.Url = \"http://www.eksperten.dk\"
HTTPObj.PostData = \"\"
HTTPObj.RequestMethod = \"GET\"
strResult = HTTPObj.GetURL
set HTTPObj = nothing

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\") & \";UID=admin;PWD=;\"
conn.execute(\"insert into tabel (fieldname) VALUES(\'\" & strResult & \"\')\")
set conn = nothing

Thanks a lot netsrac... 

But how can you actually set it to get for example the jobs at ?:

http://www.eksperten.dk/job/stilling/

I need that because I will for example need it to get news headlines. etc. from some pages...

You will have to find a pattern in the output from the page, and then sort into the output with left(), right(), mid(), split() and so on.

?????

I got this script in perl, wich gets the Oil price, how would you put that into the script you had, and how would the database look like?


#!/perl/bin/perl.exe

use LWP::Simple;

print \"content-type:text/html\\n\\n\";

unless ( $source=get(\"http://www.bloomberg.com/markets/future.html\") )
{
print \"Error: Bloomberg.com is down!\";
exit;
}

$source =~ m#.*<NOBR>(BRENT CRUDE FUTR)</NOBR>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)</SPAN>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)</SPAN>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)</SPAN>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)</SPAN>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)<BR>(.*)</SPAN>.*\\n.*<SPAN CLASS=\"mrktdata1\">(.*)</SPAN>.*#i;
print \"$1 $2 $3 $4 $5 $6 $7 $8\";

I dont know anything about perl...

But you can se how I get it,, wouldnt it be possible to use something like this to get something from a page ?

What do you want from the page ?

How would you for example grab these headlines using the ASP you talked about:

http://www.guardian.co.uk/Distribution/Artifact_Trail_Block/0,5184,179475-0-5,00.html


And put the headline, and the bit of text and the URL to each news into the database ?

From the http://www.bloomberg.com/markets/future.html

page..
I wanted the:
CRUDE OIL FUTR
May01 13:20 28.60 0.42 28.55 28.84
28.50 28.18

under ENERGY..

Set HttpObj = Server.CreateObject(\"AspHTTP.Conn\")
HTTPObj.Url = \"http://www.eksperten.dk\"
HTTPObj.PostData = \"\"
HTTPObj.RequestMethod = \"GET\"
strResult = HTTPObj.GetURL
set HTTPObj = nothing

pos = instr(strResult, \"CRUDE OIL FUTR\")
last2 = \"\"
do while last2 <> \"TR\"
tmp = tmp & mid(strresult, pos, 1)
pos = pos +1
last2 = mid(strresult, (pos-1), 1) & mid(strresult, pos, 1)
loop

Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\") & \";UID=admin;PWD=;\"
conn.execute(\"insert into tabel (fieldname) VALUES(\'\" & tmp & \"\')\")
set conn = nothing

I dont have actually the ASPHTTP component installed...  Could you set it up on your server, so I can se how it looks like ?

I dont have ASPHttp...

Ingen svar, som fortjener poeng..

Ingen svar, som fortjener poeng...!!!!!!!!!!!

Et mirakel, pludselig kunne han tale Dansk.

Svineri at du bare tager alle pointene igen...