Article View: comp.databases.ms-access
Article #252Re: Problems using ASP with MS Access
From: Richard Richards
Date: Fri, 05 Dec 1997 00:00
Date: Fri, 05 Dec 1997 00:00
40 lines
2217 bytes
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-mailReferences:
<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