VBScript Error - Object required: ''

I am getting this error when the remmed lines 52 + 53 are used to provide a far
nicer vPath statement. I am successful with the longer vPath statement (shown
in the code) but am totally baffled as to why I am getting the 'ObJect
Required' error. Any ideas gratefully received.. Thanks Dave(UK << Error
Type: Microsoft VBScript runtime (0x800A01A8) Object required: ''
/database_/Teldir/TMPof0n174wdw.asp, line 52 >> :confused;

<% Dim vUnit,vWing,vPath %>
<% While ((Repeat1__numRows <> 0) AND (NOT rsWing.EOF)) %>
<tr>
<td><%=(rsWing.Fields.Item("Unit").Value)%></td>
<td><%=(rsWing.Fields.Item("Wing").Value)%></td>
<%
'vUnit= rsWings.Fields.Item("Wing").Value ' <-----------------THIS IS LINE 52
'vWing= rsWings.Fields.Item("Wing").Value ' <-----------------THIS IS THE SAME
'vPath="../Telweb/" & vUnit & "/" & vWing & "/Teldir.rtf"
vPath = "../Telweb/" & rsWing.Fields.Item("Unit").Value & _
"/" & rsWing.Fields.Item("Wing").Value & _
"/Teldir.rtf"
%>
<td><a href="<%=vPath%>"</a>GoToListing</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsWing.MoveNext()
Wend
%>

Looks like a typo in recordset name.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Hi Dave,

You've got this which works
<%=(rsWing.Fields.Item("Unit").Value)%>
and this which doesn't
'vUnit= rsWings.Fields.Item("Wing").Value

So I assuming the recordset should be called rsWing not rsWings

Cheers,
Jon

"Dave(UK)" <webforumsuser (AT) macromedia (DOT) com> wrote

I am getting this error when the remmed lines 52 + 53 are used to provide a
far
nicer vPath statement. I am successful with the longer vPath statement
(shown
in the code) but am totally baffled as to why I am getting the 'ObJect
Required' error. Any ideas gratefully received.. Thanks Dave(UK << Error
Type: Microsoft VBScript runtime (0x800A01A8) Object required: ''
/database_/Teldir/TMPof0n174wdw.asp, line 52 >> :confused;

% Dim vUnit,vWing,vPath %
% While ((Repeat1__numRows <> 0) AND (NOT rsWing.EOF)) %
tr
td><%=(rsWing.Fields.Item("Unit").Value)%></td
td><%=(rsWing.Fields.Item("Wing").Value)%></td
%
'vUnit= rsWings.Fields.Item("Wing").Value ' <-----------------THIS IS
LINE 52
'vWing= rsWings.Fields.Item("Wing").Value ' <-----------------THIS IS THE
SAME
'vPath="../Telweb/" & vUnit & "/" & vWing & "/Teldir.rtf"
vPath = "../Telweb/" & rsWing.Fields.Item("Unit").Value & _
"/" & rsWing.Fields.Item("Wing").Value & _
"/Teldir.rtf"
%
td><a href="<%=vPath%>"</a>GoToListing</td
/tr
%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsWing.MoveNext()
Wend
%

Thanks, Jon &amp; Jules and Jules and Jon ... too near the wood to see the trees that time ... how embarrassing!! Much Obliged, Dave(UK)