CoverYourASP --> Snippets

Free membership

Join in the fun! Sign in
Member Services

Site navigation
Download the entire site!
Search my articles
Free Magazines
Browse the directory

Send me feedback
Buy my boxer shorts

Recommend this page
Printer-friendly page

Resources I recommend
Link to my site
Advertising slashed!
About your privacy
Legal stuff
Site statistics
16 active users
1390 visitors today
1232 pages today
(only part of today)
Tools I use

Copyright © 1999-2016 James Shaw.
All rights reserved.

RSS submissions

Now open source with SourceForge!

"Snippets" are mini-articles - they allow me to very quickly add answers to your frequently asked questions, and add brief explanations for topics that you've searched for without success. So, everytime you send an email or perform a search, chances are a new snippet will be the result!

18 Sep: Using ALTER TABLE to add a new field to my database

When I created the new section on the front page I needed to add it to the personalize page so that you could turn it on/off. So I needed a new YesNo field in the Members table.

Rather than download my Access database, modify it and upload it again (taking down the site in the process) I simply created a simple temporary page that contained the following:

DBInitConnection ( );

oConnection.Execute ( 'ALTER TABLE Members ADD bSuggestions YESNO DEFAULT No' );

This modified the database online ready for me to upload the new code.

Featured sponsor
My favorite resources

I share my content

Supporting ASPRSS

Do you need a quick and easy way to link to my articles? All the information you need is published with ASPRSS...

See my source code
wherever you see this icon...

You can also download the entire site source code for FREE!