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