innerjoin problem in sql query
-
i m displaying records from database in which id of first table and second table should be same so i used inner join but it gives error of type rs mismatch when i display that please help me i m using ASP script. datatype of news_id is autonumber and newsid datatype is number <% OpenDataBase conn sql3="select * from news inner join newsimage on news.news_id =newsimage.newsid" set rs=server.createobject("adodb.recordset") rs.open sql3,conn,1,1 response.Write (rs("news_titile")) %>
-
i m displaying records from database in which id of first table and second table should be same so i used inner join but it gives error of type rs mismatch when i display that please help me i m using ASP script. datatype of news_id is autonumber and newsid datatype is number <% OpenDataBase conn sql3="select * from news inner join newsimage on news.news_id =newsimage.newsid" set rs=server.createobject("adodb.recordset") rs.open sql3,conn,1,1 response.Write (rs("news_titile")) %>
can you show us the table structures for easy understand? but i just now noticed a wrong thing in your code but not sure.
response.Write (rs("news_titile"))
may be the field name will be incorrect, it should be news_title
let me know the statusthatraja