Question
Updating Qty
Hi i need to update a table with qtys from another table, i
have tried the query below but its not updating
any ideas what i should do?
<cfquery name="SEL" datasource="#application.ds#">
SELECT *
FROM supplierhistory SH
WHERE SH.HistoryQuoteNo = '#session.order1#'
</cfquery>
<cfloop query="SEL">
<cfquery name="QQE" datasource="#application.ds#">
SELECT *
FROM products_table
WHERE PartNo = '#SEL.HistorySouthPartNo#'
</cfquery>
<cfset newqty = QQE.Qty + SEL.HistoryQty>
<cfquery name="Update1" datasource="#application.ds#">
UPDATE products_table
SET Qty = #newqty#
WHERE Part_No = #SEL.HistorySouthPartNo#
</cfquery>
</cfloop>
any ideas what i should do?
<cfquery name="SEL" datasource="#application.ds#">
SELECT *
FROM supplierhistory SH
WHERE SH.HistoryQuoteNo = '#session.order1#'
</cfquery>
<cfloop query="SEL">
<cfquery name="QQE" datasource="#application.ds#">
SELECT *
FROM products_table
WHERE PartNo = '#SEL.HistorySouthPartNo#'
</cfquery>
<cfset newqty = QQE.Qty + SEL.HistoryQty>
<cfquery name="Update1" datasource="#application.ds#">
UPDATE products_table
SET Qty = #newqty#
WHERE Part_No = #SEL.HistorySouthPartNo#
</cfquery>
</cfloop>