We Recommend

Pro JavaScript Techniques
Pro JavaScript Techniques is the ultimate JavaScript book for the modern web developer. It provides everything you need to know about modern JavaScript, and shows what JavaScript can do for your web sites. This book doesn't waste any time looking at things you already know, like basic syntax and structures.

Posted By

markireland on 01/21/07

Tagged

query json ColdFusion cold-fusion

Versions (?)

Who likes this?

1 person has marked this snippet as a favorite

vali29

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

Plain 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

Comment:

You need to login to post a comment.