displaying the date

Discussion in 'ASP General' started by isaac2004, Feb 28, 2006.

  1. isaac2004

    isaac2004 Guest

    hello i am creating a dynamic page with database access that acts as an
    online store. i have a sql statement that needs the date and time of
    the order to send an invoice to a user.

    here is my code to insert the new values into the database

    strInsertSQL = "INSERT INTO tblOrders (strEmail, ISBN, dtOrderDate) " &
    _
    "VALUES ('" & strEmail & "', '" & strISBN & "', ?
    '")"


    i dont know what value to input where the ? is thanks for the help
     
    isaac2004, Feb 28, 2006
    #1
    1. Advertising

  2. isaac2004

    Guest

    isaac2004 wrote:
    > hello i am creating a dynamic page with database access that acts as an
    > online store. i have a sql statement that needs the date and time of
    > the order to send an invoice to a user.


    In VBScript Now() could do the job, otherwise just tell the database to
    put whatever function the db provides you to catch the current datetime
    as the default value so you can keep it out of your sql statement.

    Lorenzo
     
    , Feb 28, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt
    Replies:
    1
    Views:
    605
    Matthew Speed
    Nov 8, 2003
  2. Peter Grison

    Date, date date date....

    Peter Grison, May 28, 2004, in forum: Java
    Replies:
    10
    Views:
    3,272
    Michael Borgwardt
    May 30, 2004
  3. Matt
    Replies:
    2
    Views:
    519
    Pete Becker
    Nov 8, 2003
  4. Matt
    Replies:
    3
    Views:
    723
    Richard Heathfield
    Nov 8, 2003
  5. Matt
    Replies:
    11
    Views:
    407
    Aaron Bertrand [MVP]
    Nov 8, 2003
Loading...

Share This Page