| Subject: | how to search smalldatetime field with a querystring value? ASP/SQL |
|---|---|
| From: | "tradmusic.com" <sales@xxxxxxxxxxxxxxxxxxxx> |
| Date: | Thu, 31 Jul 2008 14:35:17 +0100 |
| Newsgroups: | macromedia.dreamweaver.appdev |
I'm passing the following date, via a querystring, to a page that has a recordset containing a smalldatetime field: page.asp?eventdatetime=2008-09-26 Problem is, the recordset is either producing no results, despite there being events in the table, on that date. If I change the querystring to any of the following: dd-mm-yyyy dd/mm/yyyy yyyy/mm/dd I get an error about data type mismatch. I know this is something silly...can anyone tell me what I'm doing wrong? Thank you. Regards Nath. |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: MySQL Error# : 2002 in Dreamweaver CS3, chunkeung |
|---|---|
| Next by Date: | Re: best solution for e-mail Newslettering?, tradmusic.com |
| Previous by Thread: | About testing server, Stephen Seng |
| Next by Thread: | Re: how to search smalldatetime field with a querystring value? ASP/SQL, Dooza |
| Indexes: | [Date] [Thread] [Top] [All Lists] |