Wrox Home  
Search P2P Archive for: Go
Shopping CartView Cart  |  My Account  |  Support
Home Browse Titles

P2P Archives
 

Archive Index
Back to Active P2P Forum

 


Wrox Chapters on Demand - Download the chapters you need and take them on the go!
Wrox First - Instant Access online to new Wrox books

New Titles for ASP.NET

Cover image for product 0470190647
DotNetNuke Websites Problem Design Solution
Cover image for product 0470391847
Jumping from ASP to ASP.NET
Attention User Groups: Post your next INETA event here
  Return to Index  

asp_web_howto thread: Re: Date validation

Message #1 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 03:40:53 -0700 (PDT)
I have two problems

1) I have to check whether date entered by the user in
the text box is valid date (dd/mm/yyyy) format 

2) if yes insert into SQLServer


when ever I enter DATE in the text box LIKE
(20/02/2002) i.e dd/mm/yyyy format, it saves into the
datbase like 01/01/1900
wot i am doing wrong here. 
so I need to validate DATE first whether it is in
dd/mm/yyyy format and then insert into the datbase.

please help me.. 

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #2 by Keith Bamberger <keith@p...> on 19 Sep 2002 13:11:58 +0200
Well SQL Server allows a few date formats so that shouldnt really be the 
issue. Have you tried creating an insert with query analyzer running the 
exact query you are trying to run? you should find that it works perfectly.


I would guess that your date isnt getting through to the insert!? take a 
look!

On 9/19/2002 12:40 PM, raj singh <skylimit1_2001@y...> wrote:
>I have two problems
>
>1) I have to check whether date entered by the user in
>the text box is valid date (dd/mm/yyyy) format
>
>2) if yes insert into SQLServer
>
>
>when ever I enter DATE in the text box LIKE
>(20/02/2002) i.e dd/mm/yyyy format, it saves into the
>datbase like 01/01/1900
>wot i am doing wrong here.
>so I need to validate DATE first whether it is in
>dd/mm/yyyy format and then insert into the datbase.
>
>please help me..
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #3 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 04:37:27 -0700 (PDT)
Hi Keith
This how my insert query is fired

Insert into Time_Detail (time_header, type,
date_enter,job, hours, rate, cost, pono, comments)
Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
'11', '11')-->inserts this date in the database
01/01/1900


and if I cover the date '20/02/2002' it comes up with
error -->THE CONERSION OF CHAR DATE TYPE TO DATETIME
DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME VALUE

AND if i cover date with "20/02/2002" it comes up with
error-->THE NAME '20/02/2002' IS NOT PERMITTED IN THIS
CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED HERE.
COLUMN NAMES ARE NOT PERMITTED.

I have tried in this in query analyzer also. same
result.My date field in the datbase is datetime.

One more thing , I have see when some enter date in
the textbox it should be dd/mm/yyyy format only in
javascript.

--- Keith Bamberger <keith@p...> wrote:
> Well SQL Server allows a few date formats so that
> shouldnt really be the issue. Have you tried
> creating an insert with query analyzer running the
> exact query you are trying to run? you should find
> that it works perfectly. 
> 
> I would guess that your date isnt getting through to
> the insert!? take a look!
> 
> On 9/19/2002 12:40 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >I have two problems
> >
> >1) I have to check whether date entered by the user
> in
> >the text box is valid date (dd/mm/yyyy) format 
> >
> >2) if yes insert into SQLServer
> >
> >
> >when ever I enter DATE in the text box LIKE
> >(20/02/2002) i.e dd/mm/yyyy format, it saves into
> the
> >datbase like 01/01/1900
> >wot i am doing wrong here. 
> >so I need to validate DATE first whether it is in
> >dd/mm/yyyy format and then insert into the datbase.
> >
> >please help me.. 
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> >
> >
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #4 by Keith Bamberger <keith@p...> on 19 Sep 2002 13:43:26 +0200
Hello there :)

You definately need the single quotes around your date 'DATE TIME' try 
this.

insert into Time_Detail (time_header, type,
date_enter,job, hours, rate, cost, pono, comments)
Values (100, 'Time', '20/02/2002, 00:00' 100, 11, 100, 11,
'11', '11')-->inserts this date in the database
01/01/1900


On 9/19/2002 1:37 PM, raj singh <skylimit1_2001@y...> wrote:
>Hi Keith
>This how my insert query is fired
>
>Insert into Time_Detail (time_header, type,
>date_enter,job, hours, rate, cost, pono, comments)
>Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>'11', '11')-->inserts this date in the database
>01/01/1900
>
>
>and if I cover the date '20/02/2002' it comes up with
>error -->THE CONERSION OF CHAR DATE TYPE TO DATETIME
>DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME VALUE
>
>AND if i cover date with "20/02/2002" it comes up with
>error-->THE NAME '20/02/2002' IS NOT PERMITTED IN THIS
>CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED HERE.
>COLUMN NAMES ARE NOT PERMITTED.
>
>I have tried in this in query analyzer also. same
>result.My date field in the datbase is datetime.
>
>One more thing , I have see when some enter date in
>the textbox it should be dd/mm/yyyy format only in
>javascript.
>
>--- Keith Bamberger <keith@p...> wrote:
>> Well SQL Server allows a few date formats so that
>> shouldnt really be the issue. Have you tried
>> creating an insert with query analyzer running the
>> exact query you are trying to run? you should find
>> that it works perfectly.
>>
>> I would guess that your date isnt getting through to
>> the insert!? take a look!
>>
>> On 9/19/2002 12:40 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >I have two problems
>> >
>> >1) I have to check whether date entered by the user
>> in
>> >the text box is valid date (dd/mm/yyyy) format
>> >
>> >2) if yes insert into SQLServer
>> >
>> >
>> >when ever I enter DATE in the text box LIKE
>> >(20/02/2002) i.e dd/mm/yyyy format, it saves into
>> the
>> >datbase like 01/01/1900
>> >wot i am doing wrong here.
>> >so I need to validate DATE first whether it is in
>> >dd/mm/yyyy format and then insert into the datbase.
>> >
>> >please help me..
>> >
>> >__________________________________________________
>> >Do you Yahoo!?
>> >New DSL Internet Access from SBC & Yahoo!
>> >http://sbc.yahoo.com
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >r-20
>> >
>> >
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #5 by Keith Bamberger <keith@p...> on 19 Sep 2002 13:46:12 +0200
There is something else, the American date goes like this mm/dd/yyyy !?!? 
try swapping your month and day around to get it to work also.

If this is the problem then you have the wrong sort order for your SQL 
Server. for where you are. This however shouldnt make much difference with 
the date but maybe I am remembering wrong???

On 9/19/2002 1:37 PM, raj singh <skylimit1_2001@y...> wrote:
>Hi Keith
>This how my insert query is fired
>
>Insert into Time_Detail (time_header, type,
>date_enter,job, hours, rate, cost, pono, comments)
>Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>'11', '11')-->inserts this date in the database
>01/01/1900
>
>
>and if I cover the date '20/02/2002' it comes up with
>error -->THE CONERSION OF CHAR DATE TYPE TO DATETIME
>DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME VALUE
>
>AND if i cover date with "20/02/2002" it comes up with
>error-->THE NAME '20/02/2002' IS NOT PERMITTED IN THIS
>CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED HERE.
>COLUMN NAMES ARE NOT PERMITTED.
>
>I have tried in this in query analyzer also. same
>result.My date field in the datbase is datetime.
>
>One more thing , I have see when some enter date in
>the textbox it should be dd/mm/yyyy format only in
>javascript.
>
>--- Keith Bamberger <keith@p...> wrote:
>> Well SQL Server allows a few date formats so that
>> shouldnt really be the issue. Have you tried
>> creating an insert with query analyzer running the
>> exact query you are trying to run? you should find
>> that it works perfectly.
>>
>> I would guess that your date isnt getting through to
>> the insert!? take a look!
>>
>> On 9/19/2002 12:40 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >I have two problems
>> >
>> >1) I have to check whether date entered by the user
>> in
>> >the text box is valid date (dd/mm/yyyy) format
>> >
>> >2) if yes insert into SQLServer
>> >
>> >
>> >when ever I enter DATE in the text box LIKE
>> >(20/02/2002) i.e dd/mm/yyyy format, it saves into
>> the
>> >datbase like 01/01/1900
>> >wot i am doing wrong here.
>> >so I need to validate DATE first whether it is in
>> >dd/mm/yyyy format and then insert into the datbase.
>> >
>> >please help me..
>> >
>> >__________________________________________________
>> >Do you Yahoo!?
>> >New DSL Internet Access from SBC & Yahoo!
>> >http://sbc.yahoo.com
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >r-20
>> >
>> >
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
.com.
>
>
Message #6 by Keith Bamberger <keith@p...> on 19 Sep 2002 13:48:27 +0200
eeeek I just noticed something in the SQL I sent you, I forgot to remove 
the "," from the date time. It shouldnt be in there! '01/01/2002 00:00' 
like that!

On 9/19/2002 1:43 PM, Keith Bamberger <keith@p...> wrote:
>Hello there :)
>
>You definately need the single quotes around your date 'DATE TIME'
>try this.
>
>insert into Time_Detail (time_header, type,
>date_enter,job, hours, rate, cost, pono, comments)
>Values (100, 'Time', '20/02/2002, 00:00' 100, 11, 100, 11,
>'11', '11')-->inserts this date in the database
>01/01/1900
>
>
>On 9/19/2002 1:37 PM, raj singh <skylimit1_2001@y...> wrote:
>>Hi Keith
>>This how my insert query is fired
>>
>>Insert into Time_Detail (time_header, type,
>>date_enter,job, hours, rate, cost, pono, comments)
>>Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>>'11', '11')-->inserts this date in the database
>>01/01/1900
>>
>>
>>and if I cover the date '20/02/2002' it comes up with
>>error -->THE CONERSION OF CHAR DATE TYPE TO DATETIME
>>DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME VALUE
>>
>>AND if i cover date with "20/02/2002" it comes up with
>>error-->THE NAME '20/02/2002' IS NOT PERMITTED IN THIS
>>CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED HERE.
>>COLUMN NAMES ARE NOT PERMITTED.
>>
>>I have tried in this in query analyzer also. same
>>result.My date field in the datbase is datetime.
>>
>>One more thing , I have see when some enter date in
>>the textbox it should be dd/mm/yyyy format only in
>>javascript.
>>
>>--- Keith Bamberger <keith@p...> wrote:
>>> Well SQL Server allows a few date formats so that
>>> shouldnt really be the issue. Have you tried
>>> creating an insert with query analyzer running the
>>> exact query you are trying to run? you should find
>>> that it works perfectly.
>>>
>>> I would guess that your date isnt getting through to
>>> the insert!? take a look!
>>>
>>> On 9/19/2002 12:40 PM, raj singh
>>> <skylimit1_2001@y...> wrote:
>>> >I have two problems
>>> >
>>> >1) I have to check whether date entered by the user
>>> in
>>> >the text box is valid date (dd/mm/yyyy) format
>>> >
>>> >2) if yes insert into SQLServer
>>> >
>>> >
>>> >when ever I enter DATE in the text box LIKE
>>> >(20/02/2002) i.e dd/mm/yyyy format, it saves into
>>> the
>>> >datbase like 01/01/1900
>>> >wot i am doing wrong here.
>>> >so I need to validate DATE first whether it is in
>>> >dd/mm/yyyy format and then insert into the datbase.
>>> >
>>> >please help me..
>>> >
>>> >__________________________________________________
>>> >Do you Yahoo!?
>>> >New DSL Internet Access from SBC & Yahoo!
>>> >http://sbc.yahoo.com
>>> >
>>> >
>>> >---
>>> >
>>> >Improve your web design skills with these new books
>>> from Glasshaus.
>>> >
>>> >Usable Web Menus
>>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>>> >r-20
>>> >Constructing Accessible Web Sites
>>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>>> >r-20
>>> >Practical JavaScript for the Usable Web
>>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogram
me
>>> >r-20
>>> >
>>> >
>>>
>>>
>>>
>>> ---
>>>
>>> Improve your web design skills with these new books
>>> from Glasshaus.
>>>
>>> Usable Web Menus
>>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>>> r-20
>>> Constructing Accessible Web Sites
>>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>>> r-20
>>> Practical JavaScript for the Usable Web
>>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>>> r-20
>>
>>
>>__________________________________________________
>>Do you Yahoo!?
>>New DSL Internet Access from SBC & Yahoo!
>>http://sbc.yahoo.com
>>
>>
>>---
>>
>>Improve your web design skills with these new books from Glasshaus.
>>
>>Usable Web Menus
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>>r-20
>>Constructing Accessible Web Sites
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>>r-20
>>Practical JavaScript for the Usable Web
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>>r-20
>>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>>
>>
>
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #7 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 04:50:19 -0700 (PDT)
comes up with error 
incorrect syntax near '100'

--- Keith Bamberger <keith@p...> wrote:
> Hello there :)
> 
> You definately need the single quotes around your
> date 'DATE TIME' try this.
> 
> insert into Time_Detail (time_header, type,
> date_enter,job, hours, rate, cost, pono, comments)
> Values (100, 'Time', '20/02/2002, 00:00' 100, 11,
> 100, 11,
> '11', '11')-->inserts this date in the database
> 01/01/1900
> 
> 
> On 9/19/2002 1:37 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >Hi Keith
> >This how my insert query is fired
> >
> >Insert into Time_Detail (time_header, type,
> >date_enter,job, hours, rate, cost, pono, comments)
> >Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
> >'11', '11')-->inserts this date in the database
> >01/01/1900
> >
> >
> >and if I cover the date '20/02/2002' it comes up
> with
> >error -->THE CONERSION OF CHAR DATE TYPE TO
> DATETIME
> >DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
> VALUE
> >
> >AND if i cover date with "20/02/2002" it comes up
> with
> >error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
> THIS
> >CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
> HERE.
> >COLUMN NAMES ARE NOT PERMITTED.
> >
> >I have tried in this in query analyzer also. same
> >result.My date field in the datbase is datetime.
> >
> >One more thing , I have see when some enter date in
> >the textbox it should be dd/mm/yyyy format only in
> >javascript.
> >
> >--- Keith Bamberger <keith@p...> wrote:
> >> Well SQL Server allows a few date formats so that
> >> shouldnt really be the issue. Have you tried
> >> creating an insert with query analyzer running
> the
> >> exact query you are trying to run? you should
> find
> >> that it works perfectly. 
> >> 
> >> I would guess that your date isnt getting through
> to
> >> the insert!? take a look!
> >> 
> >> On 9/19/2002 12:40 PM, raj singh
> >> <skylimit1_2001@y...> wrote:
> >> >I have two problems
> >> >
> >> >1) I have to check whether date entered by the
> user
> >> in
> >> >the text box is valid date (dd/mm/yyyy) format 
> >> >
> >> >2) if yes insert into SQLServer
> >> >
> >> >
> >> >when ever I enter DATE in the text box LIKE
> >> >(20/02/2002) i.e dd/mm/yyyy format, it saves
> into
> >> the
> >> >datbase like 01/01/1900
> >> >wot i am doing wrong here. 
> >> >so I need to validate DATE first whether it is
> in
> >> >dd/mm/yyyy format and then insert into the
> datbase.
> >> >
> >> >please help me.. 
> >> >
> >>
> >__________________________________________________
> >> >Do you Yahoo!?
> >> >New DSL Internet Access from SBC & Yahoo!
> >> >http://sbc.yahoo.com
> >> >
> >> >
> >> >---
> >> >
> >> >Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> >
> >> >Usable Web Menus
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> >r-20
> >> >Constructing Accessible Web Sites
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> >r-20
> >> >Practical JavaScript for the Usable Web
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> >r-20
> >> >
> >> >
> >> 
> >> 
> >> 
> >> ---
> >> 
> >> Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> 
> >> Usable Web Menus
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> r-20
> >> Constructing Accessible Web Sites
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> r-20
> >> Practical JavaScript for the Usable Web
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> r-20
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> >
> >
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #8 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 04:57:02 -0700 (PDT)
Well This is proper syntax after all modificaion
INSERT INTO Time_Detail
    (time_header, type, date_enter, job, hours, rate,
cost, pono, comments)
VALUES (100, 'Time', '20/02/2002 00:00', 100, 11, 100,
11, '11', '11')

THE CONERSION OF CHAR DATE TYPE TO
DATETIME DATA TYPE RESULTED IN AN OUT-OF-RANGE
DATETIME
VALUE







--- Keith Bamberger <keith@p...> wrote:
> eeeek I just noticed something in the SQL I sent
> you, I forgot to remove the "," from the date time.
> It shouldnt be in there! '01/01/2002 00:00' like
> that!
> 
> On 9/19/2002 1:43 PM, Keith Bamberger
> <keith@p...> wrote:
> >Hello there :)
> >
> >You definately need the single quotes around your
> date 'DATE TIME' 
> >try this.
> >
> >insert into Time_Detail (time_header, type,
> >date_enter,job, hours, rate, cost, pono, comments)
> >Values (100, 'Time', '20/02/2002, 00:00' 100, 11,
> 100, 11,
> >'11', '11')-->inserts this date in the database
> >01/01/1900
> >
> >
> >On 9/19/2002 1:37 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >>Hi Keith
> >>This how my insert query is fired
> >>
> >>Insert into Time_Detail (time_header, type,
> >>date_enter,job, hours, rate, cost, pono, comments)
> >>Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
> >>'11', '11')-->inserts this date in the database
> >>01/01/1900
> >>
> >>
> >>and if I cover the date '20/02/2002' it comes up
> with
> >>error -->THE CONERSION OF CHAR DATE TYPE TO
> DATETIME
> >>DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
> VALUE
> >>
> >>AND if i cover date with "20/02/2002" it comes up
> with
> >>error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
> THIS
> >>CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
> HERE.
> >>COLUMN NAMES ARE NOT PERMITTED.
> >>
> >>I have tried in this in query analyzer also. same
> >>result.My date field in the datbase is datetime.
> >>
> >>One more thing , I have see when some enter date
> in
> >>the textbox it should be dd/mm/yyyy format only in
> >>javascript.
> >>
> >>--- Keith Bamberger <keith@p...> wrote:
> >>> Well SQL Server allows a few date formats so
> that
> >>> shouldnt really be the issue. Have you tried
> >>> creating an insert with query analyzer running
> the
> >>> exact query you are trying to run? you should
> find
> >>> that it works perfectly. 
> >>> 
> >>> I would guess that your date isnt getting
> through to
> >>> the insert!? take a look!
> >>> 
> >>> On 9/19/2002 12:40 PM, raj singh
> >>> <skylimit1_2001@y...> wrote:
> >>> >I have two problems
> >>> >
> >>> >1) I have to check whether date entered by the
> user
> >>> in
> >>> >the text box is valid date (dd/mm/yyyy) format 
> >>> >
> >>> >2) if yes insert into SQLServer
> >>> >
> >>> >
> >>> >when ever I enter DATE in the text box LIKE
> >>> >(20/02/2002) i.e dd/mm/yyyy format, it saves
> into
> >>> the
> >>> >datbase like 01/01/1900
> >>> >wot i am doing wrong here. 
> >>> >so I need to validate DATE first whether it is
> in
> >>> >dd/mm/yyyy format and then insert into the
> datbase.
> >>> >
> >>> >please help me.. 
> >>> >
> >>>
> >__________________________________________________
> >>> >Do you Yahoo!?
> >>> >New DSL Internet Access from SBC & Yahoo!
> >>> >http://sbc.yahoo.com
> >>> >
> >>> >
> >>> >---
> >>> >
> >>> >Improve your web design skills with these new
> books
> >>> from Glasshaus.
> >>> >
> >>> >Usable Web Menus
> >>>
>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >>> >r-20
> >>> >Constructing Accessible Web Sites
> >>>
>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >>> >r-20
> >>> >Practical JavaScript for the Usable Web
> >>>
>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >>> >r-20
> >>> >
> >>> >
> >>> 
> >>> 
> >>> 
> >>> ---
> >>> 
> >>> Improve your web design skills with these new
> books
> >>> from Glasshaus.
> >>> 
> >>> Usable Web Menus
> >>>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >>> r-20
> >>> Constructing Accessible Web Sites
> >>>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >>> r-20
> >>> Practical JavaScript for the Usable Web
> >>>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >>> r-20
> >>
> >>
> >>__________________________________________________
> >>Do you Yahoo!?
> >>New DSL Internet Access from SBC & Yahoo!
> >>http://sbc.yahoo.com
> >>
> >>
> >>---
> >>
> >>Improve your web design skills with these new
> books from Glasshaus.
> >>
> >>Usable Web Menus
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >>r-20
> >>Constructing Accessible Web Sites
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >>r-20
> >>Practical JavaScript for the Usable Web
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >>r-20
> >>
> >>
> >
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> http://p2p.wrox.com/manager.asp 
=== message truncated ===


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #9 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:03:25 +0200
did you try the american format??

02/20/2002

On 9/19/2002 1:57 PM, raj singh <skylimit1_2001@y...> wrote:
>Well This is proper syntax after all modificaion
>INSERT INTO Time_Detail
>    (time_header, type, date_enter, job, hours, rate,
>cost, pono, comments)
>VALUES (100, 'Time', '20/02/2002 00:00', 100, 11, 100,
>11, '11', '11')
>
>THE CONERSION OF CHAR DATE TYPE TO
>DATETIME DATA TYPE RESULTED IN AN OUT-OF-RANGE
>DATETIME
>VALUE
>
>
>
>
>
>
>
>--- Keith Bamberger <keith@p...> wrote:
>> eeeek I just noticed something in the SQL I sent
>> you, I forgot to remove the "," from the date time.
>> It shouldnt be in there! '01/01/2002 00:00' like
>> that!
>>
>> On 9/19/2002 1:43 PM, Keith Bamberger
>> <keith@p...> wrote:
>> >Hello there :)
>> >
>> >You definately need the single quotes around your
>> date 'DATE TIME'
>> >try this.
>> >
>> >insert into Time_Detail (time_header, type,
>> >date_enter,job, hours, rate, cost, pono, comments)
>> >Values (100, 'Time', '20/02/2002, 00:00' 100, 11,
>> 100, 11,
>> >'11', '11')-->inserts this date in the database
>> >01/01/1900
>> >
>> >
>> >On 9/19/2002 1:37 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >>Hi Keith
>> >>This how my insert query is fired
>> >>
>> >>Insert into Time_Detail (time_header, type,
>> >>date_enter,job, hours, rate, cost, pono, comments)
>> >>Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>> >>'11', '11')-->inserts this date in the database
>> >>01/01/1900
>> >>
>> >>
>> >>and if I cover the date '20/02/2002' it comes up
>> with
>> >>error -->THE CONERSION OF CHAR DATE TYPE TO
>> DATETIME
>> >>DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
>> VALUE
>> >>
>> >>AND if i cover date with "20/02/2002" it comes up
>> with
>> >>error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
>> THIS
>> >>CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
>> HERE.
>> >>COLUMN NAMES ARE NOT PERMITTED.
>> >>
>> >>I have tried in this in query analyzer also. same
>> >>result.My date field in the datbase is datetime.
>> >>
>> >>One more thing , I have see when some enter date
>> in
>> >>the textbox it should be dd/mm/yyyy format only in
>> >>javascript.
>> >>
>> >>--- Keith Bamberger <keith@p...> wrote:
>> >>> Well SQL Server allows a few date formats so
>> that
>> >>> shouldnt really be the issue. Have you tried
>> >>> creating an insert with query analyzer running
>> the
>> >>> exact query you are trying to run? you should
>> find
>> >>> that it works perfectly.
>> >>>
>> >>> I would guess that your date isnt getting
>> through to
>> >>> the insert!? take a look!
>> >>>
>> >>> On 9/19/2002 12:40 PM, raj singh
>> >>> <skylimit1_2001@y...> wrote:
>> >>> >I have two problems
>> >>> >
>> >>> >1) I have to check whether date entered by the
>> user
>> >>> in
>> >>> >the text box is valid date (dd/mm/yyyy) format
>> >>> >
>> >>> >2) if yes insert into SQLServer
>> >>> >
>> >>> >
>> >>> >when ever I enter DATE in the text box LIKE
>> >>> >(20/02/2002) i.e dd/mm/yyyy format, it saves
>> into
>> >>> the
>> >>> >datbase like 01/01/1900
>> >>> >wot i am doing wrong here.
>> >>> >so I need to validate DATE first whether it is
>> in
>> >>> >dd/mm/yyyy format and then insert into the
>> datbase.
>> >>> >
>> >>> >please help me..
>> >>> >
>> >>>
>> >__________________________________________________
>> >>> >Do you Yahoo!?
>> >>> >New DSL Internet Access from SBC & Yahoo!
>> >>> >http://sbc.yahoo.com
>> >>> >
>> >>> >
>> >>> >---
>> >>> >
>> >>> >Improve your web design skills with these new
>> books
>> >>> from Glasshaus.
>> >>> >
>> >>> >Usable Web Menus
>> >>>
>>
>>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >>> >r-20
>> >>> >Constructing Accessible Web Sites
>> >>>
>>
>>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >>> >r-20
>> >>> >Practical JavaScript for the Usable Web
>> >>>
>>
>>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >>> >r-20
>> >>> >
>> >>> >
>> >>>
>> >>>
>> >>>
>> >>> ---
>> >>>
>> >>> Improve your web design skills with these new
>> books
>> >>> from Glasshaus.
>> >>>
>> >>> Usable Web Menus
>> >>>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >>> r-20
>> >>> Constructing Accessible Web Sites
>> >>>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >>> r-20
>> >>> Practical JavaScript for the Usable Web
>> >>>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >>> r-20
>> >>
>> >>
>> >>__________________________________________________
>> >>Do you Yahoo!?
>> >>New DSL Internet Access from SBC & Yahoo!
>> >>http://sbc.yahoo.com
>> >>
>> >>
>> >>---
>> >>
>> >>Improve your web design skills with these new
>> books from Glasshaus.
>> >>
>> >>Usable Web Menus
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >>r-20
>> >>Constructing Accessible Web Sites
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >>r-20
>> >>Practical JavaScript for the Usable Web
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >>r-20
>> >>
>> >>
>> >
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >r-20
>> http://p2p.wrox.com/manager.asp
>=3D=3D=3D message truncated =3D=3D=3D
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #10 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 05:05:18 -0700 (PDT)
you are right if I swapp month and days it works fine
.
Now how to resolve this problem.




--- Keith Bamberger <keith@p...> wrote:
> There is something else, the American date goes like
> this mm/dd/yyyy !?!? try swapping your month and day
> around to get it to work also. 
> 
> If this is the problem then you have the wrong sort
> order for your SQL Server. for where you are. This
> however shouldnt make much difference with the date
> but maybe I am remembering wrong???
> 
> On 9/19/2002 1:37 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >Hi Keith
> >This how my insert query is fired
> >
> >Insert into Time_Detail (time_header, type,
> >date_enter,job, hours, rate, cost, pono, comments)
> >Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
> >'11', '11')-->inserts this date in the database
> >01/01/1900
> >
> >
> >and if I cover the date '20/02/2002' it comes up
> with
> >error -->THE CONERSION OF CHAR DATE TYPE TO
> DATETIME
> >DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
> VALUE
> >
> >AND if i cover date with "20/02/2002" it comes up
> with
> >error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
> THIS
> >CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
> HERE.
> >COLUMN NAMES ARE NOT PERMITTED.
> >
> >I have tried in this in query analyzer also. same
> >result.My date field in the datbase is datetime.
> >
> >One more thing , I have see when some enter date in
> >the textbox it should be dd/mm/yyyy format only in
> >javascript.
> >
> >--- Keith Bamberger <keith@p...> wrote:
> >> Well SQL Server allows a few date formats so that
> >> shouldnt really be the issue. Have you tried
> >> creating an insert with query analyzer running
> the
> >> exact query you are trying to run? you should
> find
> >> that it works perfectly. 
> >> 
> >> I would guess that your date isnt getting through
> to
> >> the insert!? take a look!
> >> 
> >> On 9/19/2002 12:40 PM, raj singh
> >> <skylimit1_2001@y...> wrote:
> >> >I have two problems
> >> >
> >> >1) I have to check whether date entered by the
> user
> >> in
> >> >the text box is valid date (dd/mm/yyyy) format 
> >> >
> >> >2) if yes insert into SQLServer
> >> >
> >> >
> >> >when ever I enter DATE in the text box LIKE
> >> >(20/02/2002) i.e dd/mm/yyyy format, it saves
> into
> >> the
> >> >datbase like 01/01/1900
> >> >wot i am doing wrong here. 
> >> >so I need to validate DATE first whether it is
> in
> >> >dd/mm/yyyy format and then insert into the
> datbase.
> >> >
> >> >please help me.. 
> >> >
> >>
> >__________________________________________________
> >> >Do you Yahoo!?
> >> >New DSL Internet Access from SBC & Yahoo!
> >> >http://sbc.yahoo.com
> >> >
> >> >
> >> >---
> >> >
> >> >Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> >
> >> >Usable Web Menus
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> >r-20
> >> >Constructing Accessible Web Sites
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> >r-20
> >> >Practical JavaScript for the Usable Web
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> >r-20
> >> >
> >> >
> >> 
> >> 
> >> 
> >> ---
> >> 
> >> Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> 
> >> Usable Web Menus
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> r-20
> >> Constructing Accessible Web Sites
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> r-20
> >> Practical JavaScript for the Usable Web
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> r-20
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> >
> >
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #11 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:11:19 +0200
Well this is because you have entered the incorrect sort order when 
installing SQL Server. You should be using the correct sort order for your 
region really but I think I remember there being a convert function in SQL 
Server (Sorry I dont have it installed here :/ so I cant check myself but) 
look in the books online for CONVERT and you should find some date 
converting functions there. Otherwise you should change A) your sort order 
or B) your date with code :D ( Iwould suggest looking at your sort order 
if you arent in america :)

On 9/19/2002 2:05 PM, raj singh <skylimit1_2001@y...> wrote:
>you are right if I swapp month and days it works fine
>.
>Now how to resolve this problem.
>
>
>
>
>--- Keith Bamberger <keith@p...> wrote:
>> There is something else, the American date goes like
>> this mm/dd/yyyy !?!? try swapping your month and day
>> around to get it to work also.
>>
>> If this is the problem then you have the wrong sort
>> order for your SQL Server. for where you are. This
>> however shouldnt make much difference with the date
>> but maybe I am remembering wrong???
>>
>> On 9/19/2002 1:37 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >Hi Keith
>> >This how my insert query is fired
>> >
>> >Insert into Time_Detail (time_header, type,
>> >date_enter,job, hours, rate, cost, pono, comments)
>> >Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>> >'11', '11')-->inserts this date in the database
>> >01/01/1900
>> >
>> >
>> >and if I cover the date '20/02/2002' it comes up
>> with
>> >error -->THE CONERSION OF CHAR DATE TYPE TO
>> DATETIME
>> >DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
>> VALUE
>> >
>> >AND if i cover date with "20/02/2002" it comes up
>> with
>> >error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
>> THIS
>> >CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
>> HERE.
>> >COLUMN NAMES ARE NOT PERMITTED.
>> >
>> >I have tried in this in query analyzer also. same
>> >result.My date field in the datbase is datetime.
>> >
>> >One more thing , I have see when some enter date in
>> >the textbox it should be dd/mm/yyyy format only in
>> >javascript.
>> >
>> >--- Keith Bamberger <keith@p...> wrote:
>> >> Well SQL Server allows a few date formats so that
>> >> shouldnt really be the issue. Have you tried
>> >> creating an insert with query analyzer running
>> the
>> >> exact query you are trying to run? you should
>> find
>> >> that it works perfectly.
>> >>
>> >> I would guess that your date isnt getting through
>> to
>> >> the insert!? take a look!
>> >>
>> >> On 9/19/2002 12:40 PM, raj singh
>> >> <skylimit1_2001@y...> wrote:
>> >> >I have two problems
>> >> >
>> >> >1) I have to check whether date entered by the
>> user
>> >> in
>> >> >the text box is valid date (dd/mm/yyyy) format
>> >> >
>> >> >2) if yes insert into SQLServer
>> >> >
>> >> >
>> >> >when ever I enter DATE in the text box LIKE
>> >> >(20/02/2002) i.e dd/mm/yyyy format, it saves
>> into
>> >> the
>> >> >datbase like 01/01/1900
>> >> >wot i am doing wrong here.
>> >> >so I need to validate DATE first whether it is
>> in
>> >> >dd/mm/yyyy format and then insert into the
>> datbase.
>> >> >
>> >> >please help me..
>> >> >
>> >>
>> >__________________________________________________
>> >> >Do you Yahoo!?
>> >> >New DSL Internet Access from SBC & Yahoo!
>> >> >http://sbc.yahoo.com
>> >> >
>> >> >
>> >> >---
>> >> >
>> >> >Improve your web design skills with these new
>> books
>> >> from Glasshaus.
>> >> >
>> >> >Usable Web Menus
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >> >r-20
>> >> >Constructing Accessible Web Sites
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >> >r-20
>> >> >Practical JavaScript for the Usable Web
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >> >r-20
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >> ---
>> >>
>> >> Improve your web design skills with these new
>> books
>> >> from Glasshaus.
>> >>
>> >> Usable Web Menus
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >> r-20
>> >> Constructing Accessible Web Sites
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >> r-20
>> >> Practical JavaScript for the Usable Web
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >> r-20
>> >
>> >
>> >__________________________________________________
>> >Do you Yahoo!?
>> >New DSL Internet Access from SBC & Yahoo!
>> >http://sbc.yahoo.com
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >r-20
>> >
>> >
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #12 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:15:51 +0200
Hmmm wait before you destroy your Sort order, I am drooling crap (As usual)
 its always that my brain reminds me after I put my foot in it!

the sort order is to do with sorting and characters.

Try changing your locale date on the machine running the sequal server. 
You should be able to change the date format via your OS and then the SQL 
Server will use it to check its dates.

