 						select tid into pid from hierarchical_taxonomy where term='everything';
 						dbms_output.put_line(r.term);
 
-						insert into hierarchical_taxonomy (tid,parent_tid,term,rank) values (someRandomSequence.nextval,pid,r.term,'superkingdom');
+						insert into hierarchical_taxonomy (tid,parent_tid,term,rank) values (
+							someRandomSequence.nextval,pid,r.term,'superkingdom');
 
 					end loop;
 				end;


</cfif>
<!------------------------------------------------------>

<cfif action is "manageLocalTree">

	<cfif not isdefined("dataset_name") or len(dataset_name) is 0>
		bad call<cfabort>
	</cfif>

	<link rel="STYLESHEET" type="text/css" href="/includes/dhtmlxTree_v50_std/codebase/dhtmlxtree.css">

	<script>
		function deletedRecord(theID){
			// deleted something
			// remove it from the view
			myTree.deleteItem(theID,false);
			$("#statusDiv").html('delete successful');
			$(".ui-dialog-titlebar-close").trigger('click');
		}

		function movedToNewParent(c,p){
			// remove the child
			myTree.deleteItem(c,false);
			// expand the new parent
			expandNode(p);
			$("#statusDiv").html('move success');
			$(".ui-dialog-titlebar-close").trigger('click');
		}

		function createdNewTerm(id){
			//alert('am createdNewTerm have id=' + id);
			//alert(' close the modal');
			// close the modal
			$(".ui-dialog-titlebar-close").trigger('click');
			// expand the node
			//alert(' closed the modal; expanding node');
			expandNode(id);
			//alert(' expanded;updatestatus');
			// update status
			$("#statusDiv").html('created new term');
			myTree.selectItem(id);
			myTree.focusItem(id);
		}
		function expandNode(id){
			//alert('am expandNode');
			$("#statusDiv").html('working...');
		    $.getJSON("/component/test.cfc",
				{
					method : "getTaxTreeChild",
					dataset_id: $("#dataset_id").val(),
					id : id,
					returnformat : "json",
					queryformat : 'column'
				},
				function (r) {
					if (r.toString().substring(0,5)=='ERROR'){
						$("#statusDiv").html(r);
						alert(r);
					} else {
						for (i=0;i<r.ROWCOUNT;i++) {
							//insertNewChild(var) does not work for some insane reason, so.....
							// delete (if exists)
							myTree.deleteItem(r.DATA.TID[i],false);

							var d="myTree.insertNewChild(" + r.DATA.PARENT_TID[i]+','+r.DATA.TID[i]+',"'+r.DATA.TERM[i]+' (' + r.DATA.RANK[i] + ')",0,0,0,0)';
							eval(d);
						}
						$("#statusDiv").html('done');
					}
				}
			);
		}

		function savedMetaEdit(tid,newVal){
			myTree.setItemText(tid,newVal);
			$("#statusDiv").html('term edits saved');
			$(".ui-dialog-titlebar-close").trigger('click');
		}

		function performSearch(){
			$("#statusDiv").html('working...');
