Getting type mismatch error '[string : " "]'

**jhardman** · Oct 27 '09, 02:45 PM

Could you confirm the line number? Are you getting the error on the following line?

Code:

<%If vdobyyyy mod 4 = 0 And vdobmm = 2 Then

If so, please try the following just to make sure it works

Code:

<%dim vdobyyyy_alt
vdobyyyy_alt = 1976
If vdobyyyy_alt mod 4 = 0 And vdobmm = 2 Then

If that works, then I think I know what the problem is.

Jared

**vikas251074** · Oct 28 '09, 04:41 AM

Yes the problem lies in line no. 362

But this may not be the solution as value may change everytime.

I have already tried this way.

**jhardman** · Oct 28 '09, 03:54 PM

I wanted you to try that to narrow down the problem, not because I thought that was a good solution. The problem is that dobyyyy doesn't necessarily contain an integer year. Try to

Code:

response.write "<!-- year is " & dobyyyy & "-->" & vbnewline

, if the year looks right but still gives you the error, then you probably have dobyyyy saved as a string. You can solve this when you assign the variable by doing

Code:

dobyyyy = cint(expression that generates the variable now)

If the year doesn't write out correctly, then you are not forming the year correctly.

Jared

**vikas251074** · Oct 29 '09, 05:19 AM

All the problem lies in between line no. 342 and 377 where scripting for date of birth is written. This code is again displaed in this reply.

In the below code of scripting of date of birth, line no. 4 vdobyyyy assigns 0 value by default if nothing is selected so that it may not give error while saving records in oracle. Is this process wrong?

No other places is where vdobyyyy is assigned value. but the value of vdobyyyy is initialize two times in line no. 68 and 275 in the full code given in first thread which is called through <include> tag. the details of include tag is given below this code.

Code:

              <td align="right"><font face="arial" size=2>Date of Birth : </font></td> 
              <td> 
                <select name="vdobyyyy" value="<%=vdobyyyy%>"> 
                  <option value="0">Select</option> 
                  <%i=1947 
                  do while i <= Cint(year(date())) - 18%> 
                        <option value="<%=i%>"><%=i%></option> 
                    <%i = i + 1 
                  loop%> 
                </select> 
                <select name="vdobmm" value="<%=vdobmm%>"> 
                  <option value="0"></option> 
                  <%i=1 
                  Do while i <= 12%> 
                      <option value="<%=i%>"><%=i%></option> 
                    <%i = i + 1 
                  loop%> 
                </select> 
                <select name="vdobdd" value="<%=vdobdd%>"> 
                  <option value="0"></option> 
                  <%If vdobyyyy mod 4 = 0 And vdobmm = 2 Then 
                    no_of_day = 29 
                  ElseIf vdobyyyy mod 4 <> 0 and vdobmm = 2 Then 
                    no_of_day = 28 
                  ElseIf vdobmm=4 or vdobmm=6 or vdobmm=9 or vdobmm=11 Then 
                    no_of_day = 30 
                  Else 
                    no_of_day = 31 
                  End If 
                  i=1 
                  Do while i <= no_of_day%> 
                      <option value="<%=i%>"><%=i%></option> 
                    <%i = i + 1 
                  loop%> 
                </select> 
              </td>

Code of 'clear_sabf_for m_var.inc'

Code:

'CLEAR THE FORM VARIABLES
<%
    vempno = ""
    vempname = ""
    vdesign = ""
    vsex = ""
    vgrade = ""
    vcategory = ""
    vdobyyyy = "0"
    vdobmm = "0"
    vdobdd = "0"
    vdojyyyy = "0"
    vdojmm = "0"
    vdojdd = "0"
    vdosyyyy = "0"
    vdosmm = "0"
    vdosdd = "0"
    vdojgryyyy = "0"
    vdojgrmm = "0"
    vdojgrdd = "0"
    vdobosyyyy = "0"
    vdobosmm = "0"
    vdobosdd = "0"
    vreason = ""
    voption = ""
    vcommutation = ""
    vrehabilitation = ""
    vBasic2003 = "0.00"
    vstag2003 = "0.00"
    vpersonalpay2003 = "0.00"
    vsplpay2003 = "0.00"
    vadhoc2003 = "0.00"
    vnpa2003 = "0.00"
    vda2003 = "0.00"
    vprotectpay2003 = "0.00"
    vBasic = "0.00"
    vstag = "0.00"
    vpersonalpay = "0.00"
    vsplpay = "0.00"
    vadhoc = "0.00"
    vnpa = "0.00"
    vda = "0.00"
    vprotectpay = "0.00"
    vbeneficiaryspouse = ""
    valtnominee1 = ""
    valtnominee2 = ""
    valtnominee3 = ""
    valtnominee4 = ""
    valtnominee5 = ""
    valtnominee6 = ""
    vaddress = ""
    vcontact = ""
    vassesseno = ""
    vannuityno = ""
    vannuityamt = "0.00"
    v1third = "0.00"
    vrefund = "0.00"
    vmonthlypension = "0.00"
    vchoiceopt = "0.00"
%>

**vikas251074** · Nov 4 '09, 03:33 PM

Sir

Here in this code where vdobyyyy is not assigned but only value is selected by selecting. So how can I cast the value to integer.

**jhardman** · Nov 5 '09, 03:57 PM

Originally posted by vikas251074

Sir

Here in this code where vdobyyyy is not assigned but only value is selected by selecting. So how can I cast the value to integer.

you can cast a value to integer by using the cint() command. Example:

Code:

vdobyyyy = cint(request("vdobyyyy"))

but you are setting vdobyyyy = "0" in the include file, this makes it a string, not an integer. look at this example

Code:

vdobyyyy = 0 'this is an integer
vdobyyyy = "0" 'this is a string
vdobyyyy = cint("0") ' this is an integer

Does this make sense so far?

You are trying to do math against a string. If vdobyyyy is a string, and you say

Code:

<%If vdobyyyy mod 4 = 0 And vdobmm = 2 Then

then you will get an error - strings can't be evaluated by the 'mod' function, only numbers. If you want to keep vdobyyyy as a string, then you will need to do the math like this:

Code:

<%If cint(vdobyyyy) mod 4 = 0 And vdobmm = 2 Then

Do you see the difference? The other option is to keep only an integer in vdobyyyy.

Jared

**vikas251074** · Nov 7 '09, 05:42 AM

Yes sir,

If I set the value of vdobyyyy in include file as follows :

vdobyyyy = 0

then the problem may be solved

Regards

Vikas

Getting type mismatch error '[string : " "]'

Getting type mismatch error '[string : " "]'

Comment

Comment

Comment

Comment

Comment

Comment

Comment