SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Default Values...

    Hi,

    I am a bit of a newbie to MS Access and I am wondering how to set a field in a table to have a default value, even when the record has been updated.
    I am using an ASP upload script which enables the user to insert multiple files from one page. The problem being when one of the file fields is left blank and a blank value is entered into the db and the default value of 'empty' is removed. (I am needing this default value for a different script)

    Basically, what I am trying to do is specify in Access that if the field is blank to assign a value of 'empty' to it.

    Any ideas anyone? Any help is appreciated.

  2. #2
    SitePoint Wizard creole's Avatar
    Join Date
    Oct 2000
    Location
    Nashvegas Baby!
    Posts
    7,845
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could use your FORM processing page to check if each field contains a value. If it does, use that value, if not then us "" (or null).
    Adobe Certified Coldfusion MX 7 Developer
    Adobe Certified Advanced Coldfusion MX Developer
    My Blog (new) | My Family | My Freelance | My Recipes


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •