jQuery and AjaxCFC News

Rob,
First of all, I wanted to thank you for the inspiring talk you gave to the scottish cfug, I've been hitting your site randomly throughout the last couple of years and have always been awed by what you do. I'm a web designer/programmer of about 10 years but have only been working with cf for a few and in somewhat limited capacity because the demand on me at work is so great on the basic side of cf or html.

At any rate, I'm in the process of re-building a section of our site and I've been trying to figure out what to do in order to "push the limit" a bit and I think I would like to integrate ajaxcfc. However, I think I have jinxed myself with reading through a million and 1 different articles and such and I'm not quite sure what I need to do in order to really get started with ajaxcfc in a practical way.

Any thoughts would be great.

P.S. De donde eres?

Hi,
I just wanted to post a sample since I did not see one for afaxCFC query and errors.
I am using JQuery, AjaxCFC, and ColdFusion 6 ( dont ask - I know ). Intra-net.
The sample runs whatever sql statement is passed in.

The trapping of the error part was a pain to figure out, I solved it this way.

the cool part is even if my sql bombs I have a query result set to look at and figure out why.

<CFCOMPONENT extends="ajax">
<!--- Query the database for anything --->
<CFFUNCTION name="SQL" access="private">
<CFARGUMENT name="uid" type="string" required="Yes">
<CFSET var jsReturn = '' />
<CFTRY>
   <CFOUTPUT>
      <CFQUERY name="jsReturn" datasource="SomeRealDatabase" dbtype="query">
         #uid#
      </CFQUERY>
   </CFOUTPUT>
   <CFRETURN jsReturn>

<!--- Database Error --->
<CFCATCH type="Database">
<CFOUTPUT>
<CFSCRIPT>      
   // fill the query with error messages
   variables.q = queryNew('id,message,nativeerrorcode,sqlstate,detail,sql');
   queryAddRow(q,1);
   querySetCell(q, 'id', 1);
   querySetCell(q, 'message', #cfcatch.Message#);
   querySetCell(q, 'nativeerrorcode', #cfcatch.NativeErrorCode#);
   querySetCell(q, 'sqlstate', #cfcatch.SQLState#);
   querySetCell(q, 'detail', #cfcatch.Detail#);
   querySetCell(q, 'sql', #cfcatch.sql#);
</CFSCRIPT>
</CFOUTPUT>
<!--- Select the error --->
<CFQUERY name="jsReturn" dbtype="query">
   select * from q
</CFQUERY>
<CFRETURN jsReturn />
</CFCATCH>
</CFTRY>      
</CFFUNCTION>
</CFCOMPONENT>