SQL: Difference between revisions
From MobileX for SageCRM
Crmtogether (talk | contribs) (Created page with " var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid", visit.vsit_visitid ? "vsit_visitid" : null); SQLJSONSerializer.ExecSQL(sql)...") |
Crmtogether (talk | contribs) 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", | |||
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); | |||
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);