|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
