Forums

This topic is locked

HELP: WHERE LINK_APPROVED = Yes

Posted 03 May 2002 06:04:04
1
has voted
03 May 2002 06:04:04 Bob Vigen posted:
Im trying to filter results according to wether or not the link is aproved, there is a checkboxfield in the database, but I cant figure out where and how to place the WHERE LINK_APPROVED = Yes filter in this query configuration.

<%
varWhereString = "WHERE LINK_ID <> -1 "

IF Request("selCat" <>"" Then
AndCatString = " AND CATEGORY LIKE '%" & Request("selCat" & "%'"
Else
AndCatString = ""
End If

IF Request("selCity" <>"" Then
AndCityString = " AND CITY LIKE '%" & Request("selCity" & "%'"
Else
AndCityString = ""
End If

IF Request("txtKeywords" <>"" Then
AndtxtKeywordsString = " AND LINK_NAME LIKE '%" & Request("txtKeywords" & "%' OR LINK_DESC LIKE '%" & Request("txtKeywords" & "%' OR KEYWORDS LIKE '%" & Request("txtKeywords" & "%'"
Else
AndtxtKeywordsString = ""
End If

varWhereString = varWhereString & AndCatString & AndCityString & AndtxtKeywordsString & " ORDER BY ORDER_DATE ASC"
%>

I have tryed placing it in the where string and after the recordset, but wont work, do u know how and where to place it? please give me a hand.

Thanks
Bob

Reply to this topic