ethar turky
asked on
update rank of tag if word in mentioned in the caption
Dear all,
Need to update NewsSYSNewsTags.RankInCapt ion= 5
where NewsSYSTags.TagTitle IN STRING of News.NewsCaptionAR
and
News.NewsID=1011 and NewsSYSNewsTags.NewsID=101 1 and
NewsSYSNewsTags.NewsSYSTag sID = NewsSYSTags.NewsSYSTagsID
thanks
Need to update NewsSYSNewsTags.RankInCapt
where NewsSYSTags.TagTitle IN STRING of News.NewsCaptionAR
and
News.NewsID=1011 and NewsSYSNewsTags.NewsID=101
NewsSYSNewsTags.NewsSYSTag
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks guys
ASKER
ASKER
News : NewsID , NewsCaptionAR
NewsSYSTags : where I store unique tags (NewsSYSTagsID (pk) , TagTitle )
NewsSYSNewsTags : where I store (NewsSYSNewsTagsID =pk) , NewsID , NewsSYSTagsID (fk)