Ask a Question related to Coldfusion Database Access, Design and Development.
-
OU_Brandi #1
CFQUERY a Remote MySQL Server
I have two networked MySQL web servers. My site root is on Server1, but I want
to interrogate a database from Server2. How do I specify in the DATASOURCE
portion of my CFQUERY that I want to do this? Below is my query...
<CFQUERY NAME="q1" DATASOURCE="[MySQL Database on Server2]">
INSERT INTO newsarticles (artid, article) VALUES(#artid#, '#article#')
</CFQUERY>
Any assistance will be greatly appreciated.
Brandi
OU_Brandi Guest
-
DW remote connection to mySQL server failure
Am trying to learn Interakt's Impakt . Could not go very far in this learning attempt as I cannot get DW to establish remote connection to the... -
Using ODBC to connect to remote MySQL server
Hi, I have two computers on an LAN. I am trying to connect a client computer to the MySQL server. I have installed unixODBC and... -
Always Applying Date Mask on cfquery (MySQL)
ColdFusion is displaying my dates in an incorrect timestamp format. I understand that the date can be masked using the DateFormat() function, but... -
PHP mysql remote testing server nightmare
Hi, I am having trouble setting up a mysql connection using dreamweaver mx 2004 on a win2k machine. The database is hosted remotely and was setup... -
Problems with CFQUERY and MySQL GROUP_CONCAT
I really need some help. This issue has plagued me for days now. I need to run the query below: SELECT GROUP_CONCAT(fname,' ',lname ORDER BY... -
Dan Bracuk #2 Re: CFQUERY a Remote MySQL Server
Set up a dsn in cold fusion administrator.
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
