Entries Tagged as “web application”

Language Enhancements in ColdFusion Splendor - CF Functions for Query tag

April 07, 2014 / Awdhesh Kumar

  ColdFusion 11 | Language enhancements | Splendor | web application

Continuing the blog posts series on language enhancements, today, I am going to cover the Query functions and explain its various overloaded methods in detail. Before I discuss this feature, here is the list of language features added in ColdFusion Splendor.

Script syntax for Query tag is available in Splendor through the generic "Script support for tags". This generic solution works well for all the other tags except CFQuery. CFQuery, being a bit complex, necessitated a need to provide an easy to use script-syntax for query execution. So, to simplify it in a script block, the query functions have been added in Splendor. These are designed in-line with existing ORM execute functions. The general syntax of query functions are:
QueryExecute(sql_statement);
QueryExecute(sql_statement, queryParams);
QueryExecute(sql_statement, queryParams, queryOptions);

As shown above, query functions can be invoked by passing one, two, or three parameters. The first parameter, an SQL statement is mandatory and the other two (queryParams and queryOptions) are optional. 

Query params:

There are two different ways to pass a parameter to an SQL query: named and positional (unnamed). In named parameter, you use ":" as the placeholder and pass a struct to queryParam. For the positional one, "?" is used as the placeholder and the values of the parameters are passed as an array to queryParams. 

  //named parameter 
  QueryExecute("select * from Employee where country=:country and artistid=:id", {country='USA', id:1});
  
  // positional parameter
  QueryExecute("select * from Employee where country=:? and artistid=?", ['USA', 1]);

If required, the CFQueryParam attributes information can also be passed for executing a query. For this, the attributes of an individual queryParam are first defined in a struct and then this struct is passed, rather passing  a simple string or number, as a  value of that param. To understand it better, an example is shown below:

//queryparams with attributes
QueryExecute("select * from Employee where country=:country and empId=id, {id:101, country:{name="USA", CFSQLType='CF_SQL_CLOB', list=true }});

QueryOptions

QueryOptions is a struct which contains different attribute values of a Query tag. In the following example, a "datasource" attribute has been passed in the queryOptions parameter. Similarly, all the attributes (except name) can be passed to queryOptions before executing a query.

 QueryExecute("select * from Artists where artistid=:id", {id:1},{datasource= "cfartgallery"});

This feature has been covered in details in Splendor document. See the doc for more information.


ColdFusion case study: ITRX Corp.

November 04, 2013 / Rakshith Naresh

  Administrator | Adobe ColdFusion 10 | web application | web application development | web application security

One of the world’s leading open-source research websites was experiencing performance issues because increasing volumes of data were taxing the system’s available memory. To solve the problem, the Social Science Research Network (SSRN) called on ITX Corp., an IT solutions provider. ITX rebuilt the site using Adobe ColdFusion, which helped eliminate memory problems, cut development times through the reuse of modularized code, and streamline SSRN’s web technology infrastructure.

 

“Not only did the upgrade to 64-bit Adobe Cold Fusion help stop server crashes, it also helped reduce the number of servers SSRN needs to run its site,” says Fernando D’Agostino, lead architect at ITX. “Previously, SSRN had 14 servers. Now it has 8, which reduces costs associated with server purchases, maintenance, and support.”  http://adobe.ly/19XDRHf


CFSummit Mobile app for Android and iOS

October 18, 2013 / Rakshith Naresh

  Announcements | CF Summit | Splendor | web application | web application development

I am pleased to let you know that there is a mobile app available for iOS and Android for the Adobe ColdFusion Summit happening in Vegas.

Here is the link for the app on Google Play. And here's the link for the app on iOS.

The best part about this is app is that the entire app is built using the new Mobile features coming up in ColdFusion Splendor and ColdFusion Builder Thunder. The code for the app will be shared after the CFSummit.

You can view the entire schedule of the conference, create your own schedule, submit session and conference surveys, follow Twitter feed and even receive conference notifications.

Go ahead and play with the app before you arrive at the CFSummit next week.

See you all in Vegas at the largest ColdFusion conference in recent times.

 

 

 


ColdFusion Feature Usage Survey

August 20, 2013 / Rakshith Naresh

  Announcements | Rapid Application Development | web application | web application development | web application security | web programming

Please participate in this ColdFusion feature usage survey. This is not a typical feature usage survey for ColdFusion. The purpose of this survey is to understand the usage of some of the old or not-so-popular features of ColdFusion.

The information gathered here will help Adobe deprecate/retain/provide alternate features in the next major version of ColdFusion.

Thanks for your time.


Adobe ColdFusion e-seminar: REST Support in ColdFusion 10

June 17, 2013 / Rakshith Naresh

  Adobe ColdFusion 10 | Announcements | web application | web application development

[update: The REST e-seminar is now happening on the 6th of August at 8 am pacific. Register here ]

There is a ColdFusion e-seminar happening on the 18th of June at 8 am pacific. The e-seminar will run for an hour. You an register for the e-seminar here.


Blue Mango Theme Design By Mark Aplet

Super Powered by Mango Blog