Forums

This topic is locked

Sql help

Posted 03 Sep 2001 17:32:19
1
has voted
03 Sep 2001 17:32:19 Suat donangil posted:
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

Replies

Replied 03 Sep 2001 18:06:16
03 Sep 2001 18:06:16 Owen Eastwick replied:
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
Replied 03 Sep 2001 20:42:23
03 Sep 2001 20:42:23 Suat donangil replied:
Did not solve my problem. More help please!

Replied 03 Sep 2001 22:10:46
03 Sep 2001 22:10:46 Owen Eastwick replied:
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
Replied 04 Sep 2001 00:27:28
04 Sep 2001 00:27:28 Suat donangil replied:
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.



Replied 04 Sep 2001 02:20:17
04 Sep 2001 02:20:17 Joel Martinez replied:
<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 [ ]
----------
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/

Reply to this topic