ASP - date formating MySql insert/update

[- - Vivian - - - - - -]

I am storing dates in a mySql database in the format yyyy-mm-dd.
Now, I have set up so that this field is insert by a form.
It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so
that the user
can enter format dd/mm/yyyy and it will automatically insert into the
database as yyyy-mm-dd?

I am using Dreamweaver MX 2004 and ASP.

Thanks for any helps to me ....
Vivian

[Ray at]

Hi Vivian,

sDate = Request.Form("year") & "-" & request.form("month") & "-" &
Request.form("day")
sSQL = "insert into yourTable (theDate) values ('" & theDate & "')"

You'd want to validate the data or only give people dropdown boxes from
which to select so that they have to pick a valid date. Also, I do not know
that ' is the right delimiter for dates in MySQL.

Ray at work
"- - Vivian - - - - - -" <vi*********@ligbr.com.br> wrote in message
news:ee**************@tk2msftngp13.phx.gbl...

I am storing dates in a mySql database in the format yyyy-mm-dd.
Now, I have set up so that this field is insert by a form.
It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so that the user
can enter format dd/mm/yyyy and it will automatically insert into the
database as yyyy-mm-dd?

I am using Dreamweaver MX 2004 and ASP.

Thanks for any helps to me ....
Vivian

[Foo Man Chew]

> It isn't very user friendly to have to type yyyy-mm-dd,

Don't allow free text date entry. Have them pick the month, day and year
from three different dropdowns. Much less validation required, and you can
format the input however you like.

[Kenny Ashton]

Vivian - listen to Foo - that was profound advice.
I nearly went insane trying different systems in Javascript/Asp,
wasted months on it - there is nothing quite as effective as the three
dropdowns Foo advocates. It works everytime, never get a wrongly
formatted date, a dream to validate
Kenny

Don't allow free text date entry. Have them pick the month, day and year
from three different dropdowns. Much less validation required, and you can
format the input however you like.

[- - Vivian - - - - - -]

Please send links about scripts javascript for
dropdown calendars...

Thanks

Vivian

Vivian - listen to Foo - that was profound advice.
I nearly went insane trying different systems in Javascript/Asp,
wasted months on it - there is nothing quite as effective as the three
dropdowns Foo advocates. It works everytime, never get a wrongly
formatted date, a dream to validate
Kenny

Don't allow free text date entry. Have them pick the month, day and year
from three different dropdowns. Much less validation required, and you canformat the input however you like.

[Foo Man Chew]

Some good links here
http://www.aspfaq.com/show.asp?id=2309

"- - Vivian - - - - - -" <vi*********@ligbr.com.br> wrote in message
news:eh**************@tk2msftngp13.phx.gbl...

Please send links about scripts javascript for
dropdown calendars...

Thanks

Vivian

Vivian - listen to Foo - that was profound advice.
I nearly went insane trying different systems in Javascript/Asp,
wasted months on it - there is nothing quite as effective as the three
dropdowns Foo advocates. It works everytime, never get a wrongly
formatted date, a dream to validate
Kenny

Don't allow free text date entry. Have them pick the month, day and yearfrom three different dropdowns. Much less validation required, and you canformat the input however you like.