Solved

Save RSS feed into Access DB

Posted on 2004-11-02
289 Views
Last Modified: 2012-08-13
i parse rss feeds from another websites in my asp page... all is well, but is there away to save the rss feed in my access database?
0
Question by:Doomish
    1 Comment
     
    LVL 5

    Accepted Solution

    by:
    Do you want to save the raw RSS data, or the parsed result?

    Saving the raw data is easy, assuming an access database with one table RSSfeeds with an autonumber id field and a text field called rssdata.

    <%@ LANGUAGE = VBScript%>
    <%
    Option Explicit

    ' ADO
    Dim objConn, objComm, objRS, strSQL, strConnectionString, strRSSData

    strRSSData = loadrssfeed("http://www.somesite.com/feed.rss")

    strConnectionString = "driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../path/to/mdb") & ";"
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open strConnectionString
    Set objComm = Server.CreateObject("ADODB.Command")
    objComm.ActiveConnection = objConn
    Set objRS = Server.CreateObject("ADODB.Recordset")

    strSQL = "SELECT id, rssdata FROM rssfeeds WHERE id=-1"
    objComm.CommandText = strSQL
    objRS.Open objComm,,0,3
    objRS.AddNew
    objRS("rssdata") = strRSSData
    objRS.Update
    objRS.Close

    Set objRS = Nothing
    Set objComm = Nothing
    Set objConn = Nothing
    %>

    If you are wanting to store the parsed results, it's the same thing really, but for each article in the feed you'd do an addNew and set objRS("title") = strArticleTitle etc before the update.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now