Database

ColdFusion MeetUp: NuoFusion – Introducing NuoDB to ColdFusion, with Barry Morris

Our 12pm (US ET) talk on Thursday Sep 27 will be “NuoFusion: Introducing NuoDB to ColdFusion Developers”, with Barry Morris (NuoDB Founder).

TOPIC DESCRIPTION: (provided by the speaker)

In this talk, NuoDB Founder Barry Morris will introduce the NuoDB cloud database product (http://www.nuodb.com/) and show how ColdFusion, Java EE and NuoDB can work together to help ColdFusion developers deliver web applications that easily scale out to hundreds of thousands of users. NuoDB makes elastic scalability effortless without compromising on the things developers have come to depend on like standard SQL, ACID transactions, and popular ORM tools like Hibernate. Join us to learn more about the NuoDB product, how it works and how it can help support your web-scale applications.

MEETING URL: http://experts.adobeconnect.com/cfmeetup/
DURATION:
 Approx. 1 hour, plus time for questions
RECORDING: All meetings are recorded. The URL will be posted after meeting at recordings.coldfusionmeetup.com
SPEAKER:
 (provided by the speaker)

Read More…

Oracle Makes More Moves To Kill Open Source MySQL

MySQLOracle is holding back test cases in the latest release of MySQL. It’s a move that has all the markings of the company’s continued efforts to further close up the open source software and alienate the MySQL developer community.

The issue stems back to a recent discovery that the latest MySQL release has bug fixes but without a single one having any test cases associated with it.  That creates all sorts of problems for developers who have no assurance that the problem is actually fixed.

It’s pretty clear that Oracle is trying to make it as difficult as possible to use MySQL. The result is a wave of unsettlement in the developer community about what Oracle considers open and what it sees as closed. The move is causing problems for developers in all manner of ways as expressed here and here.

Read the whole article here.

SQL Server 2008 R2 SP2 Is Now Available!

SQL Server

Microsoft SQL Server team is pleased to announce the release of SQL Server 2008 R2 Service Pack 2 (SP2). Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is free and doesn’t require an additional service contract.

SQL Server 2008 R2 SP2 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solution provided in SQL Server 2008 R2 SP1 Cumulative Update 1 thru to Cumulative Update 5. Service Pack 2 also includes supportability enhancements and issues that have been reported through Windows Error Reporting system.

Read the entire article here.

 

NuoDB

NuoDBI finally got some time to play around with the beta 7 release of NuoDB that I downloaded a few weeks ago.  Personally I don’t think NuoDB yet gives downloaders enough information on how to get started so I decided to tackle that here myself.

Before I get into the details, why bother?  Who will benefit from this beta?

Read the entire article by Pinal Dave here

ColdFusion MeetUp: One DAO to Rule Them All…!!, with Wes Byrd

Announcing a new Meetup for The Online ColdFusion Meetup!

What“One DAO to Rule Them All…!!”, with Wes Byrd

Our 6pm (US ET) talk on Thursday June 2 will be “One DAO to Rule Them All…!!”, with Wes Byrd.

TOPIC DESCRIPTION: (provided by the speaker)

The DADAO is a single CFC that will act as a Data Access Object (DAO) to any table in your database offering one place to Create, Read, Update and Delete (CRUD) data from any table. Never create another DAO again! Never maintain your DAO’s again! Never write SQL in your code again! It changes when your database changes. It supports any database type (that ColdFusion will access via a configured datasource).

In this session, we will see some real world examples of this handy tool in action and have some general discussion on Data Access Objects in general.

MEETING URL: http://experts.acrobat.com/cfmeetup/

DURATION: Approx. 1 hour

RECORDING: All meetings are recorded. The URL will be posted after meeting at recordings.coldfusionmeetup.com

Read More…

ColdFusion – SQL: Dynamic Values in Order By Clause

This week I had to write a stored procedure for retrieving real estate properties and use the data in a ColdFusion template with pagination.  I had the following input arguments: StartRow, EndRow, PriceFrom, PriceTo and SortBy.

Since I use Fusebox, all parameters passed in the URL query string are converted to the scope “attributes”.  So, here is the procedure call:
{code type=coldfusion}
<cfstoredproc procedure=”dbo.pagination” datasource=”#application.mainDSN#”>
<cfprocparam cfsqltype=”cf_SQL_INTEGER” value=”#attributes.startRow#”  />
<cfprocparam cfsqltype=”cf_SQL_INTEGER” value=”#attributes.endRow#” />
<cfprocparam cfsqltype=”cf_SQL_INTEGER” value=”#attributes.priceFrom#” null=”#(not len(trim(attributes.priceFrom)))#” />
<cfprocparam cfsqltype=”cf_SQL_INTEGER” value=”#attributes.sortBy#” null=”#(not len(trim(attributes.sortBy)))#” />
<cfprocresult name=”qProps” />
</cfstoredproc>{/code}

Read More…