IF-Else

[oracle]

<%do while not rs.eof

If IsNull(rs("inception_date")) then

If date_of_offer >= #" & DateAdd("d",Date(),(u_input*-30)) & "# And
date_of_offer <= #" & dateadd("d",Date(),((u_input+1)*-30))) & "# then%>

<tr>
<td>
<%= rs("ceding_co") %>
</td>

<td>
<%= rs("buss_type") %>
</td>
<td>
<%= rs("major_class") %>
</td>

<td>
<%= rs("vehicle_no") %>
</td>
<td>
<%= rs("inception_date") %>
</td>

<td>
<%= rs("expiry_date") %>
</td>

<td>
<%= rs("insured") %>
</td>

<td>
<%= rs("sum_insured") %>
</td>

<td>
<%= rs("prov_gross_premium") %>
</td>

<td>
<%= rs("risk_status") %>
</td>

<td>
<%= rs("date_of_offer") %>
</td>

<td>
<%= rs("u_input") %>
</td>

<% End If


Getting the following error:
Error Type:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
If date_of_offer >= #" & DateAdd("d",Date(),(u_input*-30)) & "# And


How do I resolve the If-Else statement. Please someone show me the right way of writing the statement.TQ.

[hinch]

its


if xxx then

else if yyy then

end if


but in your case your nesting 2 IF statements so your simply missing an end if from the bottom :)

also turn off friendly error messages in IE will help you alot and if you have admin access over the IIS server then install my 500.100.asp debug page it'll save you a ****load of time with debugging your app

<%do while not rs.eof

If IsNull(rs("inception_date")) then

If date_of_offer >= #" & DateAdd("d",Date(),(u_input*-30)) & "# And
date_of_offer <= #" & dateadd("d",Date(),((u_input+1)*-30))) & "# then%>

<tr>
<td>
<%= rs("ceding_co") %>
</td>

<td>
<%= rs("buss_type") %>
</td>
<td>
<%= rs("major_class") %>
</td>

<td>
<%= rs("vehicle_no") %>
</td>
<td>
<%= rs("inception_date") %>
</td>

<td>
<%= rs("expiry_date") %>
</td>

<td>
<%= rs("insured") %>
</td>

<td>
<%= rs("sum_insured") %>
</td>

<td>
<%= rs("prov_gross_premium") %>
</td>

<td>
<%= rs("risk_status") %>
</td>

<td>
<%= rs("date_of_offer") %>
</td>

<td>
<%= rs("u_input") %>
</td>

<%
end if
End If

[BarrMan]

If date_of_offer >= DateAdd("d",Date(),(u_input*-30)) And date_of_offer <= dateadd("d",Date(),((u_input+1)*-30))) then%>