Howdy,

Quick question. I want to copy a database that is in another server then
populate it into a local server. I have manage to do it locally but I'm
having trouble with the syntax with the from statement being the other
server. Below....

<cfquery datasource="db" name="GetTable">
 SELECT *
 INTO tbl_test_cc
 FROM nameserver.databasename.tablename
</cfquery>

Anyideas



---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to