--- In flexcoders@yahoogroups.com, "Douglas Knudsen" <[EMAIL PROTECTED]> wrote:
>
> you need a EmployeeVO CFC with matching properties and the full array of
> mutators and accessors.  

Actually, you don't.  If you want to save a lot of typing and do it the KISS 
(keep it simple, 
stupid) way, you can pass your VO with NO reference to a cfc and coldfusion 
will be happy 
to accept it as a STRUCT.  Of course, you do have to know (and spell correctly) 
the field 
names.  Following is a code snippet.

---- VO ----
notice that there is NO remote line, just a simple object
package vo
{
        [Bindable]
        public class WebOrder
        {               
                public var recID                        : int;
                public var nameNumber           : int;
                public var contact                      : String;
                public var userID                       : int;
                public var dateEntered          : Date;
                public var deliveryFrom         : Date;
                public var deliveryThru         : Date;
                public var item                         : int;
                public var customerQty          : int;
                public var customerUM           : String;
                public var tallyQty                     : int;
                public var price                        : Number;
                public var per                          : int;
                public var comments                     : String;
                public var cancelReason         : String;
                public var cancelOption         : String;
                public var PONumber                     : String;
                public var wholeUnits           : int;
                public var customTallyFlag  : int;
                public var pickUp                       : int;
                public var status                       : String;
                
                public function WebOrder()      {
                }
        }
}

--- FLEX CODE ---

        cfcOrderInquiry.webOrderInsert( {obj: model.webOrder} );


--- CF CODE -----
 <cffunction access="remote" name="webOrderInsert" output="false" 
returnType="numeric">
                <cfargument name="obj" type="struct" required="true">

        <cfquery name="myQuery" datasource="american">
                          Insert Into WebOrder  (NameNumber, UserID, Contact, 
DeliveryFrom, 
DeliveryThru,
    Item, CustomerQty, CustomerUM, Price, per) 
        values ( #obj.nameNumber#, #obj.userID#,  '#obj.contact#', 
#obj.deliveryFrom#, 
#obj.deliveryThru#, 
                #obj.item#, #obj.customerQty#,'#obj.customerUM#', #obj.price#, 
#obj.per#)
                
                select @@IDENTITY as webOrderRecID
        
        </cfquery>
        <cfreturn myQuery.webOrderRecID>
    </cffunction>
 

It is this simple.

Bruce


Reply via email to