[thelist] SOLVED! Altering Design of AccessTable from Coldfusion

[jon steele]

Solved! For those who are interested, I used the CREATE INDEX statement:

CREATE UNIQUE INDEX index_name ON table_name (field_name) WITH DISALLOW NULL;

:) Jon

--- jon steele <jjsteele22 at yahoo.com> wrote:
> 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/
> --
> 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/