Marilyn Miers
|
| Posted: 03/22/2002, 10:44 PM |
|
Is there any way to compare dates?
I have two fields - startdate, enddate.
both are oracle dates.
How do I use any javascript/jsp scripting to ensure that the startdate is
earlier than the
enddate and have a validation error message appear?
I'm using JSP.
Yours,
Ler Ping
|
|
|
 |
RonB
|
| Posted: 03/23/2002, 3:45 AM |
|
"Marilyn Miers" <mimaclit69@hotmail.com> schreef in bericht
news:a7h889$tp$1@news.codecharge.com...
> Is there any way to compare dates?
>
> I have two fields - startdate, enddate.
> both are oracle dates.
> How do I use any javascript/jsp scripting to ensure that the startdate is
> earlier than the
> enddate and have a validation error message appear?
> I'm using JSP.
>
>
> Yours,
> Ler Ping
>
>
>
Build a constraint in oracle for that table that specifies startdate has to
be < then enddate
you have to ad to the column: alter table_name ad constraint m_startend_chk
check(startdate<enddate)
Let the database do the work
|
|
|
|
|
