select null value ,help!

Results 1 to 3 of 3

Thread: select null value ,help!

  1. #1
    stephic Guest

    Default select null value ,help!

    I need to set the condition if the value is "null" then doinf some action.<BR>But that null not the word null is the user didn&#039t insert record for that field. Teh null is genrated by the SQL server,<BR>how do i have to do?

  2. #2
    Join Date
    Dec 1969

    Default RE: select null value ,help!

    I believe all you need to do is<BR><BR>&#060;%<BR>dim value = rs.fields("ColName") <BR><BR>if value then <BR> &#039Value = something<BR>else<BR> &#039value = nothing<BR>end if<BR>%&#062;<BR><BR>I&#039m not completely convinced this works, I haven&#039t tested the theory, but I can&#039t see any problem why not.

  3. #3
    ANAGHA Guest

    Default RE: select null value ,help!

    say the txt field name is txtName,<BR><BR>dim cName=Request.form("txtName")<BR><BR>if len(cName)=0 then<BR>`do something<BR>else<BR>&#039do something else<BR>end if<BR><BR>Hope this helps<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts