AsFusion

Hoo-Ray!!!

Was just checking out the dev site the other day to see if part 2 was up...this is by far the best remoting tutorial Macromedia have on their site...even better than the flash ones.

Really good stuff keep it up :)

Ok ignore my previous post it works fine. I somehow forgot to copy over the new application.cfc file :(

FIxed looks fantastic!

Thanks for your hard work.

YOU ROCK!

Xerrano,

Just a shot in the dark, but are you sure that remoting is enabled on the server? I was receiving similar errors with another app, and that was the issue, my host hadn't enabled the flash remoting gateway on my CF server.

Hope this Helps

OK

My fault 100%

I place "realestate" folder inside another folder "cfapps" in my "wwwroot"; when I change the "componentPath" variable to "cfapps.realestate" everything worked fine.

THANKS FOR YOUR TIME

Great!, maube you're interested about including AS 2.0 classes in CFForms :-).

http://www.richinternet.de/blog/index.cfm?mode=entry&entry=DB40A25F-F614-7FEC-F79453ADCC540BA1

Having trouble getting this to work with my code. I can get my CRUD functions to work just fine accessing them directly or via application variables, but the remoting is throwing me for a loop! When i press the remove button it takes out the record, but it will not give a message nor will it show any items in the grid at all. Same occurs with my inserts and updates except that they don't get added/updated to the database at all. Its like it just resets the grid and thats it. I think it has something to do with the responder and onchange event function of the grid. Can anyone help?
Here is those two functions that i have:

   public function setUpRemoting():Void{
      <cfoutput><!--- cfoutput to be able to set the gateway dynamically. It is recommended however to write the actual gateway instead --->
         var connection:mx.remoting.Connection = mx.remoting.NetServices.createGatewayConnection("http://#cgi.HTTP_HOST#/flashservices/gateway/");
         var componentPath:String = "#request.componentPath#.services.menuService";
      </cfoutput>
         var responseHandler:Object = {};
         
         <!--- put controls in the responseHandler's scope --->
         var menuGrid:mx.controls.DataGrid = menuGrid;
         
         <!--- handle search by default onResult function --->
         responseHandler.onResult = function( results: Object ):Void {
   
            menuGrid.dataProvider = results;
            _root.setMode('add');
            mx.managers.CursorManager.removeBusyCursor();
         }
         
         <!--- handle create response --->
         responseHandler.create_Result = function( results: Object ):Void {
         
               if (results.status){
                  menuGrid.addItemAt(0,results.item);
                  _root.setMode('add');
               }      
                              
            mx.managers.CursorManager.removeBusyCursor();
               
            //show a message
            alert(results.message);
         }
         
         <!--- handle update response --->
         responseHandler.update_Result = function( results: Object ):Void {               
            var item:Object = results.item;
            var index:Number = _root.findItem(menuGrid,'MenuItemID',item.MenuItemID);
            if (results.status && index >= 0){
               menuGrid.replaceItemAt(index,item);
            }
               
            mx.managers.CursorManager.removeBusyCursor();
               
            <!--- show a message --->
            alert(results.message);   
         }
         
         <!--- handle remove response --->
         responseHandler.remove_Result = function( results: Object ):Void {               
            
            if (results.status){
               menuGrid.removeItemAt(_root.findItem(menuGrid,'MenuItemID',results.item.MenuItemID));
               
               _root.setMode('add');
            }
            mx.managers.CursorManager.removeBusyCursor();
            
            <!--- show a message --->
            alert(results.message);   
         }
         
         <!--- default error handler --->
         responseHandler.onStatus = function( stat: Object ):Void {
            <!--- if there is any error, show an alert --->
            alert("Error: " + stat.description);
            mx.managers.CursorManager.removeBusyCursor();
         }
         
         <!--- store service in global variable --->   
         form_menuItems.myGlobalObjects.menuService = connection.getService(componentPath, responseHandler );
   }

and here is the other:

   
   <!--- function that gets called when grid selection changes, used to bind other controls to grid values --->
   public function menuGridChanged():Void {
      
      if(menuGrid.selectedItem == undefined) {
         setMode('add');
      }
      else {
         setMode('edit');
      }
      menuGrid.setFocus();
   }

I think my remoting function is right:

   <!--- editing / adding a menu item --->
   public function submitEdit():Void {
      var editArguments:Object = {};
      
      <!--- simple text inputs --->
      editArguments.MenuItemID = edit_MenuItemID.text;
      editArguments.MenuItemName = edit_MenuItemName.text;
      editArguments.MenuItemDescription = edit_MenuItemDescription.text;
      
      <!--- checkboxes --->
      editArguments.MenuItemActive = edit_MenuItemActive.selected;
      
      <!--- only make call if all required fields are supplied --->
      if( mx.validators.Validator.isStructureValid(this, 'form_menuItems') ){
         <!--- show clock cursor --->
         mx.managers.CursorManager.setBusyCursor();
      
         if (form_menuItems.myGlobalObjects.isEditMode) {
            <!--- call service --->
            form_menuItems.myGlobalObjects.menuService.updateMenuItem(editArguments);
         }
         else {
            <!--- call service --->
            form_menuItems.myGlobalObjects.menuService.createMenuItem(editArguments);
         }
      }
   }
   
   <!--- removing a listing --->
   public function submitRemove():Void {
      <!--- call service, sending the id --->
      form_menuItems.myGlobalObjects.menuService.removeMenuItem(edit_MenuItemID.text);
   }
Would greatly appreciate any advice.
Thanks again,
David

Firstly I would like to thank you for all the hard working and great thinking outsie the box. I have remoting working fine but I am having a little problem with consistency. I placed my code inside the form onLoad event and a <CFSAVECONTENT> tag. The tag sets up the remote service and makes a call to a CFC component that reads that database a returns the query / recordset back to the responsehandler function which populates a select drop down with the dataprovider. This works sometimes. When I try to reload the page the dropdown is not populated. I am not sure what the problem can be, but I believe it may have something to do with flash and the dataprovider option. Any information you can provide would be extremely helpful.

McRae

Pretty cool I got everything working, now Im in search of something different.

I basically want to populate a grid from a query.

Based on the users selection I then want to go grab more data from another query that joins some tables together and then bind that result to my forminputs, dropdowns etc..

How in the world do I do that? I am stumped atm.

please help me :)

