Type Mismatch Help

**meex** · 05-21-2004, 02:16 AM

I have a very unusual type mismatch on my site.. Here's the line that its on.

<td class="boldText"><a href="makePosts.asp?subID=<%=rsForum("subjectID")% >">make post</a></td>

I figured cos this looks normal that maybe it was something to do with the loop ahead of this code but i can't see anything. Here is the code that is ahead of this link.

<%
Do While NOT rsForum.EOF
%>
<tr>
<td class="boldText"><%=rsForum("userLogin")%></td>
<td class="text"><%=rsForum("subjectComment")%></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="boldText"><%=rsForum("commentDate")%></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
rsForum.MoveNext
Loop
rsForum.Close
Set rsForum = Nothing
objCon.Close
Set objCon = Nothing
%>

If anyone can see why i would be getting a mismatch!

that'd be great

**Sharon White** · 05-21-2004, 10:47 PM

I don't know for sure what is wrong but I suspect it may be to do with the 'Nothing' that is being returned by the function rsForum.

Could try setting it to blank strings and see what happens.

w w w 2 8.b r i n k s t e r.c o m/s n o w w/i n d e x.h t m

w w w.g r a b a f r e e b i e.c o m f r e e b i e E B o o k f o r g r a b

**TopGun** · 05-31-2004, 05:59 AM

I would agree. The problem probably isn't the code, it's the data being returned creating the error. You can fix this in code by forcing the data to be of a specific type.