DSN issues aside, I would avoid using DBF's from CF because although you can
delete records from the DB with an SQL statement, you have to perform a PACK
on the table before they are actually physically removed.
And guess what, it isn't possible to PACK the DB from Coldfusion without an
external application or CFX.
Regards
Michael O'Reilly
Analyst Programmer
TransAer
-----Original Message-----
From: Helge Hetland [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2000 15:26
To: '[EMAIL PROTECTED]'
Subject: DBASE
Is it possible to register a dbase in CF admin once and then use the same
dsn name in many directories?
I'll have multiple directories/users that will need to use a database with
identical tables but with different content.
I need the syntax for something like this:
<cfquery name="Testdata" datasource="/www/users/username/db/db.dbf">
select bla,bla,bla
</cfquery>
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
