User Profile

Collapse

Profile Sidebar

Collapse
microjack
microjack
Last Activity: Aug 20 '07, 03:08 PM
Joined: Aug 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • microjack
    replied to Inserting date issue
    in SQL Server
    Can that be used in an asp/vbscript page?

    Sorry I should have made it clear I'm doing this via an asp page
    See more | Go to post

      Leave a comment:

    • microjack
      started a topic Inserting date issue
      in SQL Server

      Inserting date issue

      I’ve finally made the jump from Access to SQL Express but I’m having some difficulty inserting a date using an asp/vbscript page.

      I’ve trawled the web and persisted with trial and error and basically I’m down to 2 outcomes.

      The first…

      Formatting the date before insert, all combination of day month and year using / or - as a separator. The insert works but shows in the table as either 01/01/1900...
      See more | Go to post
      Last edited by microjack; Aug 16 '07, 06:36 PM. Reason: adding extra info
      • microjack
        started a topic Inserting date issue
        in ASP Classic

        Inserting date issue

        I’ve finally made the jump from Access to SQL Express but I’m having some difficulty inserting a date using an asp/vbscript page.

        I’ve trawled the web and persisted with trial and error and basically I’m down to 2 outcomes.

        The first…

        Formatting the date before insert, all combination of day month and year using / or - as a separator. The insert works but shows in the table as either 01/01/1900...
        See more | Go to post
        Last edited by microjack; Aug 16 '07, 06:34 PM. Reason: Adding extra information
        No activity results to display
        Show More
        Working...