My VB skills are, well do not exist, but I can figure some things out.
I have a query in which I need to update another column in a table. I need
to update the column CALC_WEIGHT. Looking at my original query and the new
query, would I be correct? I am going to test it out, but I want to make
sure I am on the right path.
TIA
Jacob
Original Query:
DB1.Execute "UPDATE BOX " & _
"SET TRACKINGNO = '" & strTRACK_NO & "' " & _
"WHERE ORDER = " & strPKGID & " " & _
"AND INPART = '" & strINPART & "'"
NEW Query:
DB1.Execute "UPDATE BOX " & _
"SET TRACKINGNO = '" & strTRACK_NO & "', CALC_WEIGHT = " &
strACT_WGT & " " & _
"WHERE ORDER = " & strPKGID & " " & _
"AND INPART = '" & strINPART & "'"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:247469
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
