creating databound email links in web expression

[mckenneyj]

aspx page show results of query from sql server.
One of the results is an email field.
How do I get that data filed to display as a mailto: hypoerlink. I have already bound it to the URLHyperlink control but that attempts to send me to a URL.

Thanks,
John McKenney
Work Hard... Play Harder

 

[traingamer]

something like

Select fld1, fld2, 
"<a href="Mailto:" & [Emailfield] & "> " & [Emailfield] & "</a>" as EmailLink,
 fld4 ...
from...

or simply add the href and mailto parts in your asp.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard