Connecting Tech Pros Worldwide Forums | Help | Site Map

Microsoft VBScript runtime (0x800A000D)

Newbie
 
Join Date: Sep 2006
Posts: 2
#1: Apr 26 '07
Hello:

I have Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "C-07-05, 0"]'
The error happened at this line:bookno = chr(bookno)

The code like this:

bookno = Request.Form("book_no")
If bookno = "" Then
bookno = 0
Else
bookno = chr(bookno)
End If

If bookno = 0 Then
empno = ""
dept = ""
bookname = ""
issuedate = ""
returndate = ""
Else
Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Set Recordset2 = conn.Execute("SELECT * FROM transact WHERE book_no = " & bookno)
If Recordset2.BOF = True Then
empno = ""
dept = ""
bookname = ""
issuedate = ""
returndate = ""
Else
empno = Recordset2("emp_no")
dept = Recordset2("dept")
bookname = Recordset2("book_name")
issuedate = Recordset2("issue_date")
returndate = Recordset2("return_date")
End If
End If
..........

I got Error Type mismatch: '[string: "C-07-05, 0"]'


What am I missing here?

Your help is highly appreciated.

Reply