Session variables in sql statements

[namrata suri]

Hi,

I have written a form in an jsp which accepts three values .Apart from this I also have drop down menu from which a value is selected.

These four values are now accessed in the second jsp where I am putting these values into a database.

Here is the code:

<sql:update>
INSERT INTO temp(id,job_title,email,country) VALUES (?,?,?,<%=request.getParameter("countries") %>)
<sql:param value="${param.id}" />
<sql:param value="${param.jt}" />
<sql:param value="${param.email}" />

</sql:update>

I tried putting the <%= ... %> part in double quotes as well but am getting an error as follows:

Column 'India' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement........

The value of the session variable is getting reflected correctly but is not getting inserted into the table.

[David Newton]

Why are you treating the "country" column differently than all the rest? And if you're inserting a single country, why is the parameter called "countries"?