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