Retrieving Dates in drop-down Menus

Dev Articles Community Forums Sponsor:

August 26th, 2003, 01:35 AM

sumicooldude

Contributing User

Join Date: Feb 2003

Posts: 48

Time spent in forums: < 1 sec
Reputation Power: 6

Send a message via Yahoo to sumicooldude

Retrieving Dates in drop-down Menus

Dear All,

i have a web page to insert dates, and i use the drop-down menu to allow users to select the date ie (the day, the month & the year in 3 diff drop down menus respectively) & then when he presses add button, i collect the data & store it in one variable in dd-mmm-yyyy format & insert it into 1 field of my dbase (say, idate), this is working fine.

The real problem is when i want to diplay the same date in an update page it can only be displayed in a textbox & that too in a mm/dd/yyyy format, is there ne way of retrieving the same date in three diff dropdown menus (ie day, month & year) exactly the same format i asked the user to input.

please help

regards
Sumeet

__________________
the coolest one

August 26th, 2003, 09:37 PM

sumicooldude

Contributing User

Join Date: Feb 2003

Posts: 48

Time spent in forums: < 1 sec
Reputation Power: 6

Please Reply

Guys no reply from nebody, am eagerly waiting for ur valuable suggetions

August 27th, 2003, 02:55 AM

EiSa

Contributing User

Join Date: Sep 2002

Location: Norway

Posts: 184

Time spent in forums: 1 h 22 m 24 sec
Reputation Power: 7

Something like this perhaps:

PHP Code:


		
			
<%

   myString = "24-Dec-2003"

   myArray = Split(myString, "-")

%>

   <form name="form1">

   <select name="select1">

   <option value="<%=myArray(0)%>"><%=myArray(0)%></option>

   </select>

      <select name="select2">

   <option value="<%=myArray(1)%>"><%=myArray(1)%></option>

   </select>

      <select name="select3">

   <option value="<%=myArray(2)%>"><%=myArray(2)%></option>

   </select>

   </form>

August 27th, 2003, 07:32 AM

stumpy

May contain nuts.

Dev Articles Regular (2000 - 2499 posts)

Join Date: Aug 2002

Location: Sydney, AU

Posts: 2,058

Time spent in forums: 5 h 8 m 57 sec
Reputation Power: 9

On the update page, you need to generate the drop down using a script. That way you can matched your stored value with one from the drop down.

e.g. something like this for your Day selector

Code:

for idx = 1 to 30
  response.write("<option value=""" & idx & """")
  if varStoredDate = idx then
    response.write(" selected")
  end if
  response.write(">" & idx & "</option>")
next

August 27th, 2003, 08:19 PM

aspnewbie

Contributing User

Join Date: Apr 2002

Location: The Great White North

Posts: 361

Time spent in forums: 58 m 50 sec
Reputation Power: 7

I have a function called getdate that I use for this purpose.

So on my edit page it reads:

frommonth = month(oRS("Date"))
fromday = day(oRS("Date"))
fromyear = year(oRS("Date"))

Code:


<Select name="frommonth"><%=getdate("mm",frommonth)%>
</select>&nbsp;&nbsp;
<Select name="fromday"><%=getdate("dd",fromday)%>
</select>&nbsp;&nbsp;
<Select name="fromyear"><%=getdate("yyyy",fromyear)%>
</select>

then I retrieve the info as follows:

smonth = request.form("frommonth")
syear = request.form("fromyear")
sday = request.form("fromday")
sdate = smonth & "/" & sday & "/" & syear

and update from there

Let me know if you need help writing the function.

August 28th, 2003, 01:01 AM

sumicooldude

Contributing User

Join Date: Feb 2003

Posts: 48

Time spent in forums: < 1 sec
Reputation Power: 6

thnx a bucks

Dear All,

well i must say that u guys are really really good, that did helped a lot & the last solution was the perfect 1 for my problem.

thnx once again to all for this help

regards
Sumeet

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: