Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Hide records from search lists?

Quote Reply
Hide records from search lists?
I am building av database where records have to be "approved" before they are displayed for users. It shal be possible to add new records and browse "approved" records when not logged in.

I have a field with a default value "na", and this is changed to "ap" when reviewed by an administrator.

How can I do this, and be sure that no "not approved" records is displayed?

Kjetil
..........................
Kjetil Palmquist
www.svanger.com
Quote Reply
Re: [kjetilpa] Hide records from search lists? In reply to
Hi,

You should modify search_results.html, it should be:
....
<%loop results%>
<%if approved_field_name eq 'ap'%>
<p><%Dbsql::HTML::generate_search_results%>
<%endif%>

<%endloop%>

TheStone.

B.

Last edited by:

TheStone: Mar 14, 2002, 12:15 PM
Post deleted by kjetilpa In reply to
Quote Reply
Re: [TheStone] Hide records from search lists? In reply to
Thanx, this was very helpful.

Kjetil
..........................
Kjetil Palmquist
www.svanger.com