I am using search core web part to display the results of my search. I have added a column in xslt so that it displays ProjectId in the search result. I am using BCS to search an external database. I would like to make projectid a link. the url of this project is stored in a list called referenceList.
Here is an exmaple:
**SQL Database table:**
**ProjectId | Project Name | Project Description**
----------------------------------------------
1 Proj 1 some description
2 Proj 2 some other description
**Referencelist (in sharepoint)**
ProjectId | ProjectUrl
---------------------------
1 | http://google.com
2 | http://gmail.com
Results in Search Core Web part
---------------------------------
ProjectId <Link> | Project Name | Project Description
What is the best way to retrieve the projecturl in ReferenceList (custom list) from within the xslt in Search core web part? Can I use xslt list view web part? at the moment I am modifying the xslt of the search core web part.
Can you provide me some examples or references or ideas as to how can I do this?
Thank you very much. Please it is urgent.