Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with ADO SQL select
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Help with ADO SQL select
Miscellaneous
Thread ID:
00601024
Message ID:
00601024
Views:
66
Okay, I have now managed to create an ADO connection in my ASP and am hooked up to a table. I'm nuot sure of the syntax (VBScript and ADO/SQL) to select all records that have a date within the last 30 days:
oRecSet.Open "SELECT * FROM myTable WHERE dt > [confused here, need today's date minus 30 days?]", oConn, 1, 1
Any help is greatly appreciated. Thanks a lot!
jfh
Next
Reply
Map
View

Click here to load this message in the networking platform