Entries Tagged as "ColdFusion"

ColdFusion DragRace at MAXUP/MAX

Ray Camdens session at MAXUP is entitled ColdFusion DragRace. The session will be from 12 to 1 on Wednesday, right at lunch so you won't be missing anything if you attend.

The idea is simple. Show up with your laptop and ColdFusion installed. You will have thirty minutes to write an application. What application? You have to show up to find out. We will then spend thirty minutes looking at what you wrote. It's ok if you don't finish completely. We will judge as a group and have significant prizes to give away.

No Comments

ColdFusion Quick Reference Sheet

Dream In Code has posted a ColdFusion Quick Reference Sheet (Cheat Sheet) in PDF format that you can download and print if you'd like.

Check it out!

No Comments

Retrieve the ID of the last inserted record

This topic has come up again and I thought I would show how to do this.

1. This example will only work with MS SQL Server. You are basically running an INSERT statemenet and following it up with a SELECT statement that queries for the @@Identity.

<cfquery name="qInsertUser" datasource="myDSN">
SET NOCOUNT ON
INSERT INTO USERS (username, email)
VALUES (
   <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#usersname#">,
   <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#email#">
   )
SELECT @@Identity AS newID
SET NOCOUNT OFF
</cfquery>

<cfset newID = qInsertUser.newID>

2. This example will work with any type of database, including MS Access.

<cflock name="insertrecord" timeout="10">
<cfquery name="qInsertUser" datasource="myDSN">
INSERT INTO USERS (username, email)
VALUES (
   <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#usersname#">,
   <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#email#">
   )
</cfquery>
<cfquery name="qGetNewID" datasource="myDSN">
SELECT MAX(RecordID) AS NewID FROM USERS
</cfquery>
</cflock>

<cfset newID = qGetNewID.NewID>

No Comments

Flex 2 is here

Well Flex 2 is finally out of Beta and is Gold now! Today is a big day. Not only did the Flex 2 platform go Gold today but the Flash Player 9 was released today as well.

ColdFusion MX 7 Updater (7.0.2) was also released yesterday. This release provides developers easy integration between ColdFusion and Flex 2 applications, and also includes important fixes.

Flex 2
Flash Player 9
ColdFusion MX 7 Updater (7.0.2)

No Comments

Google Calendar API Released

It was announced today that the Google Calendar API is available for public viewing.

Along with that, Ray Camden started working right away on GoogleCalendar.cfc Version 0, a CFC that is intended to interact with the system. He already has the read capabilities done, and next comes the write capabilities.

Thanks Ray!

No Comments