[thelist] Altering Design of AccessTable from Coldfusion

[jon steele]

Thanks Matt.

Yes testing on an exact non-live copy of the db is possible. Will definitely make sure I do that
:o

But what SQL would I use? I am not really familiar with advanced SQL used to alter tables in
Access. So I guess this is more of an Access SQL question...

Jon

--- matt g <mrg at members.evolt.org> wrote:
> > From: jon steele <jjsteele22 at yahoo.com>
> > I was wondering how to change the design of an Access table via sql from
> > coldfusion? Can this be
> > done with a sql query or is something else needed?
>
> You can save a file with
> <cfquery name="addindex" datasource="yourdsn">
>     WHATEVER SQL WORKS WITH YOUR DB HERE ;
> </cfquery>
>
> Just put it on the server and type in the URL. It will either work, or throw
> an error with diagnostics.
>
> It is advisable to try the SQL on a non-live db if you have that option.
> Otherwise it can get pretty sloppy before you get it right.
>
> matt
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/