SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Hi Chris,

    Thanks for your post. I will give it a try. Can you post the url's of the sites you are working on?



    ------------------
    John Muijen


    http//www.muijen.com

  2. #2
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Hi,

    If have an access database full of content. I would like to publish new content automatically and on a daily basis.

    All of this needs to be done using ColdFusion as the content is coming from this access database. (I do not want to use asp).

    Any suggestions?

    ------------------
    John Muijen


    http//www.muijen.com

  3. #3
    Serial Publisher silver trophy aspen's Avatar
    Join Date
    Aug 1999
    Location
    East Lansing, MI USA
    Posts
    12,939
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I do this exact same thing on a site I'm building, well actually its 4 sites for newspapers.

    To do it first you need to make sure you have a "date" field in access, except that you can't name it date, name it something else. Then when you add new content you type in the date you want it displayed in mm/dd/yy format.

    Then here is your CFQUERY code:

    <BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
    &lt;CFQUERY DATASOURCE = "DSN" name = "name"&gt;
    SELECT Text Title Dated
    FROM Main
    WHERE Dated = #CreateODBCDate(Now())#
    &lt;/CFQUERY&gt;
    [/code]

    What this will do is publish whatever content is dated for that day. At 12:01 AM the next day's stuff is automatically up.

    Hope that helps.

    Chris


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •