how do i use href with a value from a database

[ddhull]

After making a selection on my index.xsl page, in my case an "Institution", I bring up the people found for that institution and display name, phone, email etc from my database.

At the top of my page I am wanting to display "Our friends from (and whatever institution was selected being in a href). I am wanting the institutionurl, which is a field in my database, in the actual value in my href. For example, say North Carolina was selected on my index.xsl page, I want the top of my page to show:

Our friends at North Carolina. And if selected it goes to www.unc.edu or whatever the link happens to be in the institutionurl field in my database.

Here is what I tried, which is the cdml conversion, but nothing shows up after "Our friends at ":

<h1 class="bluebold">Our friends at <a href="{$default-record/fmrs:field[@name = 'InstitutionURL']/fmrs:data[1]}" target="_blank"><xsl:attribute name="alt">Link to the <xsl:value-of select="$default-record/fmrs:field[@name = 'Institution']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute><xsl:value-of select="$default-record/fmrs:field[@name = 'Institution']/fmrs:data[1]"/></a></h1>

Then I display each individuals info below that. I can display the info below fine in my "xsl:for-each select" section but I can't seem to figure out the needed code for showing the institutionurl field in the href beforehand.

============

Also, when I show each persons email address, which is inside of my xsl:for-each, I am wanting a person to be able to select it and it open up the email client and place this email address in the "To:" line. When I display my data on my web site I use:

Email: <xsl:value-of select="$record/fmrs:field[@name = 'email']/fmrs:data[1]"/>

Thanks for any assistance,

Doug

[ddhull]

Here is the file I am working on. Which is called from index.xsl after an institution is selected.

Thanks,

Doug

peoplefound.xsl.zip

[ddhull]

For the email href I also tried:

 

<xsl:variable name="thisrec" select="fmrs:resultset/fmrs:record[1]"></xsl:variable>

xEmail: <a href="fmxslt:send_email($thisrec/fmrs:field[@name = 'email']/fmrs:data[1])"></a>

 

But still no results.

Any help would be appreciated,

Doug

[ddhull]

This will show the institution selected in index.xsl as a hyperlink. But it does not show the value of institutionurl, which holds the value of a link brought in from my database, when I get ready to select it.

 

            <xsl:for-each select="/fmrs:fmresultset/fmrs:resultset/fmrs:record">

              <table width="98%" border="0" cellspacing="4" cellpadding="0" align="center" bgcolor="#FFFFCC">

                <xsl:variable name="record" select="current()"/>

                <xsl:variable name="recordnumber" select="position()"/>

.

.

.

<h1 class="bluebold">ECHO Partners at <a href="$record/fmrs:field[@name='institution']/fmrs:data[1]" target="_blank">

<xsl:attribute name="alt">Link to the <xsl:value-of select="$record/fmrs:field[@name='institutionurl']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute>

<xsl:value-of select="$record/fmrs:field[@name='institution']/fmrs:data[1]"/></a></h1>

 

 



 Instead when I place my mouse on the link it shows:

 

 

http://xxx.xxx.xxx.xx/fmi/xsl/$record/fmrs:field[@name="institutionurl"]/fmrs:data[1]" in a new window

 

The other problem is if I take my href out of my <xsl:for-each etc., I get nothing. And I am wanting it above the <xsl:for-each part of my code.

Thanks,

Doug

[kuma_24]

this is the code that i have been using:

<a>

     <xsl:attribute name="href"><xsl:value-of select="fmrs:field[@name='institution']/fmrs:data"/></xsl:attribute>link verbage here

</a>

note: if you are inside a for-each loop you do not need the "$record/" record in any of your value-of statements. that part of the code is already there in the for-each statement. you don't need the "record" variable which calls current() because the for-each loop is already putting you in the current record.

[Martin Brändle]

My first impression is that the your original code is fine. However, did you place the fields on your layout?

[ddhull]

Thanks kuma and martin,

It seems I am getting nowhere with this. I do have the fields on my layout. I can't get the link to show before my for-each and I can't get my email link inside of the for-each to work either. Would either of you have an example to share.

Thanks for the note kuma.

I now have what was selected on my index.xsl page showing in an href above my for-each but when I go to select it I get the following instead of the value institutionurl, which is a variable in my database:

 

http://xxx.xxx.xxx.xx/fmi/xsl/$record/fmrs:field[@name="institutionurl"]/fmrs:data[1]" in a new window

 



Here is the code I am using to show the institutionurl:

 

 

<xsl:variable name="ins" select="/fmrs:fmresultset/fmrs:resultset/fmrs:record[1]"/>



<h1 class="bluebold">ECHO Partners at <a href="$ins/fmrs:field[@name='institutionurl']/fmrs:data[1]" target="_blank">

<xsl:attribute name="alt">Link to the <xsl:value-of select="$ins/fmrs:field[@name='institutionurl']/fmrs:data[1]"/>. Please note that selecting this link will open a new browser window.</xsl:attribute>

<xsl:value-of select="$ins/fmrs:field[@name='institution']/fmrs:data[1]"/></a></h1>

 

Doug

[Martin Brändle]

Ok I look at it again. Maybe I missed something.