Edit - Stack Overflow

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

Title*

Body*

Here is my problem. I have the following function

 def index():
 rows=db(db.mylist).select()
 return dict(rows=rows)

so whenever I reload the the front view index I want to retrieve rows from the database and display the data to the user in a list

 {{for(r in rows)}}
 li.innerhtml={{=rows.task}}
 {{pass}}

Obviously, this is not the right way to do it. I think I have to use json and XML.

This is the table I am using


 db.define_table(
 'mylist',
 Field('task', 'string')
 )

 <div class="col-sm-6">
 <div class="panel panel-default">
 <div class="panel-heading center " style="color: black; font-style: inherit">
 <form>
 Task:
 				<input name="name" id="task" />
 <button type="button" class="btn btn-success btn-sm" onclick=add(),ajax('{{=URL('default','insert_task')}}',['name']) >add</button>
 </form>
 
 </div>
 
 <div class="panel-body center">
 <ul id="list" class="list-group"> </ul>
 </div>
 
 </div>
 
 </div>
 </div>


 var ul = document.getElementById("list");
 var lastId=0;
 function add()
 {
 if(!isBlank(document.getElementById("task").value)) {
 
 
 var iCon = document.createElement('div'); //create a div container
 var dbtMenu=document.createElement('div');
 var li = document.createElement("il"); //create a list-element
 var closeSpan = document.createElement("span"); //create a span for badge attribute
 var ClickListState=0;
 
 dbtMenu.setAttribute("class","container");
 //dbtMenu.appendChild(dropDownList);
 li.setAttribute('id',lastId); // set an attribute for id
 iCon.className = "glyphicon glyphicon-remove"; // image for remove button
 closeSpan.setAttribute("class", "badge"); //create a new attribute for span
 closeSpan.appendChild(iCon); // put it in the span set
 iCon.addEventListener("click",function(){var element=document.getElementById(li.getAttribute('id'));
 element.parentNode.removeChild(element);}); //functionlity
 li.innerHTML = document.getElementById('task').value;
 var value=document.getElementById('task').value;
 var pass= document.getElementById('task').value;
 li.setAttribute("class", "list-group-item hover-yellow");
 li.addEventListener('click',function() {if(ClickListState==0){li.style.backgroundColor="red"; ClickListState++;}
 else {li.style.backgroundColor="white"; ClickListState--; }});
 li.appendChild(closeSpan);
 lastId++;
 ul.appendChild(li);
 
 }
 }

 function update()
 {
 {{for r in rows:}}
 var iCon = document.createElement('div'); //create a div container
 var dbtMenu = document.createElement('div');
 var li = document.createElement("il"); //create a list-element
 var closeSpan = document.createElement("span"); //create a span for badge attribute
 var ClickListState = 0;
 
 dbtMenu.setAttribute("class", "container");
 //dbtMenu.appendChild(dropDownList);
 li.setAttribute('id', lastId); // set an attribute for id
 iCon.className = "glyphicon glyphicon-remove"; // image for remove button
 closeSpan.setAttribute("class", "badge"); //create a new attribute for span
 closeSpan.appendChild(iCon); // put it in the span set
 iCon.addEventListener("click", function () {
 var element = document.getElementById(li.getAttribute('id'));
 element.parentNode.removeChild(element);
 });
 // var t ={#{=XML(response.json(r.task))}}
 li.innerHTML = "t";
 var value = document.getElementById('task').value;
 var pass = document.getElementById('task').value;
 li.setAttribute("class", "list-group-item hover-yellow");
 li.addEventListener('click', function () {
 if (ClickListState == 0) {
 li.style.backgroundColor = "red";
 ClickListState++;
 }
 else {
 li.style.backgroundColor = "white";
 ClickListState--;
 }
 });
 li.appendChild(closeSpan);
 lastId++;
 ul.appendChild(li);
 
 {{pass}}
 
 }
 update();

Draft saved

Draft discarded

CollectivesTM on Stack Overflow