I am trying to update table - call out the existing row and edit the existing data.

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


        are you trying to insert a new row into this table, or are you wanting to
        update an existing row?
        
        i'm guessing you actually mean to insert a new row?
        
        
        
        
        
                                                                                       
                                                
                            "(s) Fiona Tope"                                           
                                                
                            <[EMAIL PROTECTED]        To:     <[EMAIL PROTECTED]>      
                              
                            uth.ac.uk>                        cc:                      
                                                
                                                              Subject:     RE: [ 
cf-dev ] Update composite key relations table         
                            05/03/2004 16:10                                           
                                                
                            Please respond to dev                                      
                                                
                                                                                       
                                                
                                                                                       
                                                
        
        
        
        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]
        
        
        
        
        
        
        
        
        --
        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