homepage Welcome to WebmasterWorld Guest from 50.19.144.243
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Search app?
spanish chars, date sections, highlight keywords on results...
gutabo




msg:662689
 4:59 pm on Feb 13, 2004 (gmt 0)

Greetings,

We've been looking for a decent search app for our archive. We have a newsletter and we would like to be able to search within date periods(from xx/xx/****x to yy/yy/yyyy), to highlight the matched keywords, among other things like accept spanish characters (á, é, í, ó, ú, ń). Anyone knows an app capable of these?

Thanks in advance!

 

chris_jt




msg:662690
 11:23 pm on Feb 18, 2004 (gmt 0)

Try using a function that data can be passed into along with the search term. Use a regular expression to identify matching character patterns then wrap it in a style highlight. Have the function return the data with the matched patterns highlighted. It shouldn't matter what characters are submitted as the pattern.

iqbal




msg:662691
 1:59 am on Feb 19, 2004 (gmt 0)

Some suggested solutions.

I think your list is store in some database and if you already separated date of the messages in some different colum of the table , then you can use sql query to fetch the records for date range.

Other not so good but may work tip is to tag your email messages with xml, in your email list for example for your date yy/yy/yyyy

you can do the following :

<date>yy/yy/yyyy</date>

And with your application you can parse with XML parser and use some date function ,most programming have functions to compare dates and they will work.

This is not so good way of doing searches because as the search data grows the search will be slower and other problems also increase which is hard for me to explain here.

Hope this helps.

chris_jt




msg:662692
 2:52 am on Feb 19, 2004 (gmt 0)

Nah... it shouldn't get too much slower if you create agent jobs to do date range archiving and indexing. Base it on usual queries and you can keep things cranking for a long time. Yeah... archiving...
you can archive information considered "old" by whatever standard you might set... like 90 days for example. If a date range is outside of 90 days from the current date, then you can include "archived" data in the returned results. Otherwise... you simply ignore it... just a method of limiting information overload ;-)

Herenvardo




msg:662693
 10:41 am on Feb 19, 2004 (gmt 0)

accept spanish characters

If I'm not mistaken, Java chars are 16bit Unicode. This means that a Java String accepts spanish characters (and also chinesse and tibetan, for example ;))

I think your list is store in some database and if you already separated date of the messages in some different colum of the table, then you can use sql query to fetch the records for date range.

And if you didn't, you can do it now. You only need a sql selection query, a text parser and a sql table creation query. If you can export your db to MS access, you will be able to separate the date using a VBA function. I have not worked with many database tools, so I don't know them, but I supose that this can also by done with many other tools.
If you have not even a database, you can create it from separated files with many programming tools.
So, the best solution, make a database with clearly separated fields (separate date from text, if you didn't) and a search Java servlet.

Greetings,
Herenvardö

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved