How to add a dsn via serviceFactory.
http://www.petefreitag.com/item/152.cfm
Note: this is an unsupported feature.
<cfquery> select * from #tableToVerify# </cfquery
then use: query_name.columnList
This will give you a list of the column names returned.
Im not sure if access has a way of getting table names and column lists via the in-built tables like SYSCOLUMNS in sql server. but check MSDN for the Jet database engine docs. you may find some info.
Pat
Lecul, Fred wrote:
Hi
I want to be able to dynamically set up a datasource to an access database, verify fields and number of rows and then delete the datasource.
Is using the ServiceFactory the way to go? Is there any help on this in the CF world?
Thanks
Fred
************** IMPORTANT MESSAGE **************
This e-mail message is intended only for the addressee(s) and contains information which may be confidential.
If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line.
***************************************************************
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
