---
title: "Sökmotor med tillägg"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/8928-sökmotor-med-tillägg"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Lazerzubb"
published: "2001-04-09T08:29:00.000Z"
updated: "2001-04-09T18:25:00.000Z"
replies: 2
views: 242
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/8928-sökmotor-med-tillägg"
---

# Sökmotor med tillägg

## #1 — Lazerzubb, 2001-04-09T08:29Z

Jag har en sökmotor KODEN 
//
\<!-- #include virtual="/land/adovbs.stm" --\>
\<%	Set Connect = Server.CreateObject("ADODB.Connection")
	Connect.Open "driver={Microsoft Access Driver (\*.mdb)};dbq=D:/clients/xxx/wwwroot/databas/search.mdb"
If Request.Form("fsearch") \<\> "" Then
SQL = "SELECT \* From search1 WHERE country LIKE '" & Request.Form("fsearch")& "%' OR province LIKE '" & Request.Form("fsearch")& "%'OR city LIKE '" & Request.Form("fsearch")& "%'"
set rs=Connect.Execute(SQL)

if not rs.eof then
do until rs.eof
%\>\<a href="detail.asp?id=\<%=rs("ID")%\>"\>\<%=rs("country")%\>,&nbsp;\<%=rs("province")%\>&nbsp;\<%=rs("city")%\>&nbsp;\</a\>\<br\>\<%=rs("bedf")%\> Fullsize bed's,&nbsp;&nbsp;\<%=rs("xbed")%\> Extra bed's\<br\>
Price High:&nbsp;\<%=rs("high")%\>, Low:&nbsp;\<%=rs("low")%\>\<br\>\<BR\>
\<%rs.movenext
loop
end if
else
%\>Dident find any house's in the country/City\<%
end if

rs.close
set rs=Nothing
Connect.close
set connect=nothing

%\>
// 
men jag vill att man ska typ kunna söka 
Sverige +Lund
Bara med + Inget annat.

Permalänk: https://www.webforum.nu/p/8928

## #2 — emission, 2001-04-09T16:41Z

<http://cgi.webforum.nu/wf/Forum11/HTML/000405.html>

Permalänk: https://www.webforum.nu/p/262876

## #3 — Rossifumi, 2001-04-09T18:25Z

Fan emission, den rockar ju fett :)

Lazerzubb \>\> 

> Dident find any house's in the country

Borde det inte stå **Didn't** :q

Permalänk: https://www.webforum.nu/p/262877

---

Tråden på webben: https://www.webforum.nu/amne/asp/8928-sökmotor-med-tillägg