Expected 'End' error. HELP!!!

[roaml]

Hi,

I receive a SQL error (below) and cannot find my error. Am I not closing the SQL statement correctly?

Error Type:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'
/project/project_form.asp, line 367

<%
MySQL = &quot;Insert into wo_table (status) Value('&quot;&status&&quot;');&quot;
%>

<Table>
<tr>
<td class=&quot;small&quot; colspan=&quot;2&quot;><li class=&quot;bullettext&quot;><strong> PROJECT INFORMATION</strong></td>

<td>Project Status:
<select name=&quot;project_status&quot; tabindex=&quot;4&quot;>
Line 367 Error------- <option><strong><%=RS(&quot;project_status&quot%></strong></option>
<option value=&quot;Open&quot;>Open</option>
<option value=&quot;Closed&quot;>Closed</option>
<option value=&quot;Pending&quot;>Pending</option>
</select>
</td>
</tr>
</Table>

 

[Shaggs]

you need to use the key word 'values' not 'value'

 

[roaml]

Hello Shaggs, I changed the 'value' to 'values' and I am still receivng the same error message.

This is so frustrating!

 

[Chopstik]

Your code as posted here looks ok. But where are you creating the RS recordset? Can you post that code so that we can see the values returned? I suspect that the error lies in that part of your code.

Incidentally, the MySQL you posted above is an INSERT statement and does not create a recordset, so am not sure where is the SELECT statement that would return the RS(&quot;project_status&quot variable.

-----------------------------------------------------------------------------------------------------
&quot;If you can't explain something to a six-year-old, you really don't understand it yourself.&quot;
-- Albert Einstein