Thread: Thanks you page display - v8

Hey,

I was wonder if anyone could help with this one.

We wanted to display the sub total as part of some text (eg below).

------------
Thanks for your order, We can confirm your SUB_TOTAL has been recieved*

* Minus VAT & Postage
------------

I think it's just a matter of selecting 1 feild from the order table.

Thanks

Chris

I'm look at this today again, this is 1 of the 2 things left to do on the site, at last!

Can I just run a query to the DB on the thank you page?

If you don't have the source code that's probably the best way. You could create a custom XSLT function but that's probably a bit overkill.

I've been working with this and made some progress until I noticed I couldn't pick up "money" feilds;

C#/VB.NET Code:

    <query name="Orders" rowElementName="Order">
        <sql>
            <![CDATA[
                select * from Orders with (NOLOCK) where OrderNumber=@OrderNumber
            ]]>
        </sql>
        <queryparam paramname="@OrderNumber" paramtype="runtime" requestparamname="OrderNumber" sqlDataType="int" defvalue="0"  validationpattern="" />
        <queryparam paramname="@OrderSubtotal" paramtype="runtime" requestparamname="OrderSubtotal" sqlDataType="money" defvalue="0"  validationpattern="" />
        <queryparam paramname="@SkinID" paramtype="runtime" requestparamname="SkinID" sqlDataType="int" defvalue="0"  validationpattern="" />        
        <queryparam paramname="@AffiliateID" paramtype="runtime" requestparamname="AffiliateID" sqlDataType="int" defvalue="0"  validationpattern="" />        
    </query> 


All of these work except OrderSubtotal (which is a money feild), I assume I'm doing thing silly?

This appears to be NULL -

C#/VB.NET Code:

<xsl:param name="OrderSubtotalName"><xsl:value-of select="/root/Runtime/OrderSubtotal" /></xsl:param> 


I was sure I bumped this up!

Any ideas what I've got wrong? This is my last thing to-do and I'm done

Look like it's back to the drawing board..