Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Location
    Australia
    Posts
    183

    Angry Unanswered: date format help?

    Call myCon.Execute("INSERT INTO BloodInventory (ProductID, locations, RBC,PhenotypeReserve, CMV, IRR, AverageDailyIssues, " & _
    "DaysRemaining, SDLPF, TWLPF, FilteredApheresis, UserName,Scan, address, FilteredPaediatric, TimeEntered) VALUES (" & _
    BuildString(unescape(Request.QueryString("ProductI D").Item)) & ", " & _
    BuildString(unescape(Request.QueryString("location s").Item)) & ", " & _
    BuildString(unescape(Request.QueryString("RBC").It em)) & ", " & _

    BuildString(Format(left(Request.QueryString("DATE" ).Item, 2) & "/" & mid(Request.QueryString("DATE").Item, 2, 2) & "/" & Right(Request.QueryString("DATE").Item, 4), "dd MMM yyyy") & ", " & _


    BuildString(unescape(Request.QueryString("CMV").It em)) & ", " & _
    BuildString(unescape(Request.QueryString("IRR").It em)) & ", " & _
    BuildString(unescape(Request.QueryString("AverageD ailyIssues").Item)) & ", " & _
    BuildString(unescape(Request.QueryString("DaysRema ining").Item)) & ", " & _
    BuildString(unescape(Request.QueryString("SDLPF"). Item)) & ", " & _
    BuildString(unescape(Request.QueryString("TWLPF"). Item)) & ", " & _
    BuildString(unescape(Request.QueryString("Filtered Apheresis").Item)) & ", " & _
    BuildString(Request.Cookies("Login").Item) & ", " & _
    BuildString(unescape(Request.QueryString("Scan").I tem)) & ", " & _
    BuildString(unescape(Request.QueryString("address" ).Item)) & ", " & _
    BuildString(unescape(Request.QueryString("Filtered Paediatric").Item)) & ", GetDate())"))

    Call myCon.Close



    I was hoping somebody can help me with the highlighted code, I am trying to be able to save date that gets scanned into my web page into ddmmyyyy format so I am trying to format that before the insert but I get type mismatch error for Format function, am I not using it properly? Don't worry about BuildString it is a function that my senior programmer created,it wouldn't affect it.
    Last edited by zobernjik; 03-10-05 at 21:54.

Posting Permissions

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