ODBiC Discussion Board


RE: OK....but what is the differenence here, Scott, 01-11-2008

Semicolon

by Tim L, January 14, 2008 22:00

I believe your problem is the semicolon. When using the second method, the semicolon is a command separator. Using the <% %> method, the code also could be be written like this...

<% 
   SET $newname$ = "" ;
   SELECT emp_id FROM employee ;
   IF $ROW$ ;
      EACHROW ;
         IF $ROW$ = 1 ;
            SET $newname$ = $emp_id$ ;
         ELSE ;
            SET $newname$ = $newname$";"$emp_id$ ;
         ENDIF ;
      ENDROW ;
   ENDIF;
%>

Notice that the semicolon is used to end each command. I surrounded the semicolon in the "SET" command with quotes so it would be taken as part of the string rather than as a command separator.


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.