3

I am using the .NET connector to connect to an SQL database. One of this value is a URL. Now I need to display this as a URL.

Any ideas on how to solve this?

Nikkho Shandittha
  • 111
  • 2
  • 7

1 Answers1

5

In Sharepoint Designer you can edit the read list and go to the field, so for example you have a field called URL, display it as a label so it would render like

<asp:Label runat="server" id="ff1{$ID}" text="{$thisNode/@URL}" />

Then all you need to do is add an "A href" tag to it so it renders as a url like such

<a href="{$thisNode/@URL}"><asp:Label runat="server" id="ff1{$ID}" text="{$thisNode/@URL}" /></a>

enter image description here

Raymund
  • 7,684
  • 5
  • 45
  • 78
  • Ah, alrighty then. I'll have a go at that tomorrow if I remember - thanks for your help! +1, and +50 :) – marnir Jun 20 '11 at 22:16
  • Works for me, too. Great tip. I hadn't customized XSLT for the standard list view yet, so that took me a second to find out that the XSLT isn't viewed like your sample until you make an initial edit. – Tom Resing Feb 13 '12 at 19:46