Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

RE: RSS Headline Sucker

by cei (Monk)
on May 03, 2000 at 10:54 UTC ( [id://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.

Replies are listed 'Best First'.
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

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

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-03-29 07:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found