Avatar of Shezad Ahmed
Shezad Ahmed
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Passing values in Webmatrix


I have created a web page using Microsoft WebMatrix.

I am having a problem passing a value to a variable.

I would like to pass to the company variable.

From my function RequestInformation() I would like to do something like company = result["AbEntry"]["Data"]["0"]["FullName"]

Is this possible or is there another way I can do this?

@using WebMatrix.Data;


    Page.Title = "Sage info";

    var company = "";
    var db = Database.Open("Sage200Demo");
    var selectQueryString = "SELECT * FROM SLCustomerAccount where CustomerAccountNumber = '" + company + "'";


<!DOCTYPE html>
    <title>Sage info</title>
        table, th, td {
            border: solid 1px #bbbbbb;
            border-collapse: collapse;
            padding: 2px;

  <script type="text/javascript" src="../../ClientScript/jquery/jquery.js"></script>
            <script type="text/javascript" src="../../ClientScript/MaxPage/maximizer.Events.js"></script>
    <script type="text/javascript" src="../../ClientScript/jquery/jquery.js"></script>
    <script type="text/javascript" src="../../ClientScript/MaxPage/maximizer.FollowingTabManager.js"></script>

    <script type="text/javascript">

              var tab = new maximizer.FollowingTab();
              //Subscribe to parentRecordChange event and define event handler
              tab.on("parentRecordChange", function (event) {
                  //Get the current entry key
                  var entryKey = event.data.key;

                  localStorage['SelectedKey'] = event.data.key;

                  //document.getElementById('myField').value = entryKey;
                  //Update the text in the tab
                  alert("The record has changed. The new record key is: " +
                  //Dismiss the loading indicator
              //Announce to the Following Tab Manager that the tab is ready

              function getURLParameter(parameterName) {
                  var queryString = window.location.search.substring(1);
                  var urlParameters = queryString.split('&');
                  for (var i = 0; i < urlParameters.length; i++) {
                      var param = urlParameters[i].split('=');
                      if (param[0] == parameterName) {
                          return decodeURIComponent(param[1]);

              urlMaximizerWebDataAPI = "http://" + window.location.host + "/maximizerwebdata/Data.svc/json/";

              function callMaximizerApi(baseUrl, methodName, parameters) {
                  //creating the return variable
                  var returnValue = '';
                  //creating the type of the request
                  var httpRequest = new XMLHttpRequest();
                  try {
                      //Openning the request using the provided variables
                      httpRequest.open('POST', urlMaximizerWebDataAPI + methodName,
                      httpRequest.onreadystatechange = function () {
                          if (httpRequest.readyState == 4 && httpRequest.status == 200) {
                              //if is everything OK with the server's answer then set the result value returnValue
                              returnValue = JSON.parse(httpRequest.responseText);

                      httpRequest.setRequestHeader('Content-Type', 'text/plain');
                      return returnValue;
                  catch (err) {

            function RequestInformation() {

                //separating the string
                var maxWebDataURL = getURLParameter("WebAPIURL");
                var getTokenURL = getURLParameter("GetTokenURL");
                var identityToken = getURLParameter("IdentityToken");

                //asking the token based on the identityToken
                    url: getTokenURL,
                    type: 'POST',
                    dataType: 'json',
                    contentType: 'application/json;charset=utf-8',
                    cache: false,
                    async: true,
                    data: JSON.stringify({ 'IdentityToken': identityToken }),
                    success: function (resultJSON) {
                        localStorage['CurrentUserKey'] = resultJSON.d;
                    error: function (resultJson) {

                //after received the token lets build the request for READ the AbEntry information

                var currentUserToken = localStorage['CurrentUserKey'];
                var informationRequest = {
                    "Token": currentUserToken,
                                  "FullName": 1,
                                  "Email": 1
                          "Criteria": {
                              "SearchQuery": {
                                      "Key": localStorage['SelectedKey']



                //after build the form, lets call the api and save the result in a variable
                var result = callMaximizerApi(urlMaximizerWebDataAPI, "AbEntryRead", informationRequest);





    <h1>sage info</h1>

            @foreach (var row in db.Query(selectQueryString))



Web Development

Avatar of undefined
Last Comment
Shezad Ahmed

8/22/2022 - Mon
Shezad Ahmed

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck