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:
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.
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:
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.
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?
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?
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?
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.
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.
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?
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:
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.
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?
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.
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.
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?
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 "@"?
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??
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?
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
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:
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
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.
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.
