gistfile1.txt

Data returned from "db_taskmanager.php?action=select-users"; 

{ "usersList": [{"value":12,"label":"Baker,Zac"},{"value":166,"label":"Smith,James"},{"value":81,"label":"Wagner,Richard"},




	// User Dropdown Custom Formatter
	YAHOO.widget.DataTable.Formatter.lookup = function(elCell, oRecord, oColumn, oData) { 
		var lookupTable = oColumn.lookupTable || (oColumn.editor instanceof YAHOO.widget.DropdownCellEditor) && oColumn.editor.dropdownOptions; 
	
		if (YAHOO.lang.isArray(lookupTable)) { 
			for (var i = 0; i < lookupTable.length; i++) { 
				if (lookupTable[i].value === oData) { 
					elCell.innerHTML = lookupTable[i].label; 
					return; 
				} 
			} 
		} 
		elCell.innerHTML = oData || ""; // if oData is null, show a blank. 
	}; 
	 
	// Get list of users for dropdown editor
	var sUrl = "db_taskmanager.php?action=select-users"; 

	var handleSuccess = function(o){
	}
	
	var handleFailure = function(o){
	}
	
	var callback = 
		{ 
		  success:handleSuccess, 
		  failure: handleFailure, 
		  argument: { foo:"foo", bar:"bar" } 
	}; 

	var myUsersDataSource = YAHOO.util.Connect.asyncRequest('GET', sUrl, callback); 


	// Define Editors for DataTable
	var myEditor = new YAHOO.widget.TextboxCellEditor({disableBtns:false, asyncSubmitter: updateRecord});
	var myDDEditor = new YAHOO.widget.DropdownCellEditor({dropdownOptions:myUsersDataSource,disableBtns:true, asyncSubmitter: updateRecord});


	 //Columns actually displayed in myDataTable
	var myColumnDefs = [
		{key:"XMLDocID", isPrimaryKey:true, hidden:true},
		{key:""},
		{key:"Title", label: "Title", sortable: "true", editor: myEditor},
		{key:"TaskDesc", label: "TaskDesc", maxAutoWidth: "250", editor: myEditor},
		{key:"XMLDocURI", label: "XMLDocURI", maxAutoWidth: "200", editor: myEditor},
		{key:"XMLDocFilename", label: "XMLDocFilename", maxAutoWidth: "200", editor: myEditor},
		{key:"Author", label: "Author", minWidth: "200", maxAutoWidth: "300", formatter:'lookup',	editor: myDDEditor},
		{key:"Editor", label: "Editor", maxAutoWidth: "100", formatter:'lookup',	editor: myDDEditor},
		{key:"Reviewer", label: "Reviewer", maxAutoWidth: "100", formatter:'lookup',	editor: myDDEditor},
		{key:"Publisher", label: "Publisher", maxAutoWidth: "100", formatter:'lookup', editor: myDDEditor},		
		{key:"CreatedOn", label: "CreatedOn", maxAutoWidth: "100"},		
		{key:"UpdatedOn", label: "UpdatedOn", maxAutoWidth: "100"},		
		{key:"Standard", label: "Standard", maxAutoWidth: "100", editor: myEditor},				
		{key:'delete', label:' ', className:'delete-button', action:'delete', formatter: delToolTip}
		];