OK. this is my first post on this forum. I recentl;y checked active server pages out of the library.

My question is.

I have this website for my band, and with tis site i made an admin panel for it.

This is the sql string i have for hte database.

set showsSQL = "SELECT TOP 4 * FROM events WHERE full_date>=" & Date & "ORDER BY full_date;"


the "full_date" column from the database is made up of 3 variables. the day field, the month field, and the year field submited by the user,.

It seeems like it doesnt pull up any records though. I checked it with the "recordcount" thingger, and nothing showed up. is there something wrong with the sql statement?

thanks for any help.
-Naaman

www.dinkumrocks.com