User should be able to search thoughout the whole site, most of which is stored into several databases (articles / news / magazines / archives, etc). Result page will show results grouped by section
Search: in etc...
Some page contents are stored in DB in native html. The result page will also have to show the link to that page(s)...
=========== SPECS =============
the user will enter a searchstr and select a search domain on the search page
the search domaine would consist in a Label
this label would correspond to a list of table
and for each table in that list, a list of fields to be searched in
Say: Search for "Picture" in Search Domain "Library"
Library has "Pictures" and "Magasines" tables
and for "Pictures" table, search fields are "KeyWords", "Label" and "Description"
same for "Mags" : Field are "Title", "Description", "Articles"
For each table, a display Url is also specified (i.e: /DisplayImage.asp?ImageID="
For each url, the Field PK name is entered:
and so on
yes I need smt quite generic
so you could think of smt like this
Dim DomainArray("Library", "Pictures", "Documents", etc)
Dim LibraryTableArray ( "Images", "Books", "Shelves")
Dim LibraryTablePK ( "ImageID", "BookID", "ShelfID")
Dim LibraryUrlArray("/DisplayImage.asp?ImageID=","/DisplayBook.asp?BookID=", "/DisplayShelf.asp?ShelfID=")
Dim LibraryFieldsArray ( ("ImageDescription", "ImageTitle", "ImageKeyWords"), ("BookTitle"), ("ShelfLabel", "ShelfDescription"))
Same thing for other domains... If you prefer backoffice + Tables to store this, then it's ok.
organize it the way you like but to setup the engine I simply fill in those setup Const / Tables, whatever you like and it works.
then extract from selectected domain the list of tables and for each table the list of fields to be searched in
Finally display results by Table:
Result Page :
Result1 (Link = Url1 & PKName1 = "/DiplayImage.asp?ImageID=4")
Result2 (Link = Url1 & PKName1 = "/DiplayImage.asp?ImageID=10")
Result3 (Link = Url1 & PKName1 = "/DiplayImage.asp?ImageID=4")
Result4 (Link = Url1 & PKName1 = "/DiplayImage.asp?ImageID=1255")
Result1 (Link = Url1 & PKName1 = "/DisplayBook.asp?BookID=4")
Result2 (Link = Url1 & PKName1 = "/DisplayBook.asp?BookID=10")
Result3 (Link = Url2 & PKName2 = "/DisplayBook.asp?BookID=4")
Result4 (Link = Url3 & PKName3 = "/DisplayBook.asp?BookID=1255")
And so on...
cant afford more than $55 for that. is it ok for you and when will u deliver ?
DeadLine is Sept 6th 2005 06.00PM GMT+1
19 freelancers estão ofertando em média $75 para esse trabalho
Hello, Its an easy job to do. So i placed a reasonable price for this. Please provide us the SQL DB script so we can start work. Will be waiting for your response. Thanks.
We are five young dynamic guys. We work on such projects. Quality is our motto. If you need to have a perfection in work, contact us. - [login to view URL]