RE: FN-FORUM:

date posted 8th August 2004 16:08

Are you putting the Set language british in a SQL Stored Proc or into the
ASP


The out of range is probable due to the date being wrong for the style,
remember 103 for 4 digit year, 3 for 2 digit.

If you want to email a bit more of the code off list I will be happy to have
a quick look

Damon

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
WHITTAKER
Sent: 08 August 2004 14:19
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re: FN-FORUM:


That does't work either - it was the first thing I tried. It is asking for
an "=". If I put the = in
I then get

Microsoft VBScript runtime error '800a01a8'
Object required: 'british'


Help!

Pam




----- Original Message -----
From: "Raymond Stone" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, August 08, 2004 2:03 PM
Subject: RE: FN-FORUM:


>
> A google search indicated that your line should have worked, perhaps the
> literal is case sensitive
>
> i.e. try set language british
>
>
>
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
> WHITTAKER
> Sent: 08 August 2004 13:03
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM:
>
>
>
> Hi,
>
> I am getting
>
>
> Microsoft OLE DB Provider for SQL Server error '80040e07'
> The conversion of a char data type to a datetime data type resulted in
an
> out-of-range datetime value
>
> when I use convert(datetime in my sql statement
>
> I have tried putting the following infront of the sql statemt
>
>
> SET LANGUAGE = British
> GO
>
>
> But I then get
>
> Microsoft VBScript runtime error '800a01a8'
> Object required: 'British'
>
>
> Help - what am I going wrong. I have also tried English aswell
>
>
> Thanks
> Pam
>
>
>
>
>
>
>
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
--
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html