Here is a snippet I picked up some where for access db
CFQUERY NAME="insertdata" datasource=#REQUEST.DSNMain#>
INSERT INTO `#CurrentDirectory#DB\MERCHANT#variables.MerchantID#TEMP.mdb`.ProductLinks
(field1)
VALUES('data1')
</CFQUERY>
or use with FROM.
The datasource=#REQUEST.DSNMain# is just a dummy. The key is putting the full path and
database name with a dot table name as shown.
cheers
trent
---------- Original Message ----------------------------------
From: "Carl" <[EMAIL PROTECTED]>
Reply-To: "CFAussie Mailing List" <[EMAIL PROTECTED]>
Date: Wed, 22 Jan 2003 15:04:50 +1100
>Hi CF Aussie,
>
>just wanting to know if any know of how to set the variables of a dsn less
>connection for Cold Fusion (Running CF MX)
>
>I think it looks something like this???
>
>
>Provider=SQLOLEDB; datasource=SERVER-WHERE-SQL-SITS; Initial
>Catalogue=DATABASENAME; User ID=USERNAME; Password=PASSWORD"
>
>Carl
>
>
>
>---
>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/
>
---
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/
