|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: forms and DBs |
|
From: |
Harlan |
|
Date: |
2/11/1999 9:28:28 AM |
|
IP: |
206.222.20.2 |
your select is FINE, it WILL return your recordset matching your search.
`just going to finish up your code to make
`sure you had it all finished up on your page.
strSearch = request.querystring("New Search")
set connTemp = server.createobject("adodb.connection")
connSearch.open "DSN=estinet1;uid=sa;pwd="
sqlSearch="select * from ITEM where description like `%" & strSearch & "%`"
`run the query
set rsSearch = connSearch.execute(sqlSearch)
if rsSearch.EOF and rsSearch.BOF Then
response.write "No records found matching your search."
Else
Do While Not rsSearch.EOF
response.write "Description: " & rsSearch("Description")
`Im just writing out the only field I can see
`for sure you have in your database. :)
Loop
End If
`clean up objects
set rsSearch = Nothing
connSearch.close
set connSearch = Nothing
NOTE: remember ` should be single quotes. |
Previous Message
Follow Up - Re: forms and DBs - Paul Aquino 2/11/1999 9:31:23 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
