PDA

Click to See Complete Forum and Search --> : verfifying data b4 overwriting database


Sep 25th, 2000, 09:46 AM
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.

kovan
Sep 25th, 2000, 09:53 AM
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

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