Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

RE: RE: RSS Headline Sucker

by radixzer0 (Beadle)
on May 10, 2000 at 21:13 UTC ( #11014=note: print w/ replies, xml ) Need Help??


in reply to RE: RSS Headline Sucker
in thread RSS Headline Sucker

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


Comment on RE: RE: RSS Headline Sucker
Download Code
Replies are listed 'Best First'.
RE: RE: RE: RSS Headline Sucker
by Anonymous Monk on Oct 01, 2000 at 00:05 UTC
    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.
RE: RE: RE: RSS Headline Sucker
by Anonymous Monk on Sep 30, 2000 at 23:58 UTC
    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
Node Status?
node history
Node Type: note [id://11014]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (13)
As of 2015-07-30 11:59 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 (271 votes), past polls