Thanks That's a great help! All sorted.
-----Original Message----- From: Indy Nagpal [mailto:[EMAIL PROTECTED] Sent: Friday, 20 May 2005 5:18 PM To: CFAussie Mailing List Subject: [cfaussie] Re: dynamic datasource 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/ --- 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/
