<!---- 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