Fred, if you are using CFMX 7, you can use the CF Administrator API. Check http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001734.htm for more.
Indy On 5/20/05, Pat Branley <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
