arrWords=split(request.querystring("q")," ")
strWhere=""
for each strWord in arrWords
if strWord<>"" then
if strWhere<>"" then strWhere = strWhere & " AND "
strWord=replace(strWord,"'","''")
strWhere= strWhere & " (productItemId LIKE '%" & strWord & "%' OR " &_
" design LIKE '%" & strWord & "%' OR " &_
" smalldesc LIKE '%" & strWord & "%' OR " &_
" productTypeID LIKE '%" & strWord & "%' OR " &_
" productCategoryID LIKE '%" & strWord & "%' OR " &_
" catalogID LIKE '%" & strWord & "%' OR " &_
" name LIKE '%" & strWord & "%')"
end if
next
if strWhere<>"" then strWhere = " WHERE " & strWhere
sql = "SELECT * FROM productItem " & strWhere & " order by " & sortBy & " ASC"
Frågan#1
hejsan,
jag kor en sokning via method=get... och nar jag soker pa ngt med 2 ord dvs fonster ruta sa ser urlen ut pa foljande vis sokning.asp?q=fonster+ruta vilket e forstaligt...
i min databas har jag fonster i en kolumn och ruta i en annan kolumn hur kan jag mha denna sokning hitta posten som stammer overens med fonster ruta, om de tva orden finns i varsin kolumn?
just nu ser min query ut pa foljande vis:
sql = "SELECT * FROM productItem WHERE " &_
" productItemId LIKE '%"&request.querystring("q")&"%' OR " &_
" design LIKE '%"&request.querystring("q")&"%' OR " &_
" smalldesc LIKE '%"&request.querystring("q")&"%' OR " &_
" productTypeID LIKE '%"&request.querystring("q")&"%' OR " &_
" productCategoryID LIKE '%"&request.querystring("q")&"%' OR " &_
" catalogID LIKE '%"&request.querystring("q")&"%' OR " &_
" name LIKE '%"&request.querystring("q")&"%' order by "&sortBy&" ASC"
men det funkar inte for 2ord? for ett ord ar det inga problm med 2ord eller 3ord???