Searching for data isn't terribly hard with Dreamweaver. But I have had the biggest problem trying to create 2 dropdown lists of dates to search for data.

Basically, I am trying to be able to search between 2 dates for specific data posted from the start of one dropdown date to the next dropdown date.

Has anyone done this before?

Marc

Are you familiar with using the Between SQL command in the advanced recordset window? this should work.

Let me know if you want me to give you some example code.

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Are you familiar with using the Between SQL command in the advanced recordset window? this should work.

Let me know if you want me to give you some example code.

Regards

Vince Baker
&lt;strong&gt;DMX Zone Manager&lt;/strong&gt;

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Yes, I am familiar with the advanced part. I've worked it several times before, and I was sure I would have to for this project too.

I would love to see some example code! Thanks!

Currently I am trying to search our database by using a textbox (username), and 2 date dropdown boxes (date1, date2). Searching for records pertaining to a username is easy, but filtering it by dates is not.

Marc


Edited by - netfrugal on 12 Dec 2005 22:52:31