SQL: Difference between revisions

From MobileX for SageCRM
(Created page with " var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid", visit.vsit_visitid ? "vsit_visitid" : null); SQLJSONSerializer.ExecSQL(sql)...")
 
No edit summary
Line 1: Line 1:


 
  var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid",
 
  visit.vsit_visitid ? "vsit_visitid" : null);
 
  SQLJSONSerializer.ExecSQL(sql);
var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid",
    visit.vsit_visitid ? "vsit_visitid" : null);
 
 
SQLJSONSerializer.ExecSQL(sql);
 
 
 
 
   var sql = "select * " +
   var sql = "select * " +
         " from library " +
         " from library " +
         " where {0}={1} order by 1 desc";
         " where {0}={1} order by 1 desc";
 
  sql = clr.System.String.Format(sql, libridfield, params.EntityId);
    sql = clr.System.String.Format(sql, libridfield, params.EntityId);
  var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
 
  Response.Write(jsonResult);
    var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
    Response.Write(jsonResult);

Revision as of 15:38, 10 November 2016

 var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid",
 visit.vsit_visitid ? "vsit_visitid" : null);
 SQLJSONSerializer.ExecSQL(sql);
 var sql = "select * " +
       " from library " +
       " where {0}={1} order by 1 desc";
 sql = clr.System.String.Format(sql, libridfield, params.EntityId);
 var jsonResult = SQLJSONSerializer.ExecuteQueryToJSON(sql, false);
 Response.Write(jsonResult);