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)

    [download]

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

[reply]
[d/l]
      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?
[reply]
        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.
[reply]
      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?
[reply]

In Section Code Catacombs