This content has been marked as final.
Show 4 replies
-
1. Re: Updating table with query of 2 other tables?
Dan Bracuk Feb 26, 2013 9:42 AM (in response to sakonnetweb)The lack of a where clause is pretty significant.
-
2. Re: Updating table with query of 2 other tables?
sakonnetweb Feb 26, 2013 11:36 AM (in response to Dan Bracuk)Dan
Whether I missed something as obvious as that or I already tried the "where" clause I guess is not clear- but I only asked because I tried it many different ways with no good result.
-
3. Re: Updating table with query of 2 other tables?
sakonnetweb Feb 26, 2013 12:45 PM (in response to Dan Bracuk)Actually, it was:
<cfquery name="update" datasource="#Request.BaseDSN#">
SELECT queue_ID, q_user_ID, user_ID, office_ID
FROM main_helpdesk, lookup_user
</cfquery>
<cfloop query="update">
<cfquery name="updatedata" datasource="#Request.BaseDSN#">
UPDATE main_helpdesk
SET q_office_ID = #office_ID#
WHERE q_user_ID = #user_ID#
</cfquery></cfloop>
My mistake.
-
4. Re: Updating table with query of 2 other tables?
Dan Bracuk Feb 26, 2013 2:54 PM (in response to sakonnetweb)Did you ever try a single query? This page describes how to do it. http://www.techonthenet.com/access/queries/update2.php

