Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Blank field validation
Message
De
26/03/2002 14:12:47
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Blank field validation
Divers
Thread ID:
00637433
Message ID:
00637433
Vues:
50
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform