Need help: Session.LCID in ASP page causing database date/..

Hi!

Having a problem on an ASP page when its inserting information into a MS SQL
2000 database...

In my shopping cart I have 3 columns:
"datecreated" this is smalldatetime and records the date the shopping cart
was created
"datesent" this is smalldatetime and records the date the order was actually
sent
"ordersent" this is a bit and flags whether or not the order has been sent
or not

These columns are mainly used for maintenance/upkeep or to allow the
customer to recall past orders... when a cart is created "datecreated" is
set with the current time/date... when the order is sent "datesent" is set
with the current time/date and "ordersent" is set to TRUE (1)

At the end of the day when maintenance scripts run all carts that were
created more than 24hrs ago and not sent are deleted and all carts that are
created more than 30 days ago that were sent are moved to the archived
orders database...

This is done because carts that are more than 24hrs old are pretty much
useless and archived orders are kept in the event a customer wants to come
back and say "what did I order in the past" or "I want to resend a past
order" and they will see orders from the last 30 days... if they want to go
back further then the archive database is accessed for old orders...

The problem:

Everything works fine for restaurants in the US, but we're doing the rollout
ot the UK now and thats causing some problems...

To handle the different date format and the GBP symbol I have set the
"SESSION.LCID=2057" in all web pages.

Things worked fine when we started setting up restaurants back on December
1st and running tests... but as soon as we hit Tuesday this week (December
13th) problems started coming up.

The problem is under the US LCID dates are written as: MM/DD/YYYY... but
under the UK LCID dates are written as: DD/MM/YYYY and so though it looked
like things were working, as soon as we hit December 13th we hit the problem
where there is no 13th month so SQL errors started coming up as "can't
convert CHAR format to SMALLDATETIME"

I took a look around SQL and can't seem to find anything where I can set the
date/time format on the one database to use a different date/time format...
and I don't want to set the SESSION.LCID back to US before each write that
involved a date and then back to UK once its done (it'd probably work, but
seems like it would be an innefficient way of doing things)... and I don't
want to convert the dates in the DB columns to CHAR format because that
might bugger up the date/time sorting.

So looking to see if there are any suggestions out there.. I Googled for
ideas, but didn't really come up with anything

Thanks!

Clint

Writing in news:alt.www.webmaster
From the safety of the cafeteria
Auggie <Imperial.Palace.TakeThisOut@Rome.It> said:

> Hi!

How do you do?

> Having a problem on an ASP page when its inserting information into a MS
> SQL
> 2000 database...
> ...
> The problem is under the US LCID dates are written as: MM/DD/YYYY...
> but
> under the UK LCID dates are written as: DD/MM/YYYY ...

I'd guess you're setting the dates in ASP. Have you considered letting
SQL Server create them?

--
William Tasso

Save the drama
for your Mama.