By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

How to solve Microsoft VBScript runtime (0x800A000D)Type mismatch error

P: 2
I am experiencing a VBScript runtime error.
The error message is: "(0x800A000D)Type mismatch error"

Here is my code:
Expand|Select|Wrap|Line Numbers
  1. <% 
  2.    dim temp
  3.    temp=session("items")
  4.    session("count")=session("count")+1
  5.    redim  preserve items(session("count"))
  6.  
  7.   response.write items(session("count"))
  8.     for i=0 to session("count")-1
  9.       items(i)=temp(i)
  10.      next
  11.  
  12.     items(session("count"))=request.form("impo")
  13.     session("items")=items
  14.  
  15. cstring="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.Mappath("../database/base.mdb")
  16. set conn = Server.CreateObject("ADODB.connection")
  17. set rs = Server.CreateObject("ADODB.recordset")
  18. conn.open cstring
  19.  
  20. %>
  21.  
  22. <html>
  23.    <body bgcolor=#E1E1FF >
  24. <table border=0 width=100%>
  25.    <tr><td align=center><font color=#FF0000><b>PRISCRIPTION LIST</b></font>
  26.    </table>
  27.    <center>
  28.    <table border=0 width='60%'> 
  29.    <tr><td width='30%' align=center><font color=darkblue><B>MEDICINE NAME</B></FONT></td>
  30.    <td width='30%' align=center><font color=darkblue><B>PRICE Rs</font></td>
  31.  
  32. <%
  33.   for i=0 to session("count")
  34.    sql= "select * from stores where mid ='"& items(i) &"'"
  35.    rs.open sql,conn,1,3 
  36.   if not rs.eof then
  37.        response.write "<tr><td width='30%' align=center>"
  38.       response.write rs("mname")
  39.       response.write "</td><td width='30%' align=center>"&rs("price")&"</td></tr>"
  40.     end if
  41.     rs.close
  42.     next 
  43.   response.write "</table></center>"
  44.  %>
  45.  
  46. <br>
  47. <div align="center">
  48.   <center>
  49. <table border=0 width='680' height="1">
  50. <tr><td align="right" height=1 width="345" valign="baseline">
  51. <form action=billing.asp method=post target=_top>
  52. <input type=submit value="Accept"></form>
  53. </td>
  54.   <td align="center" height=1 width="93" valign="baseline">
  55. <form action=maintain.asp method=post>
  56. <input type=hidden value="cancel" name="flg">
  57. <input type=submit value="Cancel"></form></td>
  58.   <td align="center" height=1 width="239" valign="baseline">
  59.   </td>
  60. </tr>
  61. </table></center>
  62. </div>
  63.    <table border="0" width="100%">
  64.      <tr>
  65.        <td width="100%">
  66.        <p align="center"><font color="#FF0000"><b>HIT CANCEL TO DELETE YOUR LIST</b></font></td>
  67.      </tr>
  68.    </table>

Please help me to resolve this problem.

Thank you.
Mar 8 '11 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,369
You have to tell us which line the error is on. The only thing I can tell you right now is that at some point, a function is expecting one variable type but you're giving it the wrong type.
Mar 8 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.