That should then solve your problem! :)
Message #13 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:16:39 +0200
Sorry for my brain not letting me have the information until I look like a 
dummy! I am going to fight with my brain for a while now, good luck raj!


On 9/19/2002 2:05 PM, raj singh <skylimit1_2001@y...> wrote:
>you are right if I swapp month and days it works fine
>.
>Now how to resolve this problem.
>
>
>
>
>--- Keith Bamberger <keith@p...> wrote:
>> There is something else, the American date goes like
>> this mm/dd/yyyy !?!? try swapping your month and day
>> around to get it to work also.
>>
>> If this is the problem then you have the wrong sort
>> order for your SQL Server. for where you are. This
>> however shouldnt make much difference with the date
>> but maybe I am remembering wrong???
>>
>> On 9/19/2002 1:37 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >Hi Keith
>> >This how my insert query is fired
>> >
>> >Insert into Time_Detail (time_header, type,
>> >date_enter,job, hours, rate, cost, pono, comments)
>> >Values (100, 'Time', 20/02/2002, 100, 11, 100, 11,
>> >'11', '11')-->inserts this date in the database
>> >01/01/1900
>> >
>> >
>> >and if I cover the date '20/02/2002' it comes up
>> with
>> >error -->THE CONERSION OF CHAR DATE TYPE TO
>> DATETIME
>> >DATA TYPE RESULTED IN AN OUT-OF-RANGE DATETIME
>> VALUE
>> >
>> >AND if i cover date with "20/02/2002" it comes up
>> with
>> >error-->THE NAME '20/02/2002' IS NOT PERMITTED IN
>> THIS
>> >CONTEXT. ONLY CONSTANTS,EXPRESSIONS, ARE ALLOWED
>> HERE.
>> >COLUMN NAMES ARE NOT PERMITTED.
>> >
>> >I have tried in this in query analyzer also. same
>> >result.My date field in the datbase is datetime.
>> >
>> >One more thing , I have see when some enter date in
>> >the textbox it should be dd/mm/yyyy format only in
>> >javascript.
>> >
>> >--- Keith Bamberger <keith@p...> wrote:
>> >> Well SQL Server allows a few date formats so that
>> >> shouldnt really be the issue. Have you tried
>> >> creating an insert with query analyzer running
>> the
>> >> exact query you are trying to run? you should
>> find
>> >> that it works perfectly.
>> >>
>> >> I would guess that your date isnt getting through
>> to
>> >> the insert!? take a look!
>> >>
>> >> On 9/19/2002 12:40 PM, raj singh
>> >> <skylimit1_2001@y...> wrote:
>> >> >I have two problems
>> >> >
>> >> >1) I have to check whether date entered by the
>> user
>> >> in
>> >> >the text box is valid date (dd/mm/yyyy) format
>> >> >
>> >> >2) if yes insert into SQLServer
>> >> >
>> >> >
>> >> >when ever I enter DATE in the text box LIKE
>> >> >(20/02/2002) i.e dd/mm/yyyy format, it saves
>> into
>> >> the
>> >> >datbase like 01/01/1900
>> >> >wot i am doing wrong here.
>> >> >so I need to validate DATE first whether it is
>> in
>> >> >dd/mm/yyyy format and then insert into the
>> datbase.
>> >> >
>> >> >please help me..
>> >> >
>> >>
>> >__________________________________________________
>> >> >Do you Yahoo!?
>> >> >New DSL Internet Access from SBC & Yahoo!
>> >> >http://sbc.yahoo.com
>> >> >
>> >> >
>> >> >---
>> >> >
>> >> >Improve your web design skills with these new
>> books
>> >> from Glasshaus.
>> >> >
>> >> >Usable Web Menus
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >> >r-20
>> >> >Constructing Accessible Web Sites
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogram
me
>> >> >r-20
>> >> >Practical JavaScript for the Usable Web
>> >>
>>
>>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >> >r-20
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >> ---
>> >>
>> >> Improve your web design skills with these new
>> books
>> >> from Glasshaus.
>> >>
>> >> Usable Web Menus
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >> r-20
>> >> Constructing Accessible Web Sites
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
>> >> r-20
>> >> Practical JavaScript for the Usable Web
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >> r-20
>> >
>> >
>> >__________________________________________________
>> >Do you Yahoo!?
>> >New DSL Internet Access from SBC & Yahoo!
>> >http://sbc.yahoo.com
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >r-20
>> >
>> >
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #14 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 05:23:05 -0700 (PDT)
My date is already in dd/mm/yyyy format 
I mean Regional options




--- Keith Bamberger <keith@p...> wrote:
> Hmmm wait before you destroy your Sort order, I am
> drooling crap (As usual) its always that my brain
> reminds me after I put my foot in it!
> 
> the sort order is to do with sorting and characters.
> 
> Try changing your locale date on the machine running
> the sequal server. You should be able to change the
> date format via your OS and then the SQL Server will
> use it to check its dates.
> 
> That should then solve your problem! :)
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #15 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:33:11 +0200
OK like I already mentioned you can use the Convert function

Guess what I installed the books online just so I could look for CONVERT (
A little lesson for you ;))

CONVERT(DATETIME, '7/19/1996', 101)
101 is the conversion TO parameter! I'll leave it to you to look up the 
rest of the conversion parameters in the books online! If I do anymore for 
you I'd want to be paid ;)
There now all your worries are over :)
be good raj
(And even though not 1 thank you has come my way from you its cool I'll 
survive I'm sure ;))


On 9/19/2002 2:23 PM, raj singh <skylimit1_2001@y...> wrote:
>My date is already in dd/mm/yyyy format
>I mean Regional options
>
>
>
>
>--- Keith Bamberger <keith@p...> wrote:
>> Hmmm wait before you destroy your Sort order, I am
>> drooling crap (As usual) its always that my brain
>> reminds me after I put my foot in it!
>>
>> the sort order is to do with sorting and characters.
>>
>> Try changing your locale date on the machine running
>> the sequal server. You should be able to change the
>> date format via your OS and then the SQL Server will
>> use it to check its dates.
>>
>> That should then solve your problem! :)
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #16 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 05:44:01 -0700 (PDT)
Well Thankssss for all ur help.
U are a good man.

But still my question is half answered..

--- Keith Bamberger <keith@p...> wrote:
> OK like I already mentioned you can use the Convert
> function
> 
> Guess what I installed the books online just so I
> could look for CONVERT (A little lesson for you ;))
> 
> CONVERT(DATETIME, '7/19/1996', 101)
> 101 is the conversion TO parameter! I'll leave it to
> you to look up the rest of the conversion parameters
> in the books online! If I do anymore for you I'd
> want to be paid ;) 
> There now all your worries are over :) 
> be good raj
> (And even though not 1 thank you has come my way
> from you its cool I'll survive I'm sure ;))
> 
> 
> On 9/19/2002 2:23 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >My date is already in dd/mm/yyyy format 
> >I mean Regional options
> >
> >
> >
> >
> >--- Keith Bamberger <keith@p...> wrote:
> >> Hmmm wait before you destroy your Sort order, I
> am
> >> drooling crap (As usual) its always that my brain
> >> reminds me after I put my foot in it!
> >> 
> >> the sort order is to do with sorting and
> characters.
> >> 
> >> Try changing your locale date on the machine
> running
> >> the sequal server. You should be able to change
> the
> >> date format via your OS and then the SQL Server
> will
> >> use it to check its dates.
> >> 
> >> That should then solve your problem! :)
> >> 
> >> 
> >> 
> >> ---
> >> 
> >> Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> 
> >> Usable Web Menus
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> r-20
> >> Constructing Accessible Web Sites
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> r-20
> >> Practical JavaScript for the Usable Web
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> r-20
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> >
> >
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #17 by Keith Bamberger <keith@p...> on 19 Sep 2002 14:51:25 +0200
what was the other half of the questiuon?


