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