Skip to main content

Datatables Server Side Processing using Coldfusion

Datatables Server Side Processing using Coldfusion

Code: Coldfusion Server Side For Datatables

Environment: Datatables 1.10.16, Lucee 5.x, Postgres 9.6

Issue Date: 04/10/2017

Notes:
There is no warranty that the code will work on a different environment or different version.
You may create the DB table using the postgres.sql script included.
This project was tested and fully functioning.

Features:
Datatables query paging
Case Insensitive search filter to all query results.
Sort by all fields including date.
This repository does not include all Datatables features. In the code I'm only using datatables.js, but you may extend the features.

 Repository is available on github.
Labels:

Comments

  1. Anonymous22 February 2018 at 07:48

    Thank you for posting this. I converted to MySQL easily.

    ReplyDelete

Post a Comment

Popular posts from this blog

Coldfusion Facebook Graph API publish to your wall and your friends walls

In this tutorial we will learn by full coldfusion Graph API code example how to publish on your wall and your friends walls. This application uses new oauth authentication method. The code is divided into four files: we will first start with a file called index.cfm: <cfoutput>         <!--- Your FB application IDS --->       <cfset api_key = ""/>     <cfset secret_key = ""/>     <cfset appID = ""/>     <!--- create a connection to the fb graph cfc --->     <cfset graphCFC = createObject("component", "graph").init(#appID#, #api_key#, #secret_key#) />     <!--- If user is authenticated or his access token is set create a cookie --->        <cfif not isdefined("cookie.access_token") and isdefined("url.access_token")>         <cfset cookie.acce...
29 comments
Read more

Implementation of Facebook Graph API in Coldfusion

Facebook has launched a new FB API called Graph that simplifies FB applications development, the new Graph API allows website owners to create Single Sign On (SSO) with Facebook and allow websites owners to be able to import a lot of users information but after their permissions. The code below written in Coldfusion gives an example on how to Create FB login/logout button and then how to retrieve the created cookie, and use it for further development:     <body>   <cfoutput>     <!--- Your FB application IDS --->     <cfset api_key = "XXXXXXXXXXXXX"/>     <cfset secret_key = "XXXXXXXXXXXXXX"/>     <cfset appID = "XXXXXXXXXXXXXX"/>     <!--- Facebook login/logout button --->     <p><fb:login-button perms="email,user_birthday" autologoutlink="true"></fb:login-button></p>     <!--- Facebook login/logo...
21 comments
Read more

Top Google Adsense Alternatives

Google Adsense is a web tool that allows publishers in the Google Network of content sites to automatically serve text, image, video, and rich media adverts that are targeted to site content and audience. These adverts are administered, sorted, and maintained by Google, and they can generate revenue on either a per-click or per-impression basis.  Google servers advertisers using google adwords platform, while adsense is the publishers platform. Google Adsense is the top Ad Publishers platform over the web ranking number one in web advertising industry. Adsense offers contextual advertisements that covers web sites, blogs, games, videos, mobile browsing etc. What made Google Adsense no. 1 is the reliability, stability, variety of services and large number of publishers including google it self. Also google has a fair platform that detects invalid clicks so google successfully protects its advertisers and also offers its best publishers top CPC. Two reasons are behin...
11 comments
Read more