Is anybody using MySQL 5.0 with this application?

Thanks

I found the problem

hello there,

I used a helper function you wrote for the realestate app when handling selections of a cfselect dropdown, I now want to do the same thing with a cfselect listbox (size attribute used) however I am having some issues.

Heres the code I am using. I hard coded the array, so you know what I am returning, any idea what I am doing wrong, im not a AS wiz:

var Roles:Array = Array(4000, 4001, 4002);

<!--- Listbox --note using helper function from below to select right options--->
         _root.selectList(_root.edit_Roles, Roles);



Helper Function:
      <!--- helper function to select items in a list --->
      public function selectList(select: mx.controls.List, optionsToSelect:Array):Void{
         
         //go through every record to find the right one
         for (var i:Number = 0; i < optionsToSelect.length; ++i) {
            if (select.getItemAt([i]).data == optionsToSelect[i]){
               select.selectedIndices = i;
               break;
            }
         }
      }

The solution to the wwwroot problems...

I was looking at the wrong folders.

The way the site was setup wwwroot is not my root. my root dir is under wwwroot.

wwwroot
-component (I put my cfc's here)
-mywwwroot
--component (this is were it was looking for them)

Wanted to share to helper functions I wrote that handle Listboxes (cfselect tags with size attribute and multiple variables turned on)

      <!--- helper function to select items in a list --->
      public function selectList(select: mx.controls.List, optionsToSelect:Array, arrayLength:Number):Void{
         // start first loop based on array length
         var toSelect:Array = [];
         
         for (var i:Number = 0; i < arrayLength; i++) {
            
            //Next Loop is based on listbox index length - it has 8 indexes
            //go through every record in listbox to
            //find the right ones and select them
            
            for (var z:Number = 0; z < select.length; z++) {
               if (select.getItemAt([z]).data == optionsToSelect[i]){
                  toSelect.push(z);
               }
            }
         }
         select.selectedIndices = toSelect;
      }
      
      <!--- helper function to get items selected in a list --->
      public function listResults(select: mx.controls.List, selectionMade:Array):Array {
         // start first loop based on array length
         var fromSelect:Array = [];
         var x:Number;
         
         for (var i:Number = 0; i < select.length; i++) {
            for (var index:String in selectionMade){
               if (selectionMade[index] == i){
                  x = select.getItemAt([i]).data;
                  fromSelect.push(x);
               }            
            }      
         }
         return fromSelect;
      }

I think I might be doing something wrong, but I can't see it...this is the error message I get when trying to launch the index.cfm:

Attribute validation error for tag CFFORMITEM.
The value of the attribute TYPE, which is currently "script", must be one of the values: HRULE,HTML,TEXT,VRULE,SPACER.

The error occurred in C:\CFusionMX7\wwwroot\test\realestate\index.cfm: line 66
Called from C:\CFusionMX7\wwwroot\test\realestate\index.cfm: line 65
Called from C:\CFusionMX7\wwwroot\test\realestate\index.cfm: line 1

64 : <table id="container"><tr><td>
65 : <cfform name="RealEstateAdmin" format="flash" width="990" height="610" onload="formOnLoad()" style="themeColor:##56A1E1; marginRight:-12; background-color:##37749D;">
66 : <cfformitem type="script">
67 : public function formOnLoad():Void{
68 :

PS: I'm also very interested in how to implement the same question 'janice' asked - adding a login feature...

I'm not sure how I fixed it, but I got it. Thanks again for being such a valuable resource.

PROBLEMS WITH MYSQL 5.0 SOLVED WHEN I UPDATE TO MYSQL 5.1.4 ALPHA NOW IS WORKING...

Hi Laura and Nahuel,

My questions are first

I’m losing my record numbers from displaying when I resize my datagrid.

i.e.
with(dgListStandarsReport)
{
dataProvider = results;
selectedIndex = undefined;
setSize(610,numDataGridTableHeight);
};//End of with(dgListStandarsReport)

How do I format number in the datagrid? I using numberformat="999.99", but this is not working.

I know this is not the worst problem to have but I am trying to find a fix. Normally when you set the value property of a <cfinput type="datefield" value="12/10/2004"> for example when you click on the datefield and the calender opens the calender defaults to December 2004 and you can see that the 10th is selected.
On the other hand when the bind attribute is used the date display changes but when you click on the input field the date selected is todays date.
Anyone got a fix on this?
Thanks

ListingDAO.cfc states at line 7:
<cfset variables.dsn = arguments.dns />

shouldn't this state arguments.DSN?

Btw, thank you so much for the clear examples! I would never have used the Flash version of CFFORM if it hadn't been for you...

I think have litte bug... dont know why, in access have a date and show other date... if in access have 01/27/05 will show 02/27/05

To be more clear about my previous post, I'd like to know the requirements to run this application.

Obviously this works well with the developer edition but what would be needed if I'd use this technique for a client's project?

Will the standard edition be enough?

Thank you so much for this tutorial. It's awesome!
Vincent

I have an extremely long, multi-step flash form. Each step is divided into a tab. Due to the long nature of the form it
it enables the user to come back and finish the form at a later time. I have already implemented this form using a traditional
html form. The way I implemented it in a traditional form approach is that I submit the form and save the data into
the database upon submitting it. (Each step comprises one form so there are total of 5 forms in the application.) When the user
comes back to finish filling them out, I just simply goes back to the DB and retrieve the data and pre-filling the parts the user
already filled out then continue with the rest.

Now I wanted to convert the form into flash form with Flash Remoting that will allow the using to submit and retrieve
data without leaving the form. I have arranged the form into tab interface, each tab equals to one step. There are five
tabs total. I am able to submit the form and retrieve data back using flash remoting. However, the biggest challenge I am
facing is how can I submit only parts of the form? I need to be able to distinguish which part of the form controls I am
submitting and which controls I need to validate before I submit and store data. In the traditional form, it was easy
because each step was its own form so I could only apply appropriate validations and required fields on the appropriate
appropriate form and only submit that form data to DB. However, since this flash form version is only a one, continues form
all controls will be submitted and all required fields will try to validate eventhough you are only submitting parts of it.

Does anybody have an advise on how I can make this work with the flash form using the same implementation i have in the traditional form.

thanks everyone!

Janice,

Please see my blog to integrate session management into your flash form application. I think my code is what you're looking for:
http://blog.strikefish.com/index.cfm?mode=entry&entry=EC1E92BC-CF0D-5F0F-C6B1FE5B951D85A9

Vincent,

I did this by adding

if( mx.validators.Validator.isStructureValid(this, 'YourFormName') ){
// do submit or remoting here
}

to the function called when the submit button is pressed. I think that will do what you are looking for.

Vincent,
I used the code below and it seemed to work pretty well. Hopefully it will help you out.

if( mx.validators.Validator.isStructureValid(this, 'yourformname') ){
mx.managers.CursorManager.setBusyCursor();
      
var errCount:Number=0;
var errMessage="";
var isOk:Boolean=true;
      
if (_root.fieldname.length == 0) {
errCount=errCount+1;
errMessage=errMessage+"("+errCount+") Error message text here...";
isOk=false;
}
if (_root.2ndfieldname.length == 0) {
errCount=errCount+1;
errMessage=errMessage+"("+errCount+") Error message for 2nd field here...";
isOk=false;
}
if(not isOk) {
errMessage=errCount+" form error(s) found.\n\n"+errMessage;
alert(errMessage, "Warning");
mx.managers.CursorManager.removeBusyCursor();
}else{
//do remoting here
}

Thank You! Thank You! Thank You!

I've been a CF developer for about 5 years now and stumbled upon this site and OH BOY did it lite a fire under my butt!

Thanx to your excellent tutorials and examples, I have whipped out an app in the past 4 days.

http://www.bytorproductions.com/projects/work/products2/

Next step, getting the bad boy to update via remote calls!

Keep up the great work!

Ignore my problem in the previous post. I solved it. I was sending an incorrect default value for a radio button which produced a query with no results to display.

Go it sorted now, but what I would like is some help getting two related selects working on the seaech. I've had a look at the examples of this on here but can't get it working with a query for each select. Also the selects aren't related by an id, just related by descriptions of different areas.

Well I found this to answer part of my question I thought I'd post it in case anyone else had the same thought. Still can't figure out why it won't work, though.

"The Flash Remoting service URL does not translate to an actual directory structure on your web or application server. The URL, which ends in flashservices/gateway, specifies the web application context and gateway servlet mapping for the Flash Remoting service." http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16319#url

"Service threw an exception during method invocation: null"

I get the same results when using the search button. Would anyone have any suggestions?

Thanks
Phil

Hello,

First, thanks for all of the hard work on this application! It has been absolutely invaluable to me!!

I am encountering one issue with the app itself using MS Access - I receive the following error when attempting any searches: Im getting this error: "Error Executing Database Query." - everything else works.

Second issue is, you know how if you have a regular submit button, all of the messages that you enter in required fields pop up. However, using the type="button" to call the function to submit without refresh doesn't show those messages, although it highlights the required fields. How can I get the messages to display?

Thanks again!

Ok, I found the cause of the "Error Executing Database Query" thingy. When I commented out the line:
searchArguments.bathrooms = search_bathrooms.selectedItem.data;
on the index.cfm page, the search worked! I'll have to look a little further to see why that is, but I'm so glad that I finally got it working. One less question of mine to answer :) Again, WONDERFUL job on all that you're doing here!

That did it! Thanks Laura! :)

MJE,
You might want to double check your DAO's fetch method. If you don't include all the fields that are in the grid, then they won't show up. I had the same problem because i was using a joined query in my grid and half wouldn't show up because i wasn't querying all the fields in my fetch method after my insert/update. Hope this helps!
David

MJE,
Whatever fields you have in your grid, your fetch method must contain the same. I don't think that is your problem though now that you mention that when you refresh the grid has the new value. Instead, look in setUpRemoting() and make sure that your onResult, create, update and remove methods are correct. These are what update the grid once your fetch methods send data back to the service. These methods should match those that are in the service followed by _Result. Ex: serviceName_Result. In my case i have a service called createImage so when i want to get the result entered back to my grid i use the responseHandler.createImage_Result in order to have it sent to my grid:

      <!--- handle create item response --->
      responseHandler.createImage_Result = function( results: Object ):Void {
      
            if (results.status){
               imageGrid.addItemAt(0,results.item);
               _root.setMode('add');
            }      
                           
         mx.managers.CursorManager.removeBusyCursor();
            
         //show a message
         alert(results.message);
      }
Hope this helps,
David

When a user logs in I set a struture with a list of regions , each region has its own tabbed page and grid. I pass the grid name to a function which passes it through to the cfc and returns the query and gridname to be updated.

now this is where my problem starts

if I alert('mailbox name:' + results[0]); then I get australia which is the mailbox region but how do i replace this statement with one using the dynamic name.

var Australia:mx.controls.DataGrid = Australia;
Australia.dataProvider = results[1];

I've tried everything but nothing works.

i.e
var results[0]:mx.controls.DataGrid = results[0];
results[0].dataProvider etc.

any ideas?

Alex,

I used a default (user friendly) error message inside of the CFCATCH tags and then included a cfmail tag that has all of the error information and data dumps.

Scott

Scott, how you do you include a cfmail tag in the actionscript?

thanks for that scott, but when my application times out then you cannot access any components so i was interested in a mail tag that can be used within actionscript.

<cfset application.listingGateway = createObject("component",variables.componentPath & ".components.ListingGateway").init(variables.dns) />

Is there a better way of doing this then in the application scope?

great site, keep up the good work!!!
         

Hopefully someone will be able to help me out here. I've modified the Real Estate app to fit my own needs.

I've pretty much got everything working (adding, updating and deleting a record). However two things are not happening, first, a record is created, updated or deleted the grid goes blank. I have to refresh the browser to get the grid data back. Second, there is no status message after a record is added, deleted or updated. The main change I have made is that I am not using the search piece of the Real Estate app. Other than that the actionscript code is straight from the Real Estate app.

Any help would be greatly appreciated.

Ray