On 9/19/2002 2:44 PM, raj singh <skylimit1_2001@y...> wrote:
>Well Thankssss for all ur help.
>U are a good man.
>
>But still my question is half answered..
>
>--- Keith Bamberger <keith@p...> wrote:
>> OK like I already mentioned you can use the Convert
>> function
>>
>> Guess what I installed the books online just so I
>> could look for CONVERT (A little lesson for you ;))
>>
>> CONVERT(DATETIME, '7/19/1996', 101)
>> 101 is the conversion TO parameter! I'll leave it to
>> you to look up the rest of the conversion parameters
>> in the books online! If I do anymore for you I'd
>> want to be paid ;)
>> There now all your worries are over :)
>> be good raj
>> (And even though not 1 thank you has come my way
>> from you its cool I'll survive I'm sure ;))
>>
>>
>> On 9/19/2002 2:23 PM, raj singh
>> <skylimit1_2001@y...> wrote:
>> >My date is already in dd/mm/yyyy format
>> >I mean Regional options
>> >
>> >
>> >
>> >
>> >--- Keith Bamberger <keith@p...> wrote:
>> >> Hmmm wait before you destroy your Sort order, I
>> am
>> >> drooling crap (As usual) its always that my brain
>> >> reminds me after I put my foot in it!
>> >>
>> >> the sort order is to do with sorting and
>> characters.
>> >>
>> >> Try changing your locale date on the machine
>> running
>> >> the sequal server. You should be able to change
>> the
>> >> date format via your OS and then the SQL Server
>> will
>> >> use it to check its dates.
>> >>
>> >> That should then solve your problem! :)
>> >>
>> >>
>> >>
>> >> ---
>> >>
>> >> Improve your web design skills with these new
>> books
>> >> from Glasshaus.
>> >>
>> >> Usable Web Menus
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >> r-20
>> >> Constructing Accessible Web Sites
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >> r-20
>> >> Practical JavaScript for the Usable Web
>> >>
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> >> r-20
>> >
>> >
>> >__________________________________________________
>> >Do you Yahoo!?
>> >New DSL Internet Access from SBC & Yahoo!
>> >http://sbc.yahoo.com
>> >
>> >
>> >---
>> >
>> >Improve your web design skills with these new books
>> from Glasshaus.
>> >
>> >Usable Web Menus
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> >r-20
>> >Constructing Accessible Web Sites
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> >r-20
>> >Practical JavaScript for the Usable Web
>>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
>> >r-20
>> >
>> >
>>
>>
>>
>> ---
>>
>> Improve your web design skills with these new books
>> from Glasshaus.
>>
>> Usable Web Menus
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>> r-20
>> Constructing Accessible Web Sites
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/
theprogramme
>> r-20
>> Practical JavaScript for the Usable Web
>>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>> r-20
>
>
>__________________________________________________
>Do you Yahoo!?
>New DSL Internet Access from SBC & Yahoo!
>http://sbc.yahoo.com
>
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/
theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramme

>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/
theprogramme
>r-20
>to unsubscribe send a blank email to leave-asp_web_howto-1310387Q@p...
wrox.com.
>
>
Message #18 by raj singh <skylimit1_2001@y...> on Thu, 19 Sep 2002 06:09:27 -0700 (PDT)
how to check before submiting whether the date is in 
dd/mm/yyyy format i.e could be in javascript

and related that date i have found 
101 for usa
103 British/French (and this is wot i want)
 It has worked .. Excellent..
Onces again thanks








--- Keith Bamberger <keith@p...> wrote:
> what was the other half of the questiuon?
> 
> 
> On 9/19/2002 2:44 PM, raj singh
> <skylimit1_2001@y...> wrote:
> >Well Thankssss for all ur help.
> >U are a good man.
> >
> >But still my question is half answered..
> >
> >--- Keith Bamberger <keith@p...> wrote:
> >> OK like I already mentioned you can use the
> Convert
> >> function
> >> 
> >> Guess what I installed the books online just so I
> >> could look for CONVERT (A little lesson for you
> ;))
> >> 
> >> CONVERT(DATETIME, '7/19/1996', 101)
> >> 101 is the conversion TO parameter! I'll leave it
> to
> >> you to look up the rest of the conversion
> parameters
> >> in the books online! If I do anymore for you I'd
> >> want to be paid ;) 
> >> There now all your worries are over :) 
> >> be good raj
> >> (And even though not 1 thank you has come my way
> >> from you its cool I'll survive I'm sure ;))
> >> 
> >> 
> >> On 9/19/2002 2:23 PM, raj singh
> >> <skylimit1_2001@y...> wrote:
> >> >My date is already in dd/mm/yyyy format 
> >> >I mean Regional options
> >> >
> >> >
> >> >
> >> >
> >> >--- Keith Bamberger <keith@p...> wrote:
> >> >> Hmmm wait before you destroy your Sort order,
> I
> >> am
> >> >> drooling crap (As usual) its always that my
> brain
> >> >> reminds me after I put my foot in it!
> >> >> 
> >> >> the sort order is to do with sorting and
> >> characters.
> >> >> 
> >> >> Try changing your locale date on the machine
> >> running
> >> >> the sequal server. You should be able to
> change
> >> the
> >> >> date format via your OS and then the SQL
> Server
> >> will
> >> >> use it to check its dates.
> >> >> 
> >> >> That should then solve your problem! :)
> >> >> 
> >> >> 
> >> >> 
> >> >> ---
> >> >> 
> >> >> Improve your web design skills with these new
> >> books
> >> >> from Glasshaus.
> >> >> 
> >> >> Usable Web Menus
> >> >>
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> >> r-20
> >> >> Constructing Accessible Web Sites
> >> >>
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> >> r-20
> >> >> Practical JavaScript for the Usable Web
> >> >>
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> >> r-20
> >> >
> >> >
> >>
> >__________________________________________________
> >> >Do you Yahoo!?
> >> >New DSL Internet Access from SBC & Yahoo!
> >> >http://sbc.yahoo.com
> >> >
> >> >
> >> >---
> >> >
> >> >Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> >
> >> >Usable Web Menus
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> >r-20
> >> >Constructing Accessible Web Sites
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> >r-20
> >> >Practical JavaScript for the Usable Web
> >>
>
>>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> >r-20
> >> >
> >> >
> >> 
> >> 
> >> 
> >> ---
> >> 
> >> Improve your web design skills with these new
> books
> >> from Glasshaus.
> >> 
> >> Usable Web Menus
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >> r-20
> >> Constructing Accessible Web Sites
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >> r-20
> >> Practical JavaScript for the Usable Web
> >>
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >> r-20
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >New DSL Internet Access from SBC & Yahoo!
> >http://sbc.yahoo.com
> >
> >
> >---
> >
> >Improve your web design skills with these new books
> from Glasshaus.
> >
> >Usable Web Menus
>
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> >r-20
> >Constructing Accessible Web Sites
>
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> >r-20
> >Practical JavaScript for the Usable Web
>
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> >r-20
> >
> >
> 
> 
> 
> ---
> 
> Improve your web design skills with these new books
> from Glasshaus.
> 
> Usable Web Menus
>
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20
=== message truncated ===


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
Message #19 by "Ken Schaefer" <ken@a...> on Fri, 20 Sep 2002 17:06:03 +1000
I haven't followed the conversation so far but:

