Help! Using Calculated Column with <a href=""></a> - User Defined Table Module [Lead: Sebastian Leupold]

Forum DotNetNuke® Pro... User Defined Ta... Help! Using Calculated Column with

9/12/2006 9:30 PM

	jpcastillo
13 posts

Help! Using Calculated Column with

Hello everyone!
I hope someone could help me.

I'm new to this UDT. I'm trying to make a column wherein the text is a URL link.
Here are my columns:

Title Type Extended Settings
=======================================
Title Text
LinkURL URL
LinkTitle Calculated Column '<a href="' + LinkURL + '">' + Title + ' </a>'

I can't make it to work.
For example,
Title=NBA
LinkURL=http://www.nba.com

I was hoping my LinkTitle should be
<a href="http://www.nba.com">NBA</a>

But it's outputting as www.nba.com>NBA with the www.nba.com part pointing to http://localhost/dotnetnuke2/rosettanet/a/tabid/244/%3Ca%20href=

It seems it's being cut on the href tag.
Am I missing something here?

Any help would be greatly appreciated.
Thanks!

Jared

9/13/2006 12:33 AM

	Stefan Cullmann
1569 posts

Re: Help! Using Calculated Column with

Ok, there happens some undocumented voodoo.

During rendering time the url value doesn't contain the original url but a complete link string.

But there are some more invisible columns you can use. All url datatypes will have three columns in the underlaying dataset:

ColumnName	complete link (that one which is displayed when the column is visible)
ColumnName_UDT_Url	underlaying url inside link
ColumnName_UDT_Original	value saved in database

So in your case the desired string for calculated column is

'<a href="' + LinkURL_UDT_Url + '">' + Title + ' </a>'

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport

9/13/2006 1:34 AM

	jpcastillo
13 posts

Re: Help! Using Calculated Column with

Hi Stefan!
Thanks for the quick response.
You've been an absolute help!

Made it to work.

Thanks a lot!

One last thing, is there any chance that there would be a more detailed documentation in the near future that contains these kind of information?
Just hoping. It would really help us all, especially us newbies.

Thanks!

Jared

9/13/2006 2:57 AM

	Stefan Cullmann
1569 posts

Re: Help! Using Calculated Column with

Modified By Stefan Cullmann on 9/13/2006 6:45:19 AM)

Sebastian will hit me that I did not include this information before

	ColumName	ColumnName + _UDT_Original	ColumnName + _UDT_Value	ColumnName + _UDT_Url
Boolean	Image [(un)checked.gif]	true'/'false'	-	-
Changed At	Date	-	Localised Date	-
Changed by	Display Name	UserName	-	-
Created At	Date	-	Localised Date	-
Created By	Display Name	UserName	-	-
Currency	Value	-	-	-
Date	Date	-	Localised Date	-
DateTime	Date Time	-	Localised DateTime	-
Decimal	Value	-	-	-
Download	Html Link	Value	-	Url
Email	Html Link	Value	-	mailto:Value
Expression	Result of Expression	-	-	-
Image	Html Image	value	-	Url of Image
Int32	Value	-	-	-
String	Value	-	-	-
TextHtml	Value	-	-	-
Url	Html Link	value	-	Url

9/13/2006 3:55 AM

	jpcastillo
13 posts

Re: Help! Using Calculated Column with

hahaha.lolz.

Anyway, thanks a lot for this information.

Jared

Page 1 of 3

Forum

DotNetNuke® Pro...

User Defined Ta...

Help! Using Calculated Column with