navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

code to use to display Searched by Keyword:

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> code to use to display Searched by Keyword:
Page: [1]
 
rbucklin

 

Posts: 19
Joined: 5/30/2003
Status: offline

 
code to use to display Searched by Keyword: - 4/5/2008 11:11:47   
I am trying to find the code to use to display on the search results form the keyword that a user typed in to locate results in an access database search for example

If I type in GU to find a record it would be displayed the results below

Searched by Keyword: gu


I currently use the code below to display the number of records found.

Search Results <%=fp_iCount%> Record(s) Found </font></b>

and it would display

Search Results
31 Record(s) Found

You help would be appreciated
Spooky

 

Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: code to use to display Searched by Keyword: - 4/5/2008 19:24:41   
The keyword would be entered via a form?
If so, you would need to use the form input name.
youll find this in the SQL string like so : Select * from table where column = '::inputname::'

Use this on the search page like so : Searched by Keyword: <%=Request.form("inputname")%>

(in reply to rbucklin)
rbucklin

 

Posts: 19
Joined: 5/30/2003
Status: offline

 
RE: code to use to display Searched by Keyword: - 4/5/2008 23:49:00   
Spooky,

I added the code to my form and it worked.

Thank you,

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> code to use to display Searched by Keyword:
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts