Ordering records using Coldfusion ORM

By -
If we have the entity as follows;
component persistent="true" table="Userdetails"
{
    property name="id" fieldType="id" ormtype="int" column="id" ;
    property name="userfirstname"  ;
    property name="userlastname";
    property name="address";
    property name="description";
}

For ordering the records, we can use the code as follows:


<cfscript>
mydetails = EntityLoad( "Userdetails", {}, "id desc" );
writeDump( mydetails);
</cfscript>

Output:

Comments

Post a Comment

Popular posts from this blog

how to add new line in google form questions | Fix for next line issue in google form questions

By -
  Google forms are very useful to create online assessments and quiz. These are very to create through google forms. But there are some noted issues like when some questions are added line by line, it does not allow the new line by entering 'enter' key. So to make it work, there is a solution for that:  Follow this video for steps :  https://youtu.be/oTepX4VgSCI Code to be added: function addLineBreaks() {   var form = FormApp.getActiveForm();       // find form items you need    var questions = form.getItems(FormApp.ItemType.MULTIPLE_CHOICE);      for(i = 0; i < questions.length; i++)   {     var title = questions[i].getTitle();     questions[i].setTitle(title.split(". ").join("\n"));   } }
Read more

How to add new line in the 'add title and description' section in google forms

By -
Image
 Adding new line in the section 'add title and description'  in google forms can be done by running below code in the script editor : code to copy: function addLineBreaks() {   var form = FormApp.getActiveForm();       // find form items you need    var questions = form.getItems(FormApp.ItemType.SECTION_HEADER);      for(i = 0; i < questions.length; i++)   {     var title = questions[i].getTitle();     questions[i].setTitle(title.split(". ").join("\n"));     var desc= questions[i].getHelpText();     questions[i].setHelpText(desc.split(". ").join("\n"));   } } Below video will give complete steps to do this :
Read more