Hi Guy,
You can do table alteration via SQL.
I refer you to the following resource which describes
"Jet SQL" and amoung other things how to create/alter
tables via SQL:
http://www.citilink.com/~jgarrick/vbasic/database/jetsql.html#ddl
I do have a few other suggestions for you.
1) Get them to use SQL Server (you can access a SQL
Server database remotely, and make changes to it, and
it will not even take down the site while you're
making changes). This is going to be difficult with
your $0 budget though.
2) Sometimes you can "break the lock" that's on the
SQL database by doing a query with a non-existant
field name in it. This will cause ColdFusion/ODBC to
throw an error and for some reason break the lock on
the database. This would let you upload a new
database (but you still have the synchronization
problems to contend with)
3) Move to a hosting provider like EDGEWEBHOSTING.COM
that gives you utilities to start and stop coldFusion
yourself AND to add Datasources yourself (I don't
think this company charges for that at all and they
have very competitive rates)
Hope something here helps you out.
Eron Cohen
-----Original Message-----
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 11:15 AM
To: CF-Talk
Subject: Remote DB Alteration
Hello CF'ers
Situation:
Database and sites hosted externally, site created
internally.
Currently if any changes to the datasource's structure
are made they
are made locally and then uploaded to the host, who
has to shut off
the CFServer and restart it. This requires scheduling
a time and is
unacceptable. Also, the uploaded datasource may
corrupt/overwrite the
data as it is not up to date. Employer will not spring
for extra
datasources to be hosted. ( multiple applications and
domains, one
datasource, yay! ;) )
Goal:
To be able to add tables to the datasource without
scheduling a
shutdown and uploading entire datasource.
Resources:
MS Access 97
CF 4.5
CuteFTP
Budget =$0
Is this possible? Please direct me to resources that
will show me how.
Also, anyone know what the 20 or so CFML tags
supported by CFExpress
are?
Yours In Conservation,
Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262
P.S. You may want to check out the fresh new look of
www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your
bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades
1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog
Heritage.
www.AHTV.com - Your online companion to the Angler and
Hunter
Television show.
www.OHEP.net - Where to find out and learn about the
Ontario Hunter
Education Program.
------------------------------------------------------------------------------------------------
Archives:
http://www.mail-archive.com/[email protected]/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists
or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
