ColdFusion on Wheels

Jacob on Updating Records

Fri, 03 Feb 2012 12:02:18 +0000

Documentation Comment by Jacob on Updating Records:

@Joe, I was running into similar issues and found this:

http://groups.google.com/group/cfwheels/browse_thread/thread/2857bbe77867ab6e/57fc90b83b95f0b9?lnk=gst&q=save#57fc90b83b95f0b9

Jacob on Updating Records

Fri, 03 Feb 2012 12:02:09 +0000

Documentation Comment by Jacob on Updating Records:

I'm running into the same issue as Joe. When I call the Save() method from an Instance where the property ID is empty, it seems to try an update and throws: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER. I had assumed that Save() would check on ID property and, when empty, run an insert.

Likewise, when I call Save() and the ID property is an existing ID in the database, I get: "Cannot insert explicit value for identity column in table 'tests' when IDENTITY_INSERT is set to OFF. "

But I agree, wheels rocks.

Todd on Object Relational Mapping

Mon, 30 Jan 2012 11:01:29 +0000

Documentation Comment by Todd on Object Relational Mapping:

I've been trying to learn wheels for the past few months but I have a rather newb question. Would you mind posting some examples of custom class methods?

Belgian CFUG 13th meeting

Thu, 26 Jan 2012 10:01:51 +0000

Date/Time

Tuesday, January 31, 2012 6:30 pm CET

Location

Diegem, Belgium

Presenter

Pablo Vos

Abstract

Pablo Vos from Out of Site will show you how using the ColdFusion on Wheels framework can save you lots of work. ColdFusion on Wheels extends the CF language by adding out of the box ORM, validation, in-page helpers and loads of other useful features, and also a way to organize code in a MVC manner, so ColdFusion coding will become less elaborate en more fun to do in less time.

Joe on Updating Records

Thu, 19 Jan 2012 17:01:39 +0000

Documentation Comment by Joe on Updating Records:

Hello - I'm a little confused about how to use the save method when passing a struct from a form submit:

<---Person struct passed from a form ---->
<cfset person=model("person").new(params.person) >

In my situation, the person's "id" attribute is passed in the params struct. I would assume that wheels knows that the object exists by virtue of the fact that "id" exists in the params struct.

When executing the save() method I am getting DB SQL error that the database can't insert explicit values for "ID" when identity_insert is OFF.

I commented out the "id" textField in the associated view so that "id" was not included in the params struct, and the save method inserted a row to the person table.

Is UpdateByKey() my only choice? Seems to me that it would be pretty simple to use the save() method to create or update a record if the primary key was included in the parameter structure.

I am working on a method called "CreateOrUpdate" which is why I'm asking. For now I'll check propertyExists("id") and update when true else create.

Wheels rocks by the way.

Philip on Using Routes

Wed, 18 Jan 2012 07:01:11 +0000

Documentation Comment by Philip on Using Routes:

I would like to create routes in combination of three things city/category/store like this
search/city/[cityname]/[storename]/[categoryname]
search/city/[cityname]/[storename]
search/city/[cityname]/[categoryname]

is it possible?

Thanks
Philip

Overriding a Wheels View Helper

Fri, 13 Jan 2012 11:16:00 +0000

Overriding a built-in ColdFusion on Wheels function is something I often see done by Wheels developers. It's a very useful technique for customizing a Wheels function while still keeping your code base clean.

Since there are some gotchas with the approach though, I'll show you a quick example of how it can be implemented.

Let's say we want to add the ability to strip Bulletin Board Code to the stripTags function. Your first instinct might be to code your own stripTags function and place it in the views/helpers.cfm file where view helper functions are typically placed.

Unfortunately you'll get a "Routines cannot be declared more than once" error if you do that though (or a similar error depending on the CFML server you have). This happens because the controller in Wheels includes all view functions and simply won't accept two functions with the same name.

The solution is to make use of the inheritance in Wheels and place the function in the controllers/Controller.cfc file instead. This component inherits all functions from a base Wheels controller component and thefore we can achieve something like what we have in the code below.

<cffunction name="stripTags" returntype="string" access="public" output="false">
  <cfargument name="html" type="string" required="true">
  <cfargument name="BBCode" type="boolean" required="false" default="false">
  <cfscript>
    var loc = {};
    loc.BBCode = arguments.BBCode;
    StructDelete(arguments, "BBCode");
    loc.returnValue = super.stripTags(argumentCollection=arguments);
    if (loc.BBCode)
    {
      loc.returnValue = REReplaceNoCase(loc.returnValue, "\[img\].*\[\/img\]", "", "all");
      loc.returnValue = REReplaceNoCase(loc.returnValue, "\[\ *[a-z].*?\]", "", "all");
      loc.returnValue = REReplaceNoCase(loc.returnValue, "\[\ */\ *[a-z].*?\]", "", "all");
    }
  </cfscript>
  <cfreturn loc.returnValue>
</cffunction>

Here I have added my new BBCode argument and the custom code to handle the new functionality. Note how I call the parent stripTags functions using the "super" keyword and also clean up the arguments struct before passing it along.

With this in place all existing calls to stripTags in your code will behave exactly the same but you get the additional option of simply adding BBCode=true to the function calls to strip out Bulletin Board Code.

This same technique can of course be applied to controllers and models too.

You can also take it a step further by wrapping it up in a plugin but that's a post for another day...

Permalink | Leave a comment »

CFML Study Group - Perth AU

Thu, 05 Jan 2012 06:16:34 +0000

At the start of last year, Chris Bauer and I got together to take a look at the CFWheels framework in what we refered to as a 'study group'. We are going to kick this off again in the new year.

We have also been discussing running CFML classes. The recently released Railo 3 Beginners Guide book would make an excellent text book. I am sure I could get a good price for bulk order.

So if you would like to learn the ColdFusion Markup Language, or would like to extend your skills, please leave a comment.

joven on Beginner Tutorial: Hello World

Mon, 02 Jan 2012 14:01:06 +0000

Documentation Comment by joven on Beginner Tutorial: Hello World:

this start my excitement to thsi framework :D

Daniel on Tutorial: Wheels, AJAX, and You

Fri, 30 Dec 2011 11:12:27 +0000

Documentation Comment by Daniel on Tutorial: Wheels, AJAX, and You:

While this does not have that much to do with the Ajax call itself it's, just a note about the security.

If you're using any sort of security controls on your controller.cfc class, if you overwrite the init function, you remove that functionality. I would suggest to use super.init() to get that functionality(and security) back.