Microsoft Office Live Small Business Community

Hi All,

I am trying to put together a product list at www.ingredientwizard.com/product_list.aspx using a customised business application but need to include hyperlinks and buttons within the table but can't figure out to do it. I would like each product listed to be clickable to another page on my site and add a standard button to the next door column for customer to click to go to a mailto link where they can enquire about the product. I can achieve all of this outside the business application but keeping the list updated then becomes really tedious. I was hoping there is a middle ground where I can benefit from the easy up date of the BA list and the hyperlink and button features. 

I would also ideally like the list to be alphabetical (i.e. right to left - have managed up and down) and spread over three columns rather than a long single column list - is this possible?

Would really apprciate any hints or help with this!

Many thanks,

Fergus

Fergus,

Adding the buttons and nav links - you are just using plain HTML to do that in the XSLT code (easy way is just to add another table column (<td> ...button code...</td> ) to it. What really should happen is that in your customized BA, you should have the mailto and hyperlink to the page you want them to go to (if it's different for each ingredient). If it's the same, you can just make it a constant in the XSLT code.

Multiple columns for form designer:

http://myofficelivecommunity.com/discuss/forums/p/7268/17928.aspx

Royster

Get a free .biz domain for your website. Visit SoftPrizm.com

Blog: The SoftPrizm Channel

OLSecure Beta: Secured Web Area Solution for Office Live

Hi Royster,

Thanks for answering this one but I'm afraid you lost me. I tried entering HTML in the contents of the table in the back end database but it just displays the text. I have no idea what I am doing with the custom XSLT. What I would like is just as I have but with the ingredient names clickable to another page on the site. Would you mind walking me through it?

Thanks,

Fergus 

I don't think you can get what you want without writing XSLT.  I just did it for my website...I think it sounds like what you're trying to do.  Here is the code I used for that portion of the page.  (No laughing from the experienced developers...my last programming gig I was porting a PL/1 SQL app running on VM to Windows 3.1!)

Look at the webpage here..http://bobfreedmanarranger.com/hsbigband.aspx..I'll paste the code snippet for that first column with the "Add to Cart" and "PDF Preview" links below (hope it formats OK.)

Good Luck!

-Wendy

-->

<span style="LEFT: 0.1in; TOP: 0.1in; WIDTH: 0.85in; OVERFLOW: hidden; POSITION: absolute">

<xsl:variable name="strTest" select="string(@PayloadzID)"/>

<xsl:choose>

<xsl:when test="string-length($strTest) &gt; 0">

<a>

<xsl:attribute name="href">http://www.payloadz.com/go?id= <xsl:value-of select="@PayloadzID" /></xsl:attribute>

<xsl:attribute name="target">"paypal"</xsl:attribute>

<xsl:attribute name="title">Add To Cart</xsl:attribute>

<xsl:text />Add To Cart

</a>

</xsl:when>

<xsl:otherwise><small>coming soon!</small></xsl:otherwise>

</xsl:choose>

<br /><xsl:value-of select="format-number(@SalePrice,'$#.00')"/>

<xsl:variable name="strTest2" select="string(@PDFName)" />

<xsl:if test="string-length($strTest2) &gt; 0">

<br /><br />

<a>

<xsl:attribute name="href">/Documents/<xsl:value-of select="@PDFName" /></xsl:attribute>

<xsl:attribute name="title">PDF Preview</xsl:attribute>

<xsl:text />PDF Preview

</a>

</xsl:if>

</span>

I should have mentioned that I found the product "Altova XMLSpy" very helpful as an XSLT editor.  They have a 30-day full-featured free trial.  http://www.altova.com/products/xmlspy/xml_editor.html

-Wendy

Hi Wendy,

Thanks for that but this is way beyond my understanding - I think I'll just do it the long handed way - which I will be able to modify easily without completely confusing myself.

Many thanks,

Fergus