It works in another page but not here grrrrrrrr. Any thoughts??


<form name="openedticket">
  <p><select name="open" size="1">
    <option value="NULL">LIST OF OPEN TICKETS BY PSAP</option>
    <option><% Do While Not rs.EOF Response.Write ("<OPTION value='"& rs("PSAP") & "'>" & rs("PSAP")) rs.MoveNext Loop rs.Close Set rs=Nothing %></option>
  </select><input type="submit" value="View">&nbsp;&nbsp;&nbsp; </p>
</form>


Microsoft VBScript compilation error '800a0401'

Expected end of statement

/Smc/ticket/view_tickets.asp, line 27

Do While Not rs.EOF Response.Write ("<OPTION value='"& rs("PSAP") & "'>" & rs("PSAP")) rs.MoveNext Loop rs.Close Set rs=Nothing
---------------------------------------------------------------------------------------^

Might I suggest this? The problem might be having code on the same line.

<form name="openedticket">
  <p><select name="open" size="1">
    <option value="NULL">LIST OF OPEN TICKETS BY PSAP</option>
    <% Do While Not rs.EOF
        Response.Write ("<OPTION value='"& rs("PSAP") & "'>" & rs("PSAP") & "</option>")
        rs.MoveNext
    Loop
    rs.Close
    Set rs=Nothing %>
  </select><input type="submit" value="View">&nbsp;&nbsp;&nbsp; </p>
</form>

Peter
------------------------------------------------------
Work smarter, not harder.

Problem solved. Thank you very much :D