Insert multiple fields when callid='vcallid' problem
I'm having a heck of a time getting this to work. please note that this is my first step into SQL, JSP, ORACLE, and JDBC.
I have a database that contains a table DETAIL. in that table there are fields that i need to populate:
SURVEY_Q1, SURVEY_Q2, SURVEY_Q3, SURVEY_Q4, SURVEY_Q5, CALL_BACK, SURV_COMMENTS
but only in the row where CALLID, a field in the table (they are all on the same row) = a variable 'vCALLID'
im using dreamweaver which has created this code for me, but continues to give me a server error everytime:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="./Connections/heatdb.jsp" %>
<%
Driver DriverPrepared1 = (Driver)Class.forName(MM_heatdb_DRIVER).newInstance();
Connection ConnPrepared1 = DriverManager.getConnection(MM_heatdb_STRING,MM_heatdb_USERNAME,MM_heatdb_PASSWORD);
PreparedStatement Prepared1 = ConnPrepared1.prepareStatement("INSERT INTO HEAT.DETAIL (SURVEY_Q1, SURVEY_Q2, SURVEY_Q3, SURVEY_Q4, SURVEY_Q5, CALL_BACK, SURV_COMMENTS) VALUES ('qSurvey_Q1', 'qSurvey_Q2', 'qSurvey_Q3', 'qSurvey_Q4', 'qSurvey_Q5', 'qCall_Back', 'qSurv_Comments') where CALLID='vCALLID'");
Prepared1.executeUpdate();
%>
<!-- random html -->
<%
ConnPrepared1.close();
%>
All of the values are taken from the page survey.html. they are all <input> names i.e.:
<form name="form1" action="survey.jsp" method="post">
1: The Issue was resolved in a timely manner.
1<input type="radio" name="qSurvey_Q1" value="1">
2<input type="radio" name="qSurvey_Q1" value="2">
3<input type="radio" name="qSurvey_Q1" value="3">
4<input type="radio" name="qSurvey_Q1" value="4">
5<input type="radio" name="qSurvey_Q1" value="5">
</form>
im able to, within dreamweaver, access the table and all fields. but cant seem to insert those values into the row where callid=callid. at run time.
any help with this would be awesome, ive been googling this issue for a week now :-\
