SQL Query Error ( 2 field values into 1 Query )

[Fary4u]

Hi

i'm trying to figer it out how to do take 2 value from table & set into SQL Query

i've got database table with name " TABLE -> PRODUCT" & " FIELD -> TYPE "

here is the code

res = Request.form("res")
res2 = Request.form("res2")

chkres = " and products.type = '" &res&"'"
chkres2 = " and products.type = '" &res2&"'"

strchk = " chkres & chkres2 "

sqlText = "select distinct(products.productID), "
sqlText = sqlText & "products.producttype "
sqlText = sqlText & str1 & str2 & strchk

some thing like this how can i take 2 value & execute this.

Thanks in advance
Fary

[Fary4u]

Is that possible we take 2 or 3 true values from 1 DB Field ?
& Run with SQL Query ?
Here is the complete code
[PHP]
<%
( in Database Filed as a Type - Residential, Commerical or Other )
chkres = Request.form("chkres") ' Resident Checkbox
chkcom = Request.form("chkcom") ' Commercial Checkbox
chkoth = Request.form("chkoth") ' Other Checkbox

( in Database Category_ID - Sale or Tolet )
strCat = Request.form("strCat") ' Category Radio Button

if chkres = "yes" then
chkres = "Residential"
end if
if chkcom = "yes" then
chkcom = "Commercial"
end if
if chkoth = "yes" then
chkoth = "Others"
end if

strCatWhere = " and property.category_ID = '" &strCat&"'"

strChk1 = " and property.Type = '" &chkres&"'" ' Check box options
strChk2 = " and property.Type = '" &chkcom&"'" ' Check box options
strChk3 = " and property.Type = '" &chkoth&"'" ' Check box options
strchk = strChk1 & strChk2 & strChk3


set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString

sqlText = "select distinct(property.property_ID), "
sqlText = sqlText & "Property.Image ,"
sqlText = sqlText & "Property.Type, "
sqlText = sqlText & "Property.price "
sqlText = sqlText & "from property "
sqlText = sqlText & "where property.property_ID = "
sqlText = sqlText & "property.property_ID"
sqlText = sqlText & strCatWhere & strchk '( strChk1 or strChk2 strChk3)
%>
[/PHP]

[Fary4u]

is that possible take 2 value from table filed & set into SQL Query
i've got database table with name " TABLE -> PROPERTY" & " FIELD -> TYPE " holding value with following:

in Database Filed as a Type - Residential, Commerical or Other
in Database Property_ID - Sale or Tolet

& Run with SQL Query ?
Here is the complete code
[PHP]
<%
( in Database Filed as a Type - Residential, Commerical or Other )
chkres = Request.form("chkres") ' Resident Checkbox
chkcom = Request.form("chkcom") ' Commercial Checkbox
chkoth = Request.form("chkoth") ' Other Checkbox

( in Database Property_ID - Sale or Tolet )
strCat = Request.form("strCat") ' Category Radio Button

if chkres = "yes" then
chkres = "Residential"
end if
if chkcom = "yes" then
chkcom = "Commercial"
end if
if chkoth = "yes" then
chkoth = "Others"
end if

strCatWhere = " and property.category_ID = '" &strCat&"'"

strChk1 = " and property.Type = '" &chkres&"'" ' Check box options
strChk2 = " and property.Type = '" &chkcom&"'" ' Check box options
strChk3 = " and property.Type = '" &chkoth&"'" ' Check box options
strchk = strChk1 & strChk2 & strChk3


set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString

sqlText = "select distinct(property.property_ID), "
sqlText = sqlText & "Property.Type "
sqlText = sqlText & "from property "
sqlText = sqlText & "where property.property_ID = "
sqlText = sqlText & "property.property_ID"
sqlText = sqlText & strCatWhere & strchk '( strChk1 or strChk2 strChk3)
%>
[/PHP]
line 22 with OR is work fine but i need to including every thing.
[php]
strChk1 = " and property.Type = '" &chkres&"'" ' Check box options
strChk2 = " or property.Type = '" &chkcom&"'" ' Check box options
strChk3 = " or property.Type = '" &chkoth&"'" ' Check box options
strchk = strChk1 & strChk2 & strChk3
[/php]

[jhardman]

are the two always going to be in the same order? if so, you could say:

"SELECT * FROM products WHERE type LIKE '%" & res & "%" & res2 & "%'"

If not, you could say,

"SELECT * FROM products WHERE type LIKE '%" & res & "%" & res2 & "%' OR type LIKE '%" & res2 & "%" & res & "%'"

Let me know if this helps.

Jared