Home > ASP Development > Microsoft VBScript runtime error '800a000d'

Microsoft VBScript runtime error '800a000d'

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

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:

Code:

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:

Code:

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

Line 18 is:

Code:

	strSQL = "Select * From members where username='"&Fixbug(Request.Querystring("view"))&"'"

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!

Guest

what is the code for the FixBug function?

make sure that the querystring is not empty before selecting it from the database

Was this answer helpful ? Yes No

Guest

whats "fixbug"?
have u checked whether u have any value in Request.Querystring("view")??

and an advise:

Code:

 Set ObjRS = ObjConn.Execute(strSQL) IF ObjRS.Eof then

should be:

Code:

Set ObjRS = ObjConn.Execute(strSQL) 
IF ObjRS.Eof then

shud be on next line as u see.

Was this answer helpful ? Yes No

Guest

do you declare the fixbug object somewere in your code??

Was this answer helpful ? Yes No

Guest

Hi!

I don't know what the "fixbug" thing is, but the problem was that I hadn't include the database *duh*

Sorry for taking your time and posting this stupid post. I feel ashamed

Was this answer helpful ? Yes No

Guest

dont be ashamed

at least its working now

Was this answer helpful ? Yes No

Guest

Quote:

Originally Posted by titttili

Hi!

I don't know what the "fixbug" thing is, but the problem was that I hadn't include the database *duh*

Sorry for taking your time and posting this stupid post. I feel ashamed

ya , nofriends is right!
but how come u dont know abt Fixbug and why are u using it then??

Was this answer helpful ? Yes No

Guest

Fixbug is probably some function that replace's the single quotes with ''?

Was this answer helpful ? Yes No

Guest

amazing........... somebody wrote the code and dont know abt it.... and somebody else knows abt it

BTW, nofriends.......... which belt will u get now after 6 posts more????

Was this answer helpful ? Yes No

Guest

I don't know what color

I think its red or something

Was this answer helpful ? Yes No

Guest

Answer it

Ask Question About ASP Development

Microsoft VBScript runtime error '800a000d'

Programming

Related Pages