[thelist] ASP & Access - Using the same variable twice

Christian Anderson ckanderson at powersurfr.com
Mon Nov 26 23:28:51 CST 2001


Ok, I got the query to work the way I wanted it to now... finally... :)

Anway, it goes like this:

SQL=("SELECT * FROM t_datetable WHERE dDATE<=(DateAdd('H',13,Now())) ORDER
BY dDATE DESC")

So basically I have the info in my databse set with dates and times, and
this query will pull out only the stuff from todays date and previous dates.

Thanks for all the help!

Christian Anderson
Email: chris at photokyo.com
Cell/Keitai: digger at ezj.ido.ne.jp
URL: http://www.photokyo.com





More information about the thelist mailing list