retrieving the value of a database field - ?

[Guest]

I'm attempting to write ASP code to retrieve the value of a field returned
from a database, and then (if the value equals ZERO, either by being a zero
or being a null value), I want to assign a ZERO value to a variable.

Can anyone help me to this? I just can't figure out how to use a value
statement to retrieve the value of a database field.

Help?

 

[Stefan B Rusynko]

See http://www.w3schools.com/ado/default.asp and http://www.w3schools.com/asp/default.asp
Once you have your DB record open check the recordset for "" or null as say
IF IsNull(rs("filenamehere")) or rs("filenamehere")="" OR Len("filenamehere")=0 THEN
'script to update here
End IF
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I'm attempting to write ASP code to retrieve the value of a field returned
| from a database, and then (if the value equals ZERO, either by being a zero
| or being a null value), I want to assign a ZERO value to a variable.
|
| Can anyone help me to this? I just can't figure out how to use a value
| statement to retrieve the value of a database field.
|
| Help?