How to update two database tables coldfusion

[Rixwel]

I have two tables - One contains a list of all the zip codes in the India. and the other table contains a mailing list containing addresses of people both inside and outside of the India, when I run the query, it times out. As a matter of fact, I've created two queries, they both work the same and get the same test results, The base values that is zip code are stored in one table and the address values in another.

[Pauline]

You need to have the like this set up for your Two tables, Database integration is a hallmark of ColdFusion applications.

BASE_VALUES
------------------
BASE_VALUE_PIN_CODE
BASE_VALUE_STATE_NAME

RESOURCE_VALUES
-----------------------
RESOURCE_KEY
RESOURCE_STATE_ID
RESOURCE_STATE_ADDRESS

here you need to retrieve one base value, and all corresponding translation values that match that base value, export them to excel, and then re-load them via an update.

[tomstonsils]

Here's an updated revisal of what I would LIKE the query to do, but obviously does not do since I actually need the values of the joined table, There is an inherent simplicity and flexibility to being able to create database queries on the fly, so as to be able to refer to column names to work with results.

[Pugsly]

There is also a resource key that matches each "Item Description" to a single "Item Desc in other Language". There's also a real downside to this type of database integration. After all, consider what would happen to your code if a table name changed, or if columns were refactored and split, or if whole schemas were updated.The only time they are ever going to see each other is during this translation process, all other times the values may be different.