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]]

Simon Gare wrote:

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?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Larry Bud]

Simon Gare wrote:

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("lstMi nutes")%>
Thanks Anyway

Regards
Simon
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:OR**************@TK2MSFTNGP04.phx.gbl...

Simon Gare wrote:

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?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

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

Problem Solved

Hidden Field

<%Request.Form("lstHours")%>:<%Request.Form("lstMi nutes")%>

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") %>'

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)