Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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...


  Return to Index