Record display question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic


   I am trying to write a page that displays the results of two seperate tables and the fields are listed individually for fromating reasons.  The code i used is below.  However, I keep getting a type mismatch response.write on certain fields in the db.  I have tried many things to figure out what the problem is.  I even have two fields that are defined identical in the database.  Date/time and all the same options however, one displays and one does not.  Any suggestions would be help.  Sorry for the length of the post and thanks in advance
\
\
\
<%
Set ra=Request.Form("RmaN")
Set db=Server.CreateObject("ADODB.Connection")
db.Provider="Microsoft.Jet.OLEDB.4.0"
db.Open "C:/Inetpub/wwwroot/web/posts.mdb"

set rs=Server.CreateObject("ADODB.recordset")
sql="select rmalog.*,rmaprocessing.* from rmalog, rmaprocessing where rmalog.rmanumber5=rmaprocessing.rmanumber2"
rs.Open sql,db
%>
<table border="0" width="10">
<%
'Autonumbered
%>
<%
 rs.movefirst
 do while not rs.eof
%>
<tr>
<td>
 <%=rs("key")%>
</td>
<td>
<%
'number
%>
 <%=rs("dateissued2")%>
</td>
<td>
<%
'number
%>
 <%=rs("customernumber3")%>
</td>
<td>
<%
'Text
%>
 <%=rs("customername4")%>
</td>
</tr>  
<%
 rs.movenext
 loop
%>
<%
 rs.close
 db.close
%>
</table>
</body>