|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 24th, 2000, 11:58 AM
|
|||
|
|||
|
Simple Search Form
<i><b>Originally posted by : Charles (cjanco@mindspring.com)</b></i><br />I have an ASP problem that I am desparate for help with. I need a simple search form that searches on the <br />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 <br />with the part number field! The part number field is made up of text and numbers that vary in length. Its located in <br />my Access database. I get the message "either BOF or EOF is true or the current record has been deleted.<br />Can you tell me what I am forgetting. <br /><br /><!-- #include file="db.inc" --><br /><br /><html><br /><br /><%<br />partnumber = request.form("partnumber")<br /><br />strSQL = "select partnumber, producttagline from webproducts where partnumber = ' " & partnumber & " ' "<br />Set objRS = objConn.Execute(strSQL) <br /><br />Response.Write objRS("producttagline")<br /><br />objRS.Close<br />Set objRS = Nothing<br />objConn.Close<br />Set objConn = Nothing<br />%><br /><br /></html><br /><br />Thanks!<br /><br />Charles<br />714-413-8170
|
|
#2
March 24th, 2000, 01:34 PM
|
|||
|
|||
|
<i><b>Originally posted by : steve</b></i><br /><br />1st thing is to do in debugging this stuff is to use either access query designer or sql query analyzer to get a sql string you know returns record(s). then copy and paste that into your asp page to see if the same record comes back. Good luck...<br />you code looks right.<br /><br />------------<br />Charles at 3/24/2000 9:58:58 AM<br /><br />I have an ASP problem that I am desparate for help with. I need a simple search form that searches on the <br />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 <br />with the part number field! The part number field is made up of text and numbers that vary in length. Its located in <br />my Access database. I get the message "either BOF or EOF is true or the current record has been deleted.<br />Can you tell me what I am forgetting. <br /><br /><!-- #include file="db.inc" --><br /><br /><html><br /><br /><%<br />partnumber = request.form("partnumber")<br /><br />strSQL = "select partnumber, producttagline from webproducts where partnumber = ' " & partnumber & " ' "<br />Set objRS = objConn.Execute(strSQL) <br /><br />Response.Write objRS("producttagline")<br /><br />objRS.Close<br />Set objRS = Nothing<br />objConn.Close<br />Set objConn = Nothing<br />%><br /><br /></html><br /><br />Thanks!<br /><br />Charles<br />714-413-8170
|
|
| Viewing: ASP Free Forums > Programming > ASP Development > Simple Search Form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
