Display Records until a Certain date
(December 11, 2005)
| User Level: | Intermediate |
|---|---|
| Product: | Dreamweaver MX, Dreamweaver MX 2004, Dreamweaver 8, UltraDev 1, UltraDev 4 |
| Database: | Access |
| Server Model: | ASP VBScript |
| Technologies: | SQL |
For the WHERE statement, use the below text, to show your records whilst the date column is greater or equal then the current day.
Change table to your table name and column to the column which contains your records date.
Using Access
WHERE (((table.column)>=Date()))
Using SQL server 2000
WHERE (((table.Column)>=getdate()))
If you are using Dreamweaver MX, you will need to change the Recordset to the Advanced view, and alter the WHERE statement to the text above
Carl Grint
" Since graduating from university, I have worked with Charities and the Public sector, with my longest time being 3 years with the NHS until returning to freelance in 2003.
I would like to think my diverse experience of working for both the Public and Private sector gives me a good all rounding which enables me to approach projects with a unique perspective and enables me to bring new thoughts and initiatives to my work.
I have always enjoyed passing on the lessons I have learned so other developers can bypass the 'working out' time I had to go through, and writing my first two articles for DMXzone has given me a chance to pass on what I think are some good ways to improve on the standard Authentication behaviours Macromedia supply with Dreamweaver."
