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

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:

"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!

 

Can you post the lines of code at and around line 133 please.

Jay

 

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

 

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

 

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

 

Probably requested a numeric from the database and expecting string

 

did you check the date?