New daily content in Cold Fusion

[john]

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

[john]

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

[aspen]

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