Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    5

    Unanswered: Simple Date Problem Please Help!

    I can get the date to list all of the dates in the recordset, but when I use request.querystring("date") to specify all the recordsets with the date "2/26/2005" for example, the recordset comes up empty. Here is my sql statement:

    SELECT eventdate=convert(varchar, eventdate, 101), eventtext, eventtime, location, eventtitle, eventID, picture
    FROM dbo.calendar
    WHERE eventdate like 'thee' and status='live'
    ORDER BY eventdate ASC

    this will return everything when the browser url shows this: http://www.kapsi-western.org/calendar.asp?date= However, if we put a date in there, and made it like this http://www.kapsi-western.org/calenda...date=2/26/2005, then nothing comes up even though there is event with that date.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Does eventdate contain time portion? And what does 'thee' mean as a comparison value for a date?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •