I have a form named archieve and when i choose the date, i want to display the news belonging to the choosen date. How can i write the sql expression in Ultradev.

İf it is possible please also write the varibles for me, cause i am new to dreamveawer and tryin to learn asp.




Edited by - donangil on 09/03/2001 17:34:43

Try this:

varDate = Request("txtNewsDate"

then:

SELECT *
From ArchiveTable
WHERE NewsDate = varDate


Regards

Owen.




www.tdsf.co.uk/tdsfdemo

Edited by - oeastwick on 09/03/2001 18:06:49

Did not solve my problem. More help please!

Suat,

Your question isn't very specific, so the answer isn't either. Perhaps you could give us a little more to go on.

Regards

Owen.



www.tdsf.co.uk/tdsfdemo

Thanks for your interest OWEN.
I'm tryin to prepare a newspaper. The news are listed daily. I want to view the archieved news also by selecting day, month and year from the listboxes(3 listboxes, day, month, year espectively). For example when i select 03 06 2001, i want to view the news only belonging to that date.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>by selecting day, month and year from the listboxes(3 listboxes, day, month, year espectively). For example when i select 03 06 2001, i want to view the news only belonging to that date.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>I had to do the same thing recently, you just have to "concantenate" the values together... something like this:

request("month" & <b>"/"</b> & request("day" & <b>"/"</b> & request("year"

notice how the slashes were included in between the numbers... that should do what you need

Joel Martinez [ joel@udzone.com ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/