This project has moved and is read-only. For the latest updates, please go here.

APIs and

Mar 13 at 3:56 PM
Hello all

I'm new to SPUtility and I'm probably doing something very obviously wrong but what I'm trying to do is when a user selects a drop down currency and then enters an amount it converts the amount into the selected currency and updates the amount into a third list field. Here's what I've got. Where am I going wrong?

$().sputility({
    GetSPField: "GetListItems",
    listName: "Currency Exchange Rates",
    async: false,
    CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>" + CurrencySelected + "</Value></Eq></Where></Query>",
    CAMLViewFields: "<ViewFields><FieldRef Name='Exchange_x0020_Rate'/></ViewFields>",
    completefunc: function(xData, Status){
        $(xData.responseXML).SPFilterNode("z:row").each(function() {
        ExchangeRate = ($(this).attr("ows_Exchange_x0020_Rate"));
        //varCurrencyValue = 'ExchangeRate'*'ContractCurrencyValue';