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]