Results 1 to 2 of 2

Thread: verfifying data b4 overwriting database

  1. #1
    Guest

    Unhappy

    Hi there....... I would like some help in trying to write data to specific fields of an Access database using vbscript in my ASP file. My intention is the following:

    I need my local web page to be able to write data to AccessDatabase as soon as it is requested. Several fields in a given table must be able to be over-written if requested.

    For example how would I first check the values and then write to the fields Month and Day of a given table?


    Your suggestions are very much needed and appreciated. Thanks.

  2. #2
    Frenzied Member
    Join Date
    Aug 2000
    Posts
    1,539

    hmm

    well to check whats in those fields before you over write them....
    you must read the information from the fields

    then after you do that

    check the information depends on what you want to check it againts

    so if you want to override a field that has nothing only spaces for example you
    go
    Code:
    if Trim(RS("Myfield")) = "" then 'this checks to see if whats in it is spaces
       RS("MyField") = "my donkey name"
    end if
    from what i gathered from your questions.. that is what i thought you mean
    if thats not what you want
    please make yourself clear
    thanks


Posting Permissions

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



Click Here to Expand Forum to Full Width