Microsoft VBScript runtime error '800a000d'

[tittili]

Hi there! I hope someone can help me with this problem..
With this code:

<%
' Shows the member.
strSQL = "Select * From members where username='"&Fixbug(Request.Querystring("view"))&"'"
Set ObjRS = ObjConn.Execute(strSQL)
IF ObjRS.Eof then
Response.Write "No members."
End if 
%>

I get this error:

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'Fixbug'
/com/userview.asp, line 17

If I take away "Fixbug" in the code, I get this error:

Microsoft VBScript runtime error '800a01a8'
Object required: ''
/com/userview.asp, line 18

What is the problem? I don't understand a thing, because this script is working just fine on another server.

I'm so greatful for any help I can get! Thanks in advance!

[mattglet]

Try this:

username="'"&Fixbug(Request.Querystring("view"))&"'"

Added a quote after the =

[mrMister]

What exactly is FixBug? Is it a wrapper function for a COM object by any chance? What data is it returning? Can you please show us the code for the fixbug function?

Also, what do you mean by taking away fixbug? Can you show the exact line of code with fixbug removed.

[tittili]

Hey!

I saw the problem.. I didn't include the database! *duh* Sorry, it was a really stupid mistake!

Thank you for taking time to answer me!