Object required: ''

[PhatH]

Hello all,

I really don't know where this error is about

Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/includes/subnav/products_subnav.asp, line 3

My first few line of code are:

<%
sqlHots = "SELECT ShortName, ProductID, ManuID, ProdTypeID FROM tblProducts WHERE New = '1'"
Set rsHot = objConn.Execute(sqlHots)
%>
<div id="navlist">
<table cellpadding="0" cellspacing="0" bgColor=#dbdbdb>
<tr><td height=10></td></tr>
<tr valign="top">
<td vAlign=top align=left width=170>
<font face="Arial, Helvetica, sans-serif"><b>Hardware</b></font>
<ul>

And the line 3 is pointing to this line:
Set rsHot = objConn.Execute(sqlHots)

I looked all over and couldn't think of why. Someone help?

thanks!

 

[PhatH]

I forgot to mention:

"SELECT ShortName, ProductID, ManuID, ProdTypeID FROM tblProducts WHERE New = 1"

New column is holding data in "bit

 

[sleipnir214]

This is a VBScript question, not a MySQL question.

I recommend you post this question in a VBScript forum.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[PhatH]

thanks!