http://www.ppshein.net/index.cfm A blog for ColdFusion, Android, jQuery, jQueryMobile, Oracle, HL7 and other Web-based programming languages, Web Server like IIS7 and RDMS like Oracle, Microsoft SQL and MySQL. en-us Wed, 22 May 2013 08:57:46 -0700 Wed, 23 Mar 2011 18:47:00 -0700 BlogCFC http://blogs.law.harvard.edu/tech/rss pyaephyoeshein@gmail.com pyaephyoeshein@gmail.com pyaephyoeshein@gmail.com no http://www.ppshein.net/index.cfm/2011/3/23/Coldfusion-ORM-in-CFScript-version In these days, I feel like myself to write all of CF coding in CFScript version. Because most of CF Developers said CFScript coding can enhance your projects than normal CFML coding. That's why I want to develop my simple ORM projects with CFScript as testing purpose. <code> <!--- Application.cfm ---> component output="false" { THIS.name = "CFScriptORM"; THIS.applicationTimeout = createTimeSpan(0, 1, 0, 0); THIS.clientManagement = false; THIS.datasource = "cfartgallery"; THIS.loginStorage = "cookie"; THIS.sessionManagement = true; THIS.sessionTimeout = createTimeSpan(0, 0, 30, 0); THIS.ormenabled = true; THIS.ormsettings = {}; public void function onError(required any Exception, required string EventName) { if (ListFindNoCase("onSessionEnd, onApplicationEnd", Arguments.EventName) IS 0) { WriteOutput("<h2>An unexpected error occurred.</h2>"); WriteOutput("<p>Please provide the following information to technical support:</p>"); WriteOutput("<p>Error Event: #Arguments.EventName#</p>"); WriteOutput("<p>Error details: #Arguments.Exception.message#<br>"); } return; } } </code> [More] CF Function Coldfusion CF Tag ORM Wed, 23 Mar 2011 18:47:00 -0700 http://www.ppshein.net/index.cfm/2011/3/23/Coldfusion-ORM-in-CFScript-version http://www.ppshein.net/index.cfm/2011/3/6/Need-to-restart-CF-server-when-I-create-new-CFC-for-ORM Today, free feel to test simple ORM project for my future project. As some developers said, ORM can provide us clean Code, high performance and can develop database application faster. Likewise, developers don't need to stick into database manipulation just like before. According Adobe Coldfusion documentation, they describe as follow: ColdFusion ORM automates most of these tasks, which: <ul> <li>Makes application code cleaner and more manageable</li> <li>Enhances your productivity and lets you develop database applications faster</li> <li>Creates applications that can run faster because of built-in ORM optimizations</li> <li>Minimizes the amount of code you write</li> </ul> That's why I've created simple ORM application. application.cfc <code> <cfset this.name = "myORMtest"> <cfset this.ormenabled = "true"> <cfset this.datasource = "myORMtestDSN"> </code> NH_NATIONALITY.cfc <code> <cfcomponent persistent="true"> <cfproperty name="id" column = "NATIONALITY_ID" generator="increment"> <cfproperty name="NATIONALITY_CODE"> <cfproperty name="NAME"> </cfcomponent> </code> index.cfm <code> <cfform action="index.cfm" method="post"> <cfinput type="Text" name="txtCode" required="Yes"> <input type="Submit" name="btnSubmit"> </cfform> <cfif StructKeyExists(form, "btnSubmit")> <cfset getQueryNA = EntityLoad("NH_NATIONALITY", {NATIONALITY_CODE = form.txtCode})> <cfdump var="#getQueryNA#"> </cfif> </code> [More] CF Function Coldfusion CF Tag ORM Sun, 06 Mar 2011 20:49:00 -0700 http://www.ppshein.net/index.cfm/2011/3/6/Need-to-restart-CF-server-when-I-create-new-CFC-for-ORM