do you know how to set up a DSN? the only thing you'll do differently, is in
the CF admin console, use the server name of the second machine where the
database is kept.
queries are just the same. the fact that the database is on a second machine
(assuming it's networked somehow) is handled by the DSN. just use the
datasource name you give it when you write your query.
if i'm missing something that makes this more complex, let me know...
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 8:49 AM
To: CF-Talk
Subject: RE: Query Question
Can you write me a sample query?
Rich
-----Original Message-----
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 11:32 AM
To: CF-Talk
Subject: RE: Query Question
sure. you can make a DSN on machine 1 for a database on machine 2.
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 8:31 AM
To: CF-Talk
Subject: Query Question
Is it possible to query a database on a different server? What I mean is
can I have a template located at http://www.site1.com query a database
located at http://www.site2.com assuming I have the propper user id and
password?
Thanks,
Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists