Posted By

markireland on 01/21/07

Tagged

query
json

Versions (?)

Last Edited at 01/21/07 08:26pm

Statistics

Viewed 683 times

Favorited by 1 user(s)

Related snippets

query to json oblect - that can be referenced by a unique id

/ Published in: JavaScript

in javascript use, for example: myJsonObject["js007"].firstname + ' ' + myJsonObject["js007"].lastnamename
to return James Bond

Highlighted TextExpand

<cfscript> 
function nowhitespace(queryname,uniqueIdColumnName,columnlist,recordcount) {
	var p="";
	var currentrow = 1;
	p = p & '"RECORDCOUNT":' & recordcount & ',' & '"UNIQUEIDS":[';
	for (ids = 1; ids lte recordcount; ids = ids+1){
		p = p & '"js' & evaluate("queryname." & uniqueIdColumnName & '[' & ids & ']') & '"';
		if (ids lt recordcount) {p = p & ',';}
		else {p = p & '],';}
		}
	p = p & '"COLUMNNAMES":[' & listQualify(columnlist,'"') & '],';
 	for (idx = 1; idx lte recordcount; idx = idx+1) 
 	{
	 p = p & '"js' & evaluate("queryname." & uniqueIdColumnName & '[' & idx & ']') & '"' & ':{';
	 p = p & '"CURRENTROW":' & currentrow & ',';
  	  for (idx1 = 1; idx1 lte listlen(columnlist); idx1 = idx1+1){
  	  	clmnname = listgetat(columnlist,idx1);
		p = p & '"' & clmnname & '":';
 	  	evalp = evaluate("queryname." & clmnname & '[' & idx & ']');
 	  	if (NOT isNumeric(evalp)) {evalp = '"' & JSStringFormat(evalp) & '"';}
 	  	if (idx1 IS listlen(columnlist)){p = p & evalp;}
 	  	else {p = p & evalp & ',';}
  	  	} 
  	  if (idx NEQ recordcount) {
  	  	  p = p & '},'; 
  	  	  currentrow = currentrow + 1;
  	  	  }
 	} idx1 = 1;
 	p =  p & '}';
 return '{' & p & '}';
}
</cfscript>

Report this snippet Tweet