rem: var d = new Date(new Date() - 1000 * 60 * 60 * 24); 
add: var d = new Date(new Date() - 1000 * 60 * 60 * 24); 
context: function listReferrers_macro() {	var str = "";	var c = getDBConnection("antville");	error = c.getLastError();	if (error)		return("Error establishing DB connection: " + error);	// we're doing this with direct db access here	// (there's no need to do it with prototypes):  var d = new Date(new Date() - 1000 * 60 * 60 * 24); // 24 hours ago	var query = "select *, count(*) as \"COUNT\" from ACCESS where WEBLOG_ID = " + this._id + " and DATE > '" + d.format("yyyy-MM-dd HH:mm:ss") + "' group by REFERRER order by \"COUNT\" desc, REFERRER asc;";	var rows = c.executeRetrieval(query);	error = c.getLastError();	if (error)		return("Error executing SQL query: " + error);		var param = new Object();	while (rows.next()) {		param.count = rows.getColumnItem("COUNT");    // these two lines are necessary only for hsqldb connections:    if (param.count == 0);      continue;		param.referrer = rows.getColumnItem("REFERRER");		param.text = param.referrer.length > 50 ? param.referrer.substring(0, 50) + "..." : param.referrer;		str += this.renderSkinAsString("referrerItem", param);	}        rows.release();	return(str);}
meta: 993	/local1/tlutelli/issta_data/temp/all_js/javascript/2006_temp/2006/993/0c446c83629128922d14f1e68ff5a9118fab2692/macros.js/buggy/code/Site/macros.js