|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Simple Search Form |
|
From: |
Charles |
|
Date: |
3/24/2000 10:53:18 AM |
|
IP: |
165.121.120.172 |
I have an ASP problem that I am desparate for help with. I need a simple search form that searches on the
part number for a company. I am able to set it up so it works with the auto number field but cannot get it working
with the part number field! The part number field is made up of text and numbers that vary in length. Its located in
my Access database. I get the message "either BOF or EOF is true or the current record has been deleted.
Can you tell me what I am forgetting.
<!-- #include file="db.inc" -->
<html>
<%
partnumber = request.form("partnumber")
strSQL = "select partnumber, producttagline from webproducts where partnumber = " & partnumber & " "
Set objRS = objConn.Execute(strSQL)
Response.Write objRS("producttagline")
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
</html>
Thanks!
Charles
714-413-8170 |
Follow Up - Re: Simple Search Form - Ricardo Londe 3/24/2000 1:26:56 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
