Retrieving the Server Date

Hello,

I just moved my site to DiscountASP.net, and a couple of pages are not working. These are Calendar pages that draw information from an MS Access Database, and then are flitered by catagory, and limited to the next event by getting the Server Date, and listing the next event.

Here is the SQL statement:

SELECT *
FROM tbl_Calendar
WHERE DateValue(CalDate) >= Date() AND Type = 'Ride'
ORDER BY CalDate

It selects all from the Table Calendar, then selects the event based on the date being greater or equal to the server date, and then if the event type is a ride (this is for the Next Ride Page of a motorcycle club), the database is ordered by the calendar date.

As I said, this SQL worked perfectly on the old host, but I am getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/pages/nextride.asp, line 17

I am guessing that I am not getting Server Date, and therefore not getting a record returned.

Any ideas? Any Help?

Thanks!!

 

Never Mind! /emoticons/burger.gif

After doing some more digging, I discovered that an old version of the Database was on the site, and it stillhad the field name as Dat not CalDate. Works Great now! /emoticons/scool.gif