a) when inserting dates into a database use yyyy/mm/dd format
b) whether a date is *valid* can be done using VBScript's IsDate() function
c) you can't tell whether someone has entered 1/2/2002 as 1st Feb 2002 or
2nd January 2002 - there is no way that javascript (or any other language
can tell you). You just have to assume that the user entered the date you
want it to be.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "raj singh" <skylimit1_2001@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Thursday, September 19, 2002 11:09 PM
Subject: [asp_web_howto] Re: Date validation


: how to check before submiting whether the date is in
: dd/mm/yyyy format i.e could be in javascript
:
: and related that date i have found
: 101 for usa
: 103 British/French (and this is wot i want)
:  It has worked .. Excellent..
: Onces again thanks
:
:
:
:
:
:
:
:
: --- Keith Bamberger <keith@p...> wrote:
: > what was the other half of the questiuon?
: >
: >
: > On 9/19/2002 2:44 PM, raj singh
: > <skylimit1_2001@y...> wrote:
: > >Well Thankssss for all ur help.
: > >U are a good man.
: > >
: > >But still my question is half answered..
: > >
: > >--- Keith Bamberger <keith@p...> wrote:
: > >> OK like I already mentioned you can use the
: > Convert
: > >> function
: > >>
: > >> Guess what I installed the books online just so I
: > >> could look for CONVERT (A little lesson for you
: > ;))
: > >>
: > >> CONVERT(DATETIME, '7/19/1996', 101)
: > >> 101 is the conversion TO parameter! I'll leave it
: > to
: > >> you to look up the rest of the conversion
: > parameters
: > >> in the books online! If I do anymore for you I'd
: > >> want to be paid ;)
: > >> There now all your worries are over :)
: > >> be good raj
: > >> (And even though not 1 thank you has come my way
: > >> from you its cool I'll survive I'm sure ;))
: > >>
: > >>
: > >> On 9/19/2002 2:23 PM, raj singh
: > >> <skylimit1_2001@y...> wrote:
: > >> >My date is already in dd/mm/yyyy format
: > >> >I mean Regional options
: > >> >
: > >> >
: > >> >
: > >> >
: > >> >--- Keith Bamberger <keith@p...> wrote:
: > >> >> Hmmm wait before you destroy your Sort order,
: > I
: > >> am
: > >> >> drooling crap (As usual) its always that my
: > brain
: > >> >> reminds me after I put my foot in it!
: > >> >>
: > >> >> the sort order is to do with sorting and
: > >> characters.
: > >> >>
: > >> >> Try changing your locale date on the machine
: > >> running
: > >> >> the sequal server. You should be able to
: > change
: > >> the
: > >> >> date format via your OS and then the SQL
: > Server
: > >> will
: > >> >> use it to check its dates.
: > >> >>
: > >> >> That should then solve your problem! :)
: > >> >>
: > >> >>
: > >> >>
: > >> >> ---
: > >> >>
: > >> >> Improve your web design skills with these new
: > >> books
: > >> >> from Glasshaus.
: > >> >>
: > >> >> Usable Web Menus
: > >> >>
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: > >> >> r-20
: > >> >> Constructing Accessible Web Sites
: > >> >>
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: > >> >> r-20
: > >> >> Practical JavaScript for the Usable Web
: > >> >>
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: > >> >> r-20
: > >> >
: > >> >
: > >>
: > >__________________________________________________
: > >> >Do you Yahoo!?
: > >> >New DSL Internet Access from SBC & Yahoo!
: > >> >http://sbc.yahoo.com
: > >> >
: > >> >
: > >> >---
: > >> >
: > >> >Improve your web design skills with these new
: > books
: > >> from Glasshaus.
: > >> >
: > >> >Usable Web Menus
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: > >> >r-20
: > >> >Constructing Accessible Web Sites
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: > >> >r-20
: > >> >Practical JavaScript for the Usable Web
: > >>
: >
: >>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: > >> >r-20
: > >> >
: > >> >
: > >>
: > >>
: > >>
: > >> ---
: > >>
: > >> Improve your web design skills with these new
: > books
: > >> from Glasshaus.
: > >>
: > >> Usable Web Menus
: > >>
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: > >> r-20
: > >> Constructing Accessible Web Sites
: > >>
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: > >> r-20
: > >> Practical JavaScript for the Usable Web
: > >>
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: > >> r-20
: > >
: > >
: > >__________________________________________________
: > >Do you Yahoo!?
: > >New DSL Internet Access from SBC & Yahoo!
: > >http://sbc.yahoo.com
: > >
: > >
: > >---
: > >
: > >Improve your web design skills with these new books
: > from Glasshaus.
: > >
: > >Usable Web Menus
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: > >r-20
: > >Constructing Accessible Web Sites
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: > >r-20
: > >Practical JavaScript for the Usable Web
: >
: >http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: > >r-20
: > >
: > >
: >
: >
: >
: > ---
: >
: > Improve your web design skills with these new books
: > from Glasshaus.
: >
: > Usable Web Menus
: >
: http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: > r-20
: > Constructing Accessible Web Sites
: >
: http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: > r-20
: > Practical JavaScript for the Usable Web
: >
: http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: > r-20
: === message truncated ===
:
:
: __________________________________________________
: Do you Yahoo!?
: New DSL Internet Access from SBC & Yahoo!
: http://sbc.yahoo.com
:
:
: ---
:
: Improve your web design skills with these new books from Glasshaus.
:
: Usable Web Menus
: http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
: r-20
: Constructing Accessible Web Sites
: http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
: r-20
: Practical JavaScript for the Usable Web
: http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
: r-20

  Return to Index  
About Wrox  |  Contact Us  |  Subscribe to an RSS Feed of New Wrox Titles
Copyright © 2000-2004 by John Wiley & Sons, Inc. or related companies. All rights reserved. Please read our Privacy Policy