Syntax Error in IF statement
am 17.02.2007 15:20:48 von Nate
I am trying to use the following IF statement, and whenever I use a
single or double quote, I receive a syntax error. When using no
quotes, the syntax is accepted, but the statement does not perform
properly.
***The problem line***
<% if violation_type=''Tardy'' THEN %>
***rest of the statement***
TARDY VIOLATIONS
<% if rs2.Fields(0) = 0 THEN %>
This is the first unexcused Tardy violation for this employee. A
coaching is required. Click to issue the
coaching.
<% ELSE %>
This employee has <%response.write(rs2.Fields(0))%> previous
violations.
<% END IF %>
<% ELSE %>
The <%response.write(violation_type)%> violation has been recorded.
<% END IF %>
Variables defined:
violation_type = request.form("violation_type")
Any ideas?
Re: Syntax Error in IF statement
am 17.02.2007 15:31:34 von Anthony Jones
"Nate" wrote in message
news:1171722048.402560.76860@l53g2000cwa.googlegroups.com...
> I am trying to use the following IF statement, and whenever I use a
> single or double quote, I receive a syntax error. When using no
> quotes, the syntax is accepted, but the statement does not perform
> properly.
>
> ***The problem line***
> <% if violation_type=''Tardy'' THEN %>
Are you saying the above line as it is generates a syntax error??
Re: Syntax Error in IF statement
am 17.02.2007 15:38:35 von Nate
For some reason, it was. I loaded the code up into Source Edit and
made some changes to other parts of the code, and suddenly it worked.
I appreciate you taking the time to reply - must have been a fluke :-\
On Feb 17, 8:31 am, "Anthony Jones" wrote:
> "Nate" wrote in message
>
> news:1171722048.402560.76860@l53g2000cwa.googlegroups.com...
>
> > I am trying to use the following IF statement, and whenever I use a
> > single or double quote, I receive a syntax error. When using no
> > quotes, the syntax is accepted, but the statement does not perform
> > properly.
>
> > ***The problem line***
> > <% if violation_type=''Tardy'' THEN %>
>
> Are you saying the above line as it is generates a syntax error??