searching article for names in the database before submitting article to the database
- by zurna
I want to create a function that will search through a text, find names those match with existing names in the database and add links to those names before submitting the article to the database.
i.e.
text:
Chelsea are making a change now as goalscorer Nicolas Anelka is replaced by in-form Florent Malouda who can do no wrong lately.
Nicolas Anelka exists in the database in the Players table with ID column equals to 1.
I want text to be converted to
Chelsea are making a change now as goalscorer a href="player.asp=ID=1"Nicolas Anelka/a is replaced by in-form Florent Malouda who can do no wrong lately.
I know my code is logically wrong but I could build the correct logic.
Function PlayerStats (ArticleDesc)
If IsNull(ArticleDesc) Then Exit Function
SQL = "SELECT PlayerID, PlayerName"
SQL = SQL & " FROM Players"
' SQL = SQL & " WHERE PlayerID = "& &""
Set objPlayer = objConn.Execute(SQL)
Do While NOT objPlayer.EOF
ArticleDesc = Replace(ArticleDesc, objPlayer("PlayerName"), "!"&objPlayer("PlayerName")&"!")
PlayerStats = ArticleDesc
Loop
objPlayer.MoveNext
End Function
