Inserting into dynamic datasources (CF MX)

[stas]

I need to be able to create MS Access databases on the fly and insert
records into them. CF knowledge base has an article on getting data from an
external Access database by setting up a dummy passthrough database and then
referencing the external MDB via an IN clause, as in:

<cfquery name="test" datasource="dynamicMDB">
   SELECT FirstName
   FROM Employees
   IN 'C:\mysite\db\cfsnippets.mdb'
</cfquery>

I need to insert into an external database, can this be done in a similar
manner?

Thanks,

stas

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---