It was the null value that for some reason was outputting as a string
"null". Funny thing was it only happened on the records that I had entered
using Access. The records I entered with my CF form and no value in that
field came out fine. In any case I added the function and the extra code to
that line (and a few others I wanted to make sure had nothing for output is
there was a null value <g>) and all works great.
I did want to ask a question on the syntax you used in the function. I
looked and searched the _javascript_ Docs and google and could not get any
explanation to my question.
Return(val=="null")?"":val;
What is the [ ?"":val ] code doing?
Thanks again,
Kevin
_____
Does it actually have the string "null"??
In that case:
function ReplaceNull(val){
return (val=="null")?"":val;
}
...
f.addressLine2.value = ReplaceNull(qj.getField(i,"addressLine2"));
If it is the null value:
function ReplaceNull(val){
return (val==null)?"":val;
}
Pascal
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
