Funny Recordset

Results 1 to 2 of 2

Thread: Funny Recordset

  1. #1
    Join Date
    Dec 1969

    Default Funny Recordset

    Hi there,<BR><BR>I have problem updating date using recordset. I have a input date field "QuoteDate" with date format in DDMMYYYY. When i try to update or insert into SQL Server, the date format changes to MMDDYYYY. The funny thing is it doesn&#039;t happens when i use update SQL statement to do it. Does anyone encounter such problems before?<BR><BR>Thank you.

  2. #2
    Join Date
    Dec 1969

    Default DEBUG your SQL...

    Response.Write the SQL that you are sending to SQL Server.<BR><BR>I will bet that you are sending the date in mm/dd/yyyy format.<BR><BR>To change that, you need to use Session.LCID=xxxx where xxxx tells ASP the country you are working in.<BR><BR>[When you do this with SQL Server tools, you probably are already using the correct Locale, which is why it looks like it works fine.]<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts