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

Article View: adobe.golive.dynamic.content

Article #80

Back to adobe.golive.dynamic.content Previous Next

#80

From: 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

Technical Details

Message-ID: <3bb5141b.-1@webx.la2eafNXanI>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!npeer.de.kpn-eurorings.net!newsfeed.arcor.de!newsfeed01.sul.t-online.de!t-online.de!webx

Show Full Headers

Complete Article Headers

X-Google-Thread: 11ffd2,2cb88151380180e8,start
X-Google-Attributes: gid11ffd2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: RyanWallace@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!npeer.de.kpn-eurorings.net!newsfeed.arcor.de!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.golive.dynamic.content
Subject: How do I filter records with the current date when using MS SQL
Message-ID: <3bb5141b.-1@webx.la2eafNXanI>
Date: Sat, 17 Jul 2004 09:49:35 -0700
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit