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
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
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.
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/
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/