Dispaly Results, Then Highlight Closest Matched Row ASP.NET/ADO.NE
I have created an ASP.NET page that allows the user to page through a result
set. I need to expand on this. On that same page I a filed where the user can
type in a search string. When they click a button ALL the results will be
returned and the closest match to the search string will be highlighted. The
approach I am taking to page the data is to put the keys/indexes into an
array then create another data reader based on those results to display the
actual data. There may be a better way, if there are any suggestions.
Bottom line I need to find what page the search string is on so I can
highlight it. I guess I would have to calculate what page that record is on,
but I can’t wrap my head around it. Here is some code that I use for the
paging: Code:
View Replies
ADVERTISEMENT
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.
View Replies
View Related
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:
View Replies
View Related
i've made a calendar that uses newsitems from an access database.
Every newsitem is a record (newsID, date, title, fact).
When the page is loaded for the first time a visitor looks at that page, I want to set the calendar to the newsitem that is closest to the present, but lying in the past. So, today we are the 13th of October. In the database, i've got two items with date "the 2nd of October" and "the 25th of September". The query should return me the 2nd of October. Of course, when that newsitem did not exist, then the query should return me the 25th of September.
View Replies
View Related
I'm building a 'spot the ball' gaming site where people choose a point on an image closest to where the ball should be. This works in Flash by assigning co-ordinates to that point.
However, I need to do a database look-up when the competition is over, to see who has the closest point. I'm hoping to build an ASP application that will enable the administrator to enter the correct co-ordinates, then click a button to find the closest entry in the database. I can't think of an accurate automated way to do this. Has anyone built anything similar? What would be the best way to achieve this?
View Replies
View Related
let's say that I want to highlight some words or even a square of a table in yellow...how would i go about doing that? What code would work to do what I need?
View Replies
View Related
currently doing a wep application that contain of search engine. i did browse through some web applciation's search engine, notice that they can highlighted the keywork for searching when they display the search result.
example,
when i enter keyword 'test' in my search engine and preform search, let say i found a file called testing.asp, i want the word test to be highlighted. may i know how can it be done?
View Replies
View Related
I can't figure this out. I need to make an array and highlight strFind: Code:
View Replies
View Related
There is something wrong in this. I couldn't figure it out.
I have three: Keyword, Keywordb, Keywordc
I had inserted: strSearchFor, two, three (same function)
Code:
View Replies
View Related
Is there a way using VbScript or Javascript to have an imagemap highlight on a mouse over event? Doesn't matter if it highlights the entire imagemap area or just outlines it, but I need a way to indicate that the user is over a spot other than just a cursor change.
View Replies
View Related
wondering if its possible to have some kind of searched word highlight! IE. every thing it throws up in return of search it will highlight why it has brought it up! so if search "a" all "a" in return results would be highlighted.
View Replies
View Related
All the HTML contained within the <BODY> tags is contained within a DB I have for a CMS. I have 2 pages... CURRENT_LIVE and LAST_UPDATED... I want to compare the content of both and highlight the changes... is this possible? if so, how?
View Replies
View Related
how to highlight the search text on the asp page when its displayed after being fetched from database[using LIKE]
any vbscript technique?
View Replies
View Related
This code highlights words entirely. I look for the word nation it highlights words like abomination. So I only want the function to highlight whatever I'm looking for. Code:
View Replies
View Related
Im doing a text search, and i need to highlight the word which is being searched for in the results page. How do i do that?
View Replies
View Related
I'd like to add to my search function of my asp site the possibility to highlight in the result pages all the words searched.
View Replies
View Related
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
View Replies
View Related
I have a project on making a UI of a Web page that allows users to:
1. select any text by highlighting it, and
2. do some action on it by right-clicking on the highlighted text and choose an action among those options presented by the context menu items that appears.
3. send the chosen action along with the text and its attributes to the server as the user clicks on the desired menu item.
Interestingly, the next stage is to make the menu items customised by the type of the selected text, e.g. a link or an ordinary body text. Does anyone know if all these can be done fully using ASP.Net at the server side?
View Replies
View Related
I understand that this forum uses some sort of cookie system to detect which threads have been read by users. I am trying to accomplish the same thing. My thought is to have a cookie with two keys: one with the last activity of the user, and the other with the posts that have been read.
Now, the only problem, is that I more than likely will need to update these reads threads based on a date/timeframe criteria, correct? Has anyone wrote one of these? In my threads table, I have a column named 'forumLastPostID' for each thread.
View Replies
View Related
I am new in asp. I have two html files. I like to write
code to compare those two files. I like to show the
difference as highlighted area.
Example: File 1 contains:
<html><body> Compare Test</body></html>
File 2 contains:
<html><body> Compare Test modyfied</body></html>
I like to make either the word "modyfied" highlighted or
the whole line highlighted on File2.
View Replies
View Related
How do I highlight a split function text?
code ....
View Replies
View Related
I have an ASP search function which, after typing the search term, searches HTML pages and creates a list of links.
The problem is that I do not know how to code so the search term is highlighted in red after the user clicks on the link to view the HTML page.
View Replies
View Related
Anybody know how to get only the 10 latest results of an SQL query ?(in SQL)
View Replies
View Related
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?
View Replies
View Related
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 "@"?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related