Hi guru guys,
I have serious problem. At first sight it looks very simple but i dont
have any idea how to solve it.
With this statement 'If len(rs_cit) = 0 then rs_cit = 0' I cant put
into variable 'rs_cit' value '0' if it is clean. There is no value in
html displayed.
Here is code:
....
Dim rs_customer, rs_cit, rs_total, rs_manual
i = 1
Do While Not RS.Eof
rs_customer = RS("customer")
rs_account = RS("account")
rs_cit = RS("cit")
rs_total = RS("total")
rs_manual = rs_total - rs_cit
If len(rs_cit) = 0 then rs_cit = 0
'neither this does not work: If rs_cit = "" then rs_cit = 0
response.write ("<tr>")
response.write ("<td bgcolor='black' align='right'>" & i & ".</td>")
i = i + 1
response.write ("<td bgcolor='black'>" & rs_account & "</td>")
response.write ("<td bgcolor='black'>" & rs_customer & "</td>")
response.write ("<td align='center' bgcolor='#666666'>" & rs_cit &
"</td>")
response.write ("<td align='center' bgcolor='#666666'>" & rs_manual &
"</td>")
response.write ("<td align='center' bgcolor='#666666'>" & rs_total &
"</td>")
response.write ("</tr>")
RS.MoveNext
Loop
....