How do I filter records with the current date when using MS SQL

Thread View: adobe.golive.dynamic.content

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by RyanWallace Sat, 17 Jul 2004 16:49

#80

Author: RyanWallace
Date: Sat, 17 Jul 2004 16:49

6 lines
953 bytes

Howdie,
I previously used Access but have now moved to MS SQL to connect my Go Live 6 asp pages to.

I used to be able to use =date() to filter the records in the Content Source of those page, but MS SQL doesn't allow it. Is there an equivalent I can use that MS MSQL will respond to?

Thanks

Re: How do I filter records with the current date when using MS SQL

#90

Author: Jerry_Artman
Date: Mon, 19 Jul 2004 16:42

1 lines
724 bytes

Have you looked in the MS-SQL manual for the available functions?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads