Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank field validation
Message
From
26/03/2002 14:12:47
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Blank field validation
Miscellaneous
Thread ID:
00637433
Message ID:
00637433
Views:
51
I have a field where the most of the records is empty, how do i validate if it is empty or not?

This is mi query:

sensql="SELECT d.cod_und, d.cod_jef, d.cod_dpt, d.sig_dpt, d.des_dpt, j.sig_jef, u.sig_und, s.cod_sec, s.des_sec from m_depart d, m_jefatu j, m_unidad u,m_seccio s where j.cod_jef=d.cod_jef and j.cod_und=d.cod_und and j.cod_und=u.cod_und and d.cod_und="&rs_consulta("interfaceu")&" and d.cod_jef="&rs_consulta("interfacej")&" and d.cod_dpt="&rs_consulta("interfaced")

the problem is when i place the field to validate, so i validate it in this way but it's wrong:

if rs_consulta("interfaces")<> "" then
sensql=sensql+" and s.cod_sec="&rs_consulta("interfaces")
end if


Please help me. thanks
Next
Reply
Map
View

Click here to load this message in the networking platform