Last 7 days 1

[PetersWeb]

I have a list which is added to every few days. The addition date is auto inserted into the database.

How can I list the new additions for the past 7 days? [sig]<p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=

http://www.petertoby.com.au>PetersWeb</a><br>My

site is under construction but getting better![/sig]

 

[SimonA]

What database are you using ?

If Oracle, you can do something like:

SELECT message
FROM message_table
WHERE addition_date >= (SYSDATE - 7);

Simon. [sig][/sig]

 

[PetersWeb]

Thanks Simon,

Sorry, I should have said that I'm using MS Access.

[sig]<p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=

http://www.petertoby.com.au>PetersWeb</a><br>My

site is under construction but getting better![/sig]

 

[giahan]

Peter,

How about this:

<cfquery name=&quot;getmyList&quot; datasource=&quot;mydb&quot;>
SELECT myList
FROM myTable
WHERE Date()-7<=addition_Date

</cfquery>

<cfoutput query=&quot;getmyList&quot;>
mylist #whatEverFieldYouWantToDisplay#
</cfoutput>

Hope this is what u r looking for
[sig]<p>GH<br>[/sig]

 

[PetersWeb]

Thanks giahan,

That did the trick!

You're a genius!!

Thanks to SimonA for your help too.

[sig]<p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=

http://www.petertoby.com.au>PetersWeb</a><br>My

site is under construction but getting better![/sig]