|
 |
asp_databases thread: extracted data imported into a database/chart
Message #1 by "Brian" <bakerb@c...> on Thu, 8 Jun 2000 3:46:37
|
|
What is the best solution to extract external data from other websites
(with their permission) using something like asptear, inserting these
values into a database and then displaying the data graphically using a
2-dimensional scattering chart, ie. chart points arranged by x and y with
the possibility of multiple y values for a an x value.
Thank you for your detailed answer.
Brian Baker
bakerb@c...
Message #2 by "Ken Schaefer" <ken.s@a...> on Thu, 8 Jun 2000 18:22:50 +1000
|
|
a) Use a component to get the data
b) Use ADO to insert the data into your database
c) Use a graph component (there are plenty around, just do a search) to
display the graph...
That's about as detailed as it's going to get.
Cheers
Ken
----- Original Message -----
From: "Brian"
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, June 08, 2000 3:46 AM
Subject: [asp_databases] extracted data imported into a database/chart
> What is the best solution to extract external data from other websites
> (with their permission) using something like asptear, inserting these
> values into a database and then displaying the data graphically using a
> 2-dimensional scattering chart, ie. chart points arranged by x and y with
> the possibility of multiple y values for a an x value.
>
> Thank you for your detailed answer.
> Brian Baker
>
Message #3 by charles.nadeau@d... on Thu, 8 Jun 2000 05:54:34 -0400
|
|
Brian,
If the site you are connecting to use ADO 2.5, you can ask then to
output
data in XML format. From there it is quite easy to move it back to your
database, especially if you use ADO 2.5 on your side too.
There is a good article about it in the November 1999 issue of "Visual
Basic
programmer Journal", p. 105.
Charles
> =AB If we could travel in time, then history would become an
> experimental science.=BB, Carl Sagan
>
> Charles-E. Nadeau Ph.D.
> charlesnadeau@h...
> World Information Network (WIN)
> Charles.NADEAU@d...
> Regional System Manager
> Asia pacific
> Consulate general of Canada Phones:
> 13th Floor Tower 1 MITNET: 343-3481
> Exchange Square MITNET Fax: 343-3441
> 8 Connaught Place Office: +852
> 2847-7481
> Hong Kong Fax: +852
> 2847-7441
>
-----Original Message-----
From: Brian []
Sent: 8 juin, 2000 11:47
To: ASP Databases
Subject: [asp_databases] extracted data imported into a database/chart
What is the best solution to extract external data from other websites
(with their permission) using something like asptear, inserting these
values into a database and then displaying the data graphically using a
2-dimensional scattering chart, ie. chart points arranged by x and y
with
the possibility of multiple y values for a an x value.
Thank you for your detailed answer.
Brian Baker
bakerb@c...
|
|
 |