ASP :: Search Results Looking In More Than One Field

Search Results
I have 5 checkboxes and submit button for saerching database if the user wanna know what's the courses they can choose for the semesters. here is the html code for front-end:

Code:
<form action="result.asp" method="get">
<input type="checkbox" name="course" value="cos101"> cos101 <br>
<input type="checkbox" name="course" value="cos102"> cos102 <br>
<input type="checkbox" name="course" value="cos103"> cos103 <br>
<input type="checkbox" name="course" value="cos104"> cos104 <br>
<input type="checkbox" name="course" value="cos105"> cos105 <br><br>
<input type="submit">
</form>

Search Results
When I client does a search product on my website it display all the results in one page. Which code can I use to tell how many results to display per page and from the result how many pages are?

Search Results
What do you call it when search results are broken up into page numbers across the bottom? I want to try that instead of getting a long list of results. I was going to search but none of the terms I tried returned anything.

Search Results
I have a page with a list of links that when clicked submit data to a clients search engine, The result opens in another window and either displays a list of items or diaplays "No Items Found".

I want to perform another action in my Asp Page if the result is "No Items Found"
Can I get my Asp page to read the result from the search engine when it's results are returned in another window or would i have to return them into a frame?

Filtering Search Results
anyone have any tips on creating a search results filter to provide the best
matches first? we're using an access database as part of a very small custom
CMS, and we need to site search function that doesnt just output any base
matches for a given term.

Searching Results From A Search
I have a mdb file with the fields Country, Name, Date. The data when filled out would like like this

Australia - John - 21/7/02
Australia - Bill - 22/7/02
Australia - wendy - 23/7/02
Usa - Geoff - 23/7/02
Usa - Bill - 23/8/02

What i need to do is a search on the name "Bill" but only search on the latest records added to the database for each Country (by date) and return a result that matches "Bill".

I currently have a search set up that does an outter and inner search but it searches for anything matching "Bill" and then returns the latest records for anything that its matched (so i get results for Australia because its found a bill record but it displays the latest record for wendy)

Paging Search Results In ASP
Hey I keep getting this error when i try to use paging in asp for my search results. Error: "Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype." I have read a number of different websites to try and fix the problem but none of the solutions seem to work. Code:

Highlight Search Results
I currently have a working search w/highlighted results page. My problem is that there is HTML stored in the text that is being searched and whenever the searched keyword is within HTML, it throws off the rest of the page.
I would happily throw away my code and use another if I could get it to check for things like <> and avoid breaking them. Ideally what I tried to do was display approximatly 10 words on either side of the highlighted keyword, just to give it some context, but I have thus far failed to get this to work properly.

Ranking Search Results
I'm wondering how I can rank search results based on how close the result is to the search term. For example, I have a database that includes a field for position title. When a user searches for the title "President", they are shown a list of everyone with the word "President" somewhere in their title.

However, I want to show the records for the presidents above the records for the vice presidents. So I guess I should say that I want to show exact matches first, then loose matches afterwards. Can anyone tell me how to get started on this?

Sort The Results Of A Search
I am trying to sort the results of a search. The SQL statement looks like this:

strSQL = "SELECT * from DVDTable WHERE [Category] = '"&searchCat&"' ORDER BY '"&by&"' " & order

The output of strSQL is as follows:

SELECT * from DVDTable WHERE [Category] = 'Action' ORDER BY 'Rating' asc

Not sure what the problem is but the results do not get sorted.

How To Limit Search Results
I have web page that returns all the entries from a table in the database. the web page becomes bigger and bigger as the database is expanded. how do i limit the results such that only 15 rows are dispalyed per page and the user will be able to go to the next page to view the next entries? .....

Refining Search Results
I have an asp results page that returns results depending on their search criteria.I'd like to give them the option of clicking on check boxes in order to narrow down their results.

Do I put the <form> tags outside these results?Because if it returns many results,will it work if each result has the same select name?

Displaying ASP Search Results Issue
Well I was able to build a simple search page, that would search a database and give the results on the restuls page from the criteria on the search page....

However I am having a issue with the data that's shows in the results. I'm getting the ID Column of the table in stead of the Column with the names. Eg:

<%=(births.Fields.Item("DName").Value)%>

Is there a way to change the data to be displayed to another column?

Search Two Tables And Display Results
I have two tables like this:

TapeRecords

TapeID - Integer Primary key
Title - Text

TapeDetails

RecordId (Primary Key)
TapeId (related to the taperecords table)
ProgramDetails (Text)

The tape details table has a record of the programs that are stored on each
tape and each tape we have about 20 programs.

What i want my users it to allow them to search by programdetails and
display the list of tapes that match that search. I am not able to built a
query to search and display at the same time.

Divide Search Results Into 2 Or More Pages
At the moment, I'm working on search engine based on several crtierias. Upon submiting their query, the system will then compare the values entered with the DB and return the search results. Those search results are displayed in a table and users are able to print out that search result page for reference.

However my problem now is if there are more than say 4 search results, though they can view it on screen, they cant print out the whole table! The table will be cut into 2, leaving the rest of the data out. So I was wondering if I can program it in a way where if there is more than 4 rows, it will break into 2 tables. I've attached my files for references. Code:

Adding Counts To Search Results
I found this on the net but it shows that he is using one ASP page for both search and response. I need it for two pages. The first for HTML coding and the second (response page) with ASP coding. What do I need to modify? Code:

Highlight Search Word In Results
I have a little function to highlight text if it exists.

Function Highlight(vFind, vSearch)
Dim RegEx
Set RegEx = New RegExp
RegEx.Pattern = vFind
RegEx.IgnoreCase = True
Highlight = RegEx.Replace(vSearch, "<span class=""Highlight"">" & vFind &
"</span>")
Set RegEx = Nothing
End Function

The only problem is, that if I search for "something", "something" appears
highlighted when the string being searched actually contained "Something".

This is not about case sensitive searching, this is about showing the actual
match rather than what was being searched for. Code:

Search Records And Get Results On Same Page
how to create a search option that would search the recordsets in my database table.

I would be allowing users to search by name or date. I'd like the results in the same page. Any suggestions or tutorials?

Creating Search And Results Page
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.

Show Search Results In IFRAME
How can I force to show search results in IFRAME? The search-form is part of many pages of my website separated from the result page. Search works fine but opens a new window.

<form name="search" method="post" action="/search.asp">
<input type="hidden" name="action" value="dosearch">
<input type="hidden" name="offset" value="0">
<input type="hidden" name="allwords" value="1">
<input name="words" type="text" size="13" maxlength="90">  <a target="iframe" href="/search.asp"><img src="/pics/lupe.gif" width="18" height="18" alt="" border="0"> </td>
</form>

Asp Search Returns No Results From Access Query
here's what i want to do. from an asp page, perform a search on a
table in access. i have used sql code in the asp page itself, but i'd
rather execute a query in access. i have success in running any query
(basic SELECT, SELECT with conditions _other_ than LIKE, etc..) for
some reason, when i execute the query below from the asp page, i get
no results.

the search.asp page just has a text box in a form that submits the
srchBOX field to the results.asp page.

here's the asp code from the results.asp page: Code:

MS Visual Interdev 6 - Search Mode With Results Explorer?
When searching through code in Vis. Interdev 6, when in the Find
dialog, it listed the results in the results pane below. The cursor
didn't change position to the next found item until you clicked on a
line in the results.

This is actually a nice feature that I haven't seen before -
all the matches show up at once in a list,
with a column containing the text for the line the string was found
in, so you can quickly see the context of the match.

Anyway, the first couple times I used CTRL-F, I saw a results pane.
Then I must have changed something without realizing,
because now when you search, no results appear in the results pane,
but the cursor moves in the editor window. This is the behavior I am
used to with Vis Studio 6, but I would prefer to turn the results
pane back on.

Asp Search Field Problem
I've had a site built for me but the programmer got on my tits for a variety of reasons - I know nothing about databases and need someone to help me sort out a fairly simple problem with two search fields.

(URL address blocked: See forum rules) is a site that will offer users the ability to sell and swap books online but the second and third search fields on the home page are returning no results.

Multiple Field Search
how to search multiple fields in an access database?Basically I want the code to search an entire table, field irrelevant.While I'm at it, does anyone know how to make the same search not care about word order or placement?

Such as:
Search string: "John went to the store"

returns the same results as

Search string: "The store went to John"

Just thought I would throw these out there and see what direction anyone can lead me.

Two Field Date Search
I'm trying to create a search page with a beginning and ending date, but I can't seem to get it to work. I am using SQL Server. Here is my statement:

SELECT *
FROM dbo.REQUEST2
WHERE REQUEST_DATE BETWEEN ' " & Request.Form("txtBeginDate") & " ' AND ' " & Request.Form("txtEndDate") & " '

This statement is not returning any records when I know there are existing records that fit the criteria that I'm entering.

Search A Date Field
I have a form where I offer the user to enter a 'fromDate' and a 'toDate' whereby I had hopes that it would help return records where the date was between those two values. My SQL query ends with: Code:

AND Date < " & request("fromDate") & " AND Date > " & request("toDate") & "
and a typical date entry in the table looks like: 2/8/2005 .

How To Search A Database Field From Form Input
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen

i have 2 tables related to each other
contact table
id, fname, lastname, contactid, email

zip table
id, zip, contactid, city

How To Search A Database Field From Form Input?
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen

i have 2 tables related to each other:

contact table id, fname, lastname, contactid, email

zip table
id, zip, contactid, city

Problem With Dropdown Menu In Search Field
I have an access db called boards and a table in it called notes. I have 3 fields in the table ID, subject, and notes. I have code to search the db and display the results in the notes field.. This code works very well. I wanted to modify this code so that I can use a dropdown menu instead of type in the search field but i cannot get the dropdown menu code to display the search results. Code:

LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause
I am using a Relational database for my site and i have the following tables:

FIXTURES, GAMEDATES

the fields in FIXTURES are:

GameDate
Home
Away

(All of the above are numerical fields)

the fields in GAMEDATES are:

DateID(integer)
GameDate(#Date Field#)

What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)

The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:

WHERE Fixtures.GameDate<=(Date())

obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.

The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.

Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data

Comparing Field Data From Previous Field
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData

This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?

Fill Field Based On Another Field
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.

I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.

I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).

Pass Hidden Form Field Value To Another Form Field To Insert In Db
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.

(The hidden value (1 for example) would then automatically get passed to the
other input field.)

The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:

How Can I Change One Line Input Field Into Larger Input Field
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.

All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:

SQL 10 Last Results Only
Anybody know how to get only the 10 latest results of an SQL query ?(in SQL)

Stripping Results
i have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?

Trimming Db Results
i don't know what to do here exactly.
i have seen the TRIM function, but i'm not sure if it's the right way to do it.
i have a recordset called RSUSEREDIT.
in the recordset there is a column called "EMail".
i can print out the results using Code:

<%=RSUSEREDIT("Email")%>

the email column always uses the same domain name... - username@domain.com
is it possible to remove the part after and including the "@"?

Results Of URL To File
I have a URL... everything returned by the url, I need to write to a file. lets say its 40 lines of text... how can I write it to a text file and save it??

ADODB stream?
FSO?
DomObject?

Seperating Results
I'm creating a site that pulls details from a database & display it on screen. Problem is that there's sometimes loads of data which makes the page huge. What I want it to do is display ten and a next page link to display the next ten. Like the way Google displays results. Problem is I don't know how to generate pages on the fly. So the question is can it be done and does ne1 know how to do it?

Filtering Results
First, thanks to all who have helped me over the last few weeks !!
I have a form that allows the user to select multiple options.
These are user names:

Fred S
Bob D
Paul G
Dave O

When the form is submitted, I'm getting the details using

user = request.form("user")

this is returning the mutliple options.
What I would like to do is pass all the options to 'user' but at one
point on the results page only show the first user selected, not the
multiple selection

Ordering Results
what is an easy way to go about sorting my search results through links, you know, like clicking the link at the top of a column. i know how to pass the order by in a querystring:

http://www.example.com?lastname=smith&firstname=john&state=GA&orderlast=desc

where orderlast is the order querystring.

but what about all the other links? what do I do with the previous querystring entries like lastname, firstname, and state? i find if i add orderlast to my lastname column and i click on it, i will have 2 orderlast querystrings

Recordcount Results
I'm using multiple recordsets on a page, and they are all returning correct results and enough of them. My problem is when I try to access the recordcount property rs.recordcount, they all return a result of -1. This would usually mean that no records are returned. So why is showing my recordsets that are displaying records with recordcounts of -1. I can't seem to figure out.

Display Results
what I need is to dysplay only the first say 10 results and then have a link 'next' and dysplay 10 more in a new page

result
result
result
result
...
next

I can create a var and add 1 more for each result, till 10ï¿½ end then create the link, but i don't now how to start the new page from the 11ï¿½ result.

Using Bbc Code With Results
I know how to display results that contain html code on a page. (ie. <br>
<b>...)

what i would like to know, is if a result contains bbc code (ie.. [code]
[url]..) how would i display that to be readable?

This is not for a forum, but would be the same as if i was writting a forum.
I think there is a script that the page has to contain to be able to read it
correctly, but I can't find it.

ASP Different Results In Firefox And IE !
I have following code, picking an ID and saving it to Cookies.

<%
ItemID = Request("prod")
Response.Cookies("THREES")(ItemID) = Request("prod")
Set rdset=objConn.Execute("SELECT ID, Name, Large, Description
FROM shop_products WHERE ID=" & ItemID)
%>

In IE it works fine as it should, adding item id to Cookies

In Firefox it gives me the following error:

Cookies object, ASP 0102 (0x80004005)
The function expects a string as input.
/shop/addcart.asp, line 27

Any information on that. Any idea what is going wrong.

Getting The Results From Executing An Exe
Is there any sample about getting the results from executing an exe using
asp?

Searching Results
I know how to use the LIKE command in a query but how do I do it in the
results of a recordset results="<b>Hello</b> World"

I want to search the above result and if it has a <B> in it, I want set
hasabold="Y"

I need to be able to search through a large amount of text so the BOLD marks
will not always be at the front of the results. They maybe be on line 50
character 59,

Fetch The Results
query = "SELECT table. * FROM table where table.lastname=" & lname

How can I fetch all the rows with the lastname field equals to lname variable?

Form Results
I have programmed several online forms(typically using cgi).A client of mine does not like how the results are formated (the long column of text)Is there anything I can do to program the results of this online form to get put into another format that would be e-mailed to the receipient?