🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #252

Re: Problems using ASP with MS Access

#252
From: Richard Richards
Date: Fri, 05 Dec 1997 00:00
40 lines
2217 bytes
If your form only has three fields in it then where are the other requests
coming from? Post the entire asp file and we will try to figure out what the
problem may be. I know you can do what you want, I have done it before
myself.

---------------
Richard Richards
rdrrinc@novagate.com

>
><% strNavn = cStr(request.form("navn"))
> strAdresse = cStr(request.form("adresse"))
> strPostnummer =  cStr(request.form("postnummer"))
> strBy = cStr(request.form("by"))
> strTelefonnummer = cStr(request.form("telefonnummer"))
> strFaxnummer = cStr(request.form("faxnummer"))
> strEmail = cStr(request.form("email"))
> strWeb = cStr(request.form("web"))
> strKommune = cStr(request.form("kommune"))
> strAmt = cStr(request.form("amt"))
> strLand = cStr(request.form("land"))
>
>set  ObjConn=Server.CreateObject("ADODB.Connection")
>ObjConn.open  "Opencities"
>
>SQL = "SELECT * FROM Samarbejdspartner WHERE Samnavn LIKE '%" & strNavn &
>"%' AND Postnummer LIKE '%" & strPostnummer & "%'  AND Adresse LIKE '%" &
>strAdresse & "%' AND By LIKE '%" & strBy & "%' AND Tlf LIKE '%" &
>strTelefonnummer & "%' AND Fax LIKE '%" & strFaxnummer & "%' AND E-Mail
>LIKE '%" & strEmail & "%' AND WEB LIKE '%" & strWeb & "%'  AND Kommune LIKE
>'%" & strKommune & "%' AND Amt LIKE '%" & strAmt & "%' AND Land LIKE '%" &
>strLand & "%' ORDER BY Samnavn, By"
>
>---------------------------------------------------------------------------
-
>
>----
>My HTML form has 3 fields: "navn", "postnummer", "by"
>
Technical Details
Message-ID: <667ot0$8di$0@205.138.138.102>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bcfdd4$a0750950$40c0e482@ns>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10779a,3256b8a733bfbea9
X-Google-Attributes: gid10779a,public
X-Google-Thread: ff0ac,3256b8a733bfbea9
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fa6f6,3256b8a733bfbea9
X-Google-Attributes: gidfa6f6,public
From: "Richard Richards" <rdrrinc@novagate.com>
Subject: Re: Problems using ASP with MS Access
Date: 1997/12/05
Message-ID: <667ot0$8di$0@205.138.138.102>
X-Deja-AN: 295342037
References: <01bcfdd4$a0750950$40c0e482@ns>
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Reply-To: "Richard Richards" <ensign@novagate.com>
Newsgroups: comp.databases.ms-access,dk.edb.programmering,microsoft.public.access