Thanks Duncan - that's quick reply.
However,  my table does not contain any attribute, only SalesID and ProductID. Would 
the update statement be different?
 
Cheers, Fiona

        -----Original Message----- 
        From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
        Sent: Fri 05/03/2004 16:01 
        To: [EMAIL PROTECTED] 
        Cc: 
        Subject: Re: [ cf-dev ] Update composite key relations table
        
        


        <!---- form page --->
        <input type="text" name="Price">
        <input type="hidden" name="SalesID" value="1">
        <input type="hidden" name="ProductID" value="2>
        
        <!--- processing page --->
        <cfquery name="updateTable" datasource="whatever">
             UPDATE SalesProduct
             SET Price = '#Form.Price#'
             WHERE Product_ID = #Form.ProductID#
             AND Sales_ID = #Form.SalesID#
        </cfquery>
        
        
        ??
        
        
        Duncan Cumming
        IT Manager
        
        http://www.alienationdesign.co.uk
        mailto:[EMAIL PROTECTED]
        Tel: 0141 575 9700
        Fax: 0141 575 9600
        
        Creative solutions in a technical world
        
        ----------------------------------------------------------------------
        Get your domain names online from:
        http://www.alienationdomains.co.uk
        Reseller options available!
        ----------------------------------------------------------------------
        ----------------------------------------------------------------------
        
        
                                                                                       
                                                
                            "(s) Fiona Tope"                                           
                                                
                            <[EMAIL PROTECTED]        To:     <[EMAIL PROTECTED]>      
                              
                            uth.ac.uk>                        cc:                      
                                                
                                                              Subject:     [ cf-dev ] 
Update composite key relations table             
                            05/03/2004 15:38                                           
                                                
                            Please respond to dev                                      
                                                
                                                                                       
                                                
                                                                                       
                                                
        
        
        
        Hi,
        
        
        
        Is anyone knows how to update a composite key relations table where it
        consists of two fields that are both used as primary key.
        
        For instance:  A table called "SalesProduct" (Sales_id, Product_id)
        
        
        
        I have created two  .cfm template, (data Update template and data entry
        template)
        
        
        
        However, primary keys are embedded as hidden fields to uniquely identify a
        row to update and they are never displayed, thus cannot be edited. The
        problem is how can I update a record with a composite key and hidden.
        
        
        
        Cheers,
        
        Fiona
        
        
        
        
        
        
        --
        These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
        Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
        
        CFDeveloper Sponsors and contributors:-
        *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
              *Forums provided by fusetalk.com* :: *ProWorkFlow provided by 
proworkflow.com*
                   *Tutorials provided by helmguru.com* :: *Lists hosted by 
gradwell.com*
        
        To unsubscribe, e-mail: [EMAIL PROTECTED]
        
        

Reply via email to