Click here to Skip to main content
15,566,245 members
Home / Discussions / Database
   

Database

 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:46
professionalGilbert Consellado22-Nov-14 14:46 
AnswerRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra21-Nov-14 6:50
professionalShweta N Mishra21-Nov-14 6:50 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado22-Nov-14 14:43
professionalGilbert Consellado22-Nov-14 14:43 
GeneralRe: mysql decimal fromat like ##.## Pin
Shweta N Mishra23-Nov-14 3:06
professionalShweta N Mishra23-Nov-14 3:06 
GeneralRe: mysql decimal fromat like ##.## Pin
Gilbert Consellado24-Nov-14 13:47
professionalGilbert Consellado24-Nov-14 13:47 
QuestionProblem in Insering Long text in mysql from c# Pin
Ramachandra12720-Nov-14 8:09
Ramachandra12720-Nov-14 8:09 
GeneralRe: Problem in Insering Long text in mysql from c# Pin
PIEBALDconsult20-Nov-14 8:33
professionalPIEBALDconsult20-Nov-14 8:33 
QuestionSQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 0:44
miss78618-Nov-14 0:44 
I am trying to replace names found in 'xml' fieldname as hyperlinks, by matching with the names in database_tags.

I am using the following function below, however the UDF is only recognizing one name from the XML fieldname data, instead of all the names present in the XML data.
SQL
ALTER FUNCTION [dbo].[ReplaceTags](@XML VARCHAR(MAX)) 
 RETURNS VARCHAR(MAX) 
 AS 
 BEGIN 

 DECLARE @N VARCHAR(MAX) 
 SELECT @N = [Name] FROM [dbo].[database_tags] 
 WHERE @XML LIKE '%'+[Name]+'%' 
 AND UploadDate >= '2014-09-01' 

 IF @N IS NOT NULL 
 BEGIN 
 SELECT  @XML = REPLACE(@XML, 
   @N, 
   '<a href="<a href="pagename.aspx?tag='+@N+'">'+@N+'</a>') 
 END 
 RETURN @XML 
 END

for example, if the XML input data is the following: It consists of: BANKP, BCJA, BCJAM, BFTH, BFTH, and EMPOP.

But the updated function is only recognizing two of names BFTH, BFTH, as hyperlinks, from the database_tags table.

Is there a way to get the function to recognize more than one names as hyperlinks.

Thank you very much for your time and help.
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 3:53
mveRichard Deeming18-Nov-14 3:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78618-Nov-14 4:53
miss78618-Nov-14 4:53 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
Richard Deeming18-Nov-14 7:00
mveRichard Deeming18-Nov-14 7:00 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 11:41
professionalPhilLenoir18-Nov-14 11:41 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
miss78620-Nov-14 2:45
miss78620-Nov-14 2:45 
GeneralRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir20-Nov-14 4:13
professionalPhilLenoir20-Nov-14 4:13 
AnswerRe: SQL Replace Function - error recognizing two or more strings Pin
PhilLenoir18-Nov-14 4:41
professionalPhilLenoir18-Nov-14 4:41 
Questionsuggest various tables for shopping site Pin
smart_vikas12-Nov-14 19:53
smart_vikas12-Nov-14 19:53 
AnswerRe: suggest various tables for shopping site Pin
Jörgen Andersson12-Nov-14 20:59
professionalJörgen Andersson12-Nov-14 20:59 
AnswerRe: suggest various tables for shopping site Pin
Mycroft Holmes12-Nov-14 23:40
professionalMycroft Holmes12-Nov-14 23:40 
QuestionRe: suggest various tables for shopping site Pin
Eddy Vluggen13-Nov-14 8:18
professionalEddy Vluggen13-Nov-14 8:18 
AnswerRe: suggest various tables for shopping site Pin
PIEBALDconsult13-Nov-14 8:35
professionalPIEBALDconsult13-Nov-14 8:35 
QuestionLONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 10:15
Jassim Rahma12-Nov-14 10:15 
AnswerRe: LONGTEXT not accepting large text! Pin
PIEBALDconsult12-Nov-14 10:20
professionalPIEBALDconsult12-Nov-14 10:20 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 10:51
Jassim Rahma12-Nov-14 10:51 
AnswerRe: LONGTEXT not accepting large text! Pin
Richard Deeming12-Nov-14 10:55
mveRichard Deeming12-Nov-14 10:55 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 10:59
Jassim Rahma12-Nov-14 10:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.