Technical Forum

<cfscript> adminObj = createObject("component","cfide.adminapi.administrator"); createObject("component","cfide.adminapi.administrator").login("CF admin password"); myObj = createObject("component","cfide.adminapi.datasource"); </cfscript> <cfdump var="#myObj.getDatasources()#">

To find the mappings in the server, we can use the following code.     <cfset  mappings = StructNew()>     <cfset ServiceFactory = createObject("java","coldfusion.server.ServiceFactory")>         <cfset mappings = ServiceFactory.runtimeService.getMappings()>        <cfdump var="#mappings#">

For validating a required input field for blank space, we can use the attribute 'Validate="noblanks"  in the cfinput tag. For example, <cfform name="test" method="post" action="" > Name:<cfinput type="text" name="firstname"  required="yes" validate="noblanks"  message="Please Enter Your firstname"> <cfinput type=" submit" name="submit" value="Submit"> </cfform>

If we have a table 'account' with fields 'accountid' and 'balance', 1. Query to find highest balance from 'account' is:  select balance from account order by balance desc limit 0,1; 2.  Query to find second highest balance from 'account' is:    select balance from account order by balance desc limit 1,1;   3.  Query to find third highest balance from 'account' is: select balance from account order by balance desc limit 2,1;     

For deleting the records, we can use the ORM function, EntityDelete(). For example, if we have an entity 'userDetails' as below: <cfcomponent persistent="true" table="Userdetails">     <cfproperty name="id" fieldType="id" ormtype="int" column="id" >     <cfproperty name="userfirstname">     <cfproperty name="userlastname">     <cfproperty name="address">     <cfproperty name="description"> </cfcomponent> For deleting the particular record, the code is given below: <cfscript> udetails= EntityLoadByPK( " Userdetails ", 1 ); EntityDelete( udetails ); </cfscript>

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:

ORM (Object Relational Mapping ) helps us to develop applications without writing repetitive SQL statements for select, update, insert and delete operations. For configuring ORM, we should have a datasource in the server. Also we need to enable ORM in our Application.cfc file. So the Application.cfc will look like, component {        this.name = "ORMtest";   //Name of the Application        this.datasource = "DatasourceName";  //setting datasource        this.ormenabled = true;  //Enabling ORM        this.ormsettings.dbcreate = "update";  //Allows coldfusion to update database } For each tables in the database, we have to create different components or cfcs, which are called Entities. For example, if we have a table called 'Userdetails' , we can create a cfc 'userdetails.cfc', and  we need to map the objects to tables. component ...