code to use to display Searched by Keyword: (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


rbucklin -> 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 -> 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")%>




rbucklin -> 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,




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
4.589844E-02