retrieving a single table database at a time displaying contents

[psyren]

i have a prob not quite sure which one i have to edit.. error...
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.


and could u help me configure the statement to display either tables..


this is the part i'm displayin the titles...once i click one of the titles... it will reach to another page sending out the title and the content of the title that you clicked..
<%
if session(&quot;cho&quot=&quot;posts&quot; then
obrs.Open &quot;SELECT * FROM posts WHERE postID=&quot; & request.querystring(&quot;postID&quot, obconn
end if
%>

<%
if session(&quot;cho&quot=&quot;ListFiles&quot; then
obrs.Open &quot;SELECT * FROM ListFiles WHERE UploadID=&quot; & request.querystring(&quot;listid&quot, obconn
end if
%>

<%
if session(&quot;cho&quot=&quot;favourites&quot; then
obrs.Open &quot;SELECT * FROM favourites WHERE favID=&quot; & request.querystring(&quot;favID&quot, obconn
end if
%>

<%
if session(&quot;cho&quot=&quot;minutes&quot; then
obrs.Open &quot;SELECT * FROM minutes WHERE minID=&quot; & request.querystring(&quot;minID&quot, obconn
end if
%>



this is the part..where u display the title and the contents but i'm not quite sure how does it work when u want to select another table and display it.. i got only one table able to display.... so whuts my problem here?



<%=obrs(&quot;title&quot%>

 

[LV]

How do you send the &quot;title&quot; to the processing page? According to your code all of the tables you query (posts, ListFiles, favourites and minutes) based on the value of session(&quot;cho&quot variable, must have a field called &quot;title&quot;.

 

[psyren]

actually this is the displayin page..... the processing page me never paste in here..... dat field title is the textfield's name



how do u display and select a table to display title.....then after that...u can click on the title.....it will display its title with the content of that title in another page?

that is my actual prob....