Forums
This topic is locked
HELP: WHERE LINK_APPROVED = Yes
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