Time Field Help

[Simon Gare]

Hi all,

I have a time field that starts at 00:00 through to 23:59 problem is the
list is too long. I would like to have 2 dropdown fields HOURS & MINUTES
that join together when the form is submitted and enters the time into the
SQL db.

Any help would be appreciated.

Regards
Simon

 

[Bob Barrows [MVP]]

Hi all,

I have a time field that starts at 00:00 through to 23:59 problem is
the list is too long. I would like to have 2 dropdown fields HOURS &
MINUTES that join together when the form is submitted and enters the
time into the SQL db.

Any help would be appreciated.

What is the name datatype of the column?

 

[Larry Bud]

Hi all,

I have a time field that starts at 00:00 through to 23:59 problem is the
list is too long. I would like to have 2 dropdown fields HOURS & MINUTES
that join together when the form is submitted and enters the time into the
SQL db.

Any help would be appreciated.

Why not just let the user type in the hours and minutes?

 

[Simon Gare]

Problem Solved

Hidden Field

<%Request.Form("lstHours")%>:<%Request.Form("lstMinutes")%>


Thanks Anyway

Regards
Simon

 

[Evertjan.]

Simon Gare wrote on 03 jun 2006 in microsoft.public.inetserver.asp.general:

Problem Solved

Hidden Field

<%Request.Form("lstHours")%>:<%Request.Form("lstMinutes")%>

You could not have tested this as working,
because you missed the =.

Try:

value =
'<% = Request.Form("lstHours") %>:<% = Request.Form("lstMinutes") %>'

or [I would prefer that]:

value =
'<% = Request.Form("lstHours") & ":" & Request.Form("lstMinutes") %>'