Connecting Tech Pros Worldwide Forums | Help | Site Map

Syntax Error in IF statement

Nate
Guest
 
Posts: n/a
#1: Feb 17 '07
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 <A HREF=blah>HERE</Ato 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?


Anthony Jones
Guest
 
Posts: n/a
#2: Feb 17 '07

re: Syntax Error in IF statement



"Nate" <nate.borland@westecnow.comwrote in message
news:1171722048.402560.76860@l53g2000cwa.googlegro ups.com...
Quote:
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??


Nate
Guest
 
Posts: n/a
#3: Feb 17 '07

re: Syntax Error in IF statement


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" <A...@yadayadayada.comwrote:
Quote:
"Nate" <nate.borl...@westecnow.comwrote in message
>
news:1171722048.402560.76860@l53g2000cwa.googlegro ups.com...
>
Quote:
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.
>
Quote:
***The problem line***
<% if violation_type=''Tardy'' THEN %>
>
Are you saying the above line as it is generates a syntax error??

Closed Thread