Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

RE: RSS Headline Sucker

by cei (Monk)
on May 03, 2000 at 10:54 UTC ( #10052=note: print w/ replies, xml ) Need Help??


in reply to RSS Headline Sucker

Can you post the fields of the first table? I figured the second table from the insert statement, but I wanted to see how you set up your sources to pull from.

Thanks.


Comment on RE: RSS Headline Sucker
RE: RE: RSS Headline Sucker
by radixzer0 (Beadle) on May 10, 2000 at 21:13 UTC
    Sorry for taking so long to respond, didnt see your request till now.
    I was running this out of Access (ick), although the idea is the same on any database (e.g. mySQL):
    ExternalNewsSourceID -> autoNumber (internal unique id) Title -> text (name of the site) Link -> text (link to the site, not the source) Description -> text (description of the site) Source -> text (URL for the actual feed)

    I populated this list by hand by selecting sources from xmltree.com.
    Let me know if you need more detail. -r0

      Wow, your code is exactly what I need. Cannot get it to run on Access though. This is the content of my first table named ExternalNewsSources which has only one row at the moment. Columns: ExternalNewsSourceID Title Link Description Source With data: 1 SlashDot http://slashdot.org/ Headlines http://slashdot.org/slashdot.rdf Format of the first table is as suggested ExternalNewsSourceID -> autoNumber (internal unique id) Title -> text (name of the site) Link -> text (link to the site, not the source) Description -> text (description of the site) Source -> text (URL for the actual feed) My second table is named ExternalNews and has the following columns: SourceID -text PostDate -text Title -text Link -text Description -text I have a System DSN named TESTSERVER as in the example and I'm running your example code as published. I don't get any errors.... just no data in the tables. Do I have something simple wrong?
      Trying this again in HTML...Wow, your code is exactly what I need.  Cannot get it to run on Access though.
       
      This is the content of my first table named ExternalNewsSources
       
       
      ExternalNewsSourceID Title Link Description Source
      1 SlashDot http://slashdot.org/ Headlines http://slashdot.org/slashdot.rdf
       
      Format of the first table is as suggested
       
      ExternalNewsSourceID  ->  autoNumber (internal unique id)
      Title  ->  text  (name of the site)
      Link  ->  text  (link to the site, not the source)
      Description  ->  text  (description of the site)
      Source  ->  text  (URL for the actual feed)
       
      My second table is named ExternalNews and has the following columns:
       
      SourceID          -text
      PostDate          -text
      Title             -text
      Link              -text
      Description       -text
       
      I have a System DSN named TESTSERVER as in the example and I'm running your example code as published. 
       
      I don't get any errors.... just no data in the tables.  Do I have something simple wrong?
        It looks like some sites parse while others don't. I added more sources and I'm starting to get some information in the second table.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://10052]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (7)
As of 2015-07-04 16:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls