I second Chris' suggestion.
I use a stub program that runs on the remote server.
it is invoked via CFHTTP
It receives a WDDX packet containing only SQL Statements (you
probably should not pass the userid and pw)
It deserializes the WDDX packet, issues the SQL query, and serializes
the record set into another WDDX packet which is returned to the
CFHTTP.
As a variation, you don't even need CF on the remote machine... the
stub could be written in Perl, ASP, PHP, whatever.
It is a great tool for migrating a db from one server to another,
back-ending one site with another, etc.
Dick
At 5:35 PM -0400 9/29/00, Christopher Olive, CIO wrote:
>why not use WDDX or something like that?
>
>write a robot like action page (no HTML) that queries the DB and wraps the
>results in a WDDX package. then on your internal page, CFHTTP to that
>external robot page, grab the packet, decode it, and go nuts.
>
>chris olive, cio
>cresco technologies
>[EMAIL PROTECTED]
>http://www.crescotech.com
>
>
>
>-----Original Message-----
>From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 29, 2000 11:13 AM
>To: CF-Talk
>Subject: How can I do this (Query external data source)?
>
>
>Please pardon the lousy subject line. I did not know how to paraphrase what
>I need to do!
>
>I have an internal web page here at work that I made in coldfusion. I also
>have another page that I made for the real world.
>
>My external site has a table with a bunch of information that website
>visitors can enter information into. (It is a registry for old Pontiacs).
>
>I want to run a query on that external site that just returns the number of
>records in the registry table. Hence, Here on my internal web page (Actually
>the "Outlook Today" page) I just want a line that says "There are X records
>in your Pontiac Registry".
>
>The dilemma, as I see it, is querying a datasource that is not on my local
>coldfusion server. If I have to, I will add a new DSN to the server that
>points to the database out there on the internet. Is this possible?
>
>--------------------------------------------
>Tim Claremont
>Xerox Corporation
>--------------------------------------------
>----------------------------------------------------------------------------
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
