Update Web Form

I'm trying to create a online update form to a SQL table.  I've never
done this function before, and I'm not quite sure I have the coding
correct. Below is the coding for the Update statement.

final String udc = "UPDATE INTO " + "Comm_WebSubmission Set ProjectID
= request.getParameter("ProjectID")
 (Assigned,DateAssign
 ed,Status,StatusDesc
 ription,Resolution,C
ompletionDate)
values(?,?,?,?,?,?)";


Any help you can give me would be greatly appreciated.

Cat

Hi Cat

Three is no update into command check out Books online for the format of any
T-SQL function. If you don't have these the latest versions can be download
from:

SQL 2005
http://www.microsoft.com/downloads/...&DisplayLang=en

SQL 2000
http://www.microsoft.com/downloads/...&DisplayLang=en

Try something like:

final String udc = "UPDATE INTO Comm_WebSubmission Set ProjectID = " &
request.getParameter("ProjectID")

As well as http://msdn.microsoft.com/default.aspx this site should help you
alot http://www.aspfaq.com/categories.asp

John

"Cat" <clequieu@nuvell.com> wrote in message
news:1135093226.741803.275230@z14g2000cwz.googlegroups.com...
> I'm trying to create a online update form to a SQL table.  I've never
> done this function before, and I'm not quite sure I have the coding
> correct. Below is the coding for the Update statement.
>
> final String udc = "UPDATE INTO " + "Comm_WebSubmission Set ProjectID
> = request.getParameter("ProjectID")
>  (Assigned,DateAssign
 ed,Status,StatusDesc
 ription,Resolution,C
ompletionDate)
> values(?,?,?,?,?,?)";
>
>
> Any help you can give me would be greatly appreciated.
>
> Cat
>