Hi there!
In my Library project i want to replace some text with images.
I have this:
[img]http://img33.imageshack.us/img33/8425/antesx.jpg[/img]
Wich is generated by the following code:
SELECT IDLivro,Titulo
,LEFT(Nome, LEN(Nome) - 2) AS Nome
,LEFT(Categoria, LEN(Categoria) - 2) AS Categoria
,Posicao
,Classificacao
,Comentario
FROM
(
SELECT L.Titulo
,(
SELECT A.Nome + ' ; ' AS "text()"
FROM dbo.Autor A
JOIN dbo.LivroAutor LA
ON A.IDAutor = LA.IDAutor
WHERE LA.IDLivro = L.IDLivro
ORDER BY A.Nome DESC
FOR XML PATH('')
) AS Nome
,(
SELECT C.Categoria + ' ; ' AS "text()"
FROM dbo.Categoria C
JOIN dbo.LivroCategoria LC
ON C.IDCategoria = LC.IDCategoria
WHERE LC.IDLivro = L.IDLivro
ORDER BY C.Categoria DESC
FOR XML PATH('')
) AS Categoria
,L.Posicao
,L.Classificacao
,L.IDLivro
,L.Comentario
FROM dbo.Livro L
) D
And my goal is to have this: (Generated my PAINT lol)
[img]http://img33.imageshack.us/img33/9396/depoisolk.jpg[/img]
Anyone can help me please?
Thanks