RE: OK....but what is the differenence here, Scott, 01-11-2008
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.
Name E-mail optional TopicMessage:
HTTP Link: Link text: