Shane, No, I was not familiar with DbLink, but I will check it out, thanks for the suggestion. I remember using database link objects in Oracle and they really helped, but had always read they did not exist in postgres. I will see if DbLink can work in my case: the tables I need to query from are in a postgres 8.4 database on one server, the table I need to insert to is in a postgres 7.4 database on another server. Thanks again, Julie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
