I have a simple update that i am trying to do, which will be used for my other applications. But I can't seem to get the query right. I posted this question on http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21190373.html
:, but never got did not get an answer after 15 days. could someone point me in the right direction?
I have 3 separate tables. one of the tables is a collectionParts table, which has the fkeys from the other 2 tables:
PartsID [pkey, int], collectionID [int and fkey from collection table], categoryID [int, pkey from main table]
collectionID[pkey, int], collectionType
categoryID [pkey, int], itemName, description
I am trying to update the collections that each item may belong in the museumParts table. Some of the items may belong to 1 or several collections.
So, here's a sample of what I need to do:
-Update PartsID RECORD X with COLLECTIONID B on Category Q
-Update PartsID RECORD A with COLLECTIONID V on Category Q
This postings is for the same item, but different COLLECTIONIDs as well as PartsID.
I continue to get an error that PartsID can not be found or categoryID is unknown.
This is what I have on my actual update page:
<cfquery name="showPartsDetails" datasource="#request.dsn#"
INNER JOIN museum_collections
<cfquery name="selectCategory" datasource="#request.dsn#"
select * from museum_collections
<input type="submit" name="SubmitButton" value="Make the changes">
<input type="Hidden" name="CollectionID" Value="#showPartsDetails.C
<input type="Hidden" name="showPartsDetails.par
This is what I have on the update action page (I have tried a few things, but this was my last option):
<cfquery name="updateParts" datasource="#request.dsn#"
WHERE partsID = #partsID#
Why can I not update these fields??