|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: selecting text from a search |
|
From: |
Harlan |
|
Date: |
2/16/1999 3:30:37 PM |
|
IP: |
206.222.20.2 |
well, Im not sure what you mean by "send to a different database" but.. heres a bit of code send a querystring from one page to another via a recordset.
`you already have it doing this bit I assume.
set db = server.createobject("adodb.connection")
db.open("DSN=whatever")
set rsColumn = db.execute("select cmnOne from tblTable where cmnOne=stuff")
if rsColumn.EOF and rsColumn.BOF then
response.write "no items found."
else
do while not rsColumn.EOF
`here is the bit of code to "link" another page
response.write "<a href=anotherPage.asp?Item=" & rsColumn("cmnOne") & ">" & rsColumn("cmnOne") & "</a>"
rsColumn.MoveNext
Loop
db.close
---- now in anotherPage.asp -------
item = request.querystring("item")
`you can now use item as a variable in this page.
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
