1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Error: Microsoft VBScript runtime error '800a000d'...Type Mismatch

Discussion in 'C#' started by borisding, Aug 15, 2006.

  1. #1
    Hi all,
    I'm writing a script using ASP with VBScript..
    One of my file that executed at localhost..done well and retrieved the result.
    But ,
    when i try to run at real server,
    and execute the file again, The page shows me an Error as below:
    SEMrush
    "Microsoft VBScript runtime error '800a000d'
    Type Mismatch

    /epsstk/stock/transaction/goods_received/savegoods_received.asp, line 133
    "

    I tried to debug, yet still fail to solve the problem.
    Does anyone knows why?
    why it can work at localhost yet failed in real server?
    any setting ?
    Thanks for any helps!! URGENT!
     
    borisding, Aug 15, 2006 IP
    SEMrush
  2. jaymcc

    jaymcc Peon

    Messages:
    139
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Can you post the lines of code at and around line 133 please.

    Jay
     
    jaymcc, Aug 15, 2006 IP
  3. borisding

    borisding Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Below is the codes:


    '------------------------------------for cost_temp--------------------------------------------------'

    set conSelCost=server.CreateObject("ADODB.Connection")
    set rsSelCost =server.CreateObject("ADODB.Recordset")
    conSelCost.open connect
    strSelCost="SELECT * FROM cost_temp WHERE stock='"&stock_temp&"' AND description='"&description_temp&"' "
    rsSelCost.open strSelCost, conSelCost
     
    borisding, Aug 16, 2006 IP
  4. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #4
    For debugging try the fllowing

    conSelCost.open connect
    strSelCost="SELECT * FROM cost_temp WHERE stock='"&stock_temp&"' AND description='"&description_temp&"' "
    response.write strSelCost
    response.end
    rsSelCost.open strSelCost, conSelCost


    Also you might be compareing the INT with a STRING and that might cause a type mismatch
     
    ludwig, Aug 16, 2006 IP
  5. vectorgraphx

    vectorgraphx Guest

    Messages:
    545
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yes, check that your stock and description are both text fields. if either is numeric, you will need to remove the apostrophes from around the comparitive variable that you're bouncing it against in your where clause. Apostrophes denote text fields in sql queries.

    good luck and post back and let us know -

    vectorgraphx
     
    vectorgraphx, Aug 16, 2006 IP
  6. eamo

    eamo Peon

    Messages:
    225
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Probably requested a numeric from the database and expecting string
     
    eamo, Jul 4, 2011 IP
  7. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #7
    did you check the date?
     
    ludwig, Jul 4, 2011 IP