How to Replace Null Values???

Varg_88 · October 6th, 2004, 08:28 AM

Hello Guyz...!

I`ve the following code:
----------
months1 = Request.Form("txtmonths")
months = replace(months1," ","0")
----------
but it`s not working. I guess that the problem is that months1 is a null value. So... what to do?

The only solution is to check if the value is null and then set it to "0"????

madhukp · October 6th, 2004, 09:19 AM

Use this code.

If(Not(IsNull(months1))) then
replace(months1," ","0")
Else
months1="00"
End If

----------------------------------------------------

To have a better solution, please give some more detail about your particular programming context.

happygv · October 6th, 2004, 09:32 PM

Hi Varg_88,

What is that you are trying to achieve?

What value does "months1" contain when NOT NULL? Can you post some real data for that here? What you want it to contain if NULL or otherwise.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Varg_88 · October 7th, 2004, 01:59 AM

Thank you for your replies...!

I`ve got a textbox where the user should put a value from 0 to 11 (this is the months values). But also I`ve give the ability to the user when he inserts "no value" in this textbox I want "0" value to be inserted into the db automatically. I hope that you can understand me now.

I found the solution with the following code:
-------
if months1 = ""
then months = 0
else
months = months1
--------
But I think that there must be a more clever way to achieve this. :)

Thank you again for your replies!

happygv · October 7th, 2004, 02:19 AM

Your solution is right though. Otherwise you can check this way that is more safer.;)

Code:

If len(months1)>0 and IsNaN(months1) and cint(months1) > 0  then 
    months = months1
else
    months = 0
End If

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

madhukp · October 7th, 2004, 02:28 AM

You can use a select box with 12 options (values going from 1 to 12). Then make the selection of some entry in it mandatory. Or make one of them selected by default.

If you are using a text box, you will have to do a number of validations. People can enter <space>0, space<1> etc. which should go correct. Then you will have to trap other characters etc.

If there are only 12 options for the select box (with values going from 1 to 12), you don't need any validation. One value from this will always be selected.

--------------------------------------------------------------------------
ps. You have to do some basic authentication works as below.
The action page for the form containing the above select box should check whether the posting has come from the correct website. Otherwise, people can copy the form from the source, change the select box as they wish, add more options and then submit by giving the full path of action page. You have to avoid this.