SQL - Revision history

Crmtogether at 15:38, 10 November 2016

2016-11-10T15:38:49Z

← Older revision		Revision as of 16:38, 10 November 2016
Line 1:		Line 1:
			This is an example of using SQL in a query and getting JSON back

	var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid",		var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid",

Crmtogether at 15:38, 10 November 2016

2016-11-10T15:38:21Z

← Older revision		Revision as of 16:38, 10 November 2016
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);

Crmtogether: Created page with " var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid", visit.vsit_visitid ? "vsit_visitid" : null); SQLJSONSerializer.ExecSQL(sql)..."

2016-08-03T09:13:54Z

Created page with " var visitId = SQLJSONSerializer.InsertOrUpdateRecord("Visit", visitJSON, "vsit_visitid", visit.vsit_visitid ? "vsit_visitid" : null); SQLJSONSerializer.ExecSQL(sql)..."

New page

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);