Update Web Form

[Cat]

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,DateAssigned,Status,StatusDescription,Re solution,CompletionDate)
values(?,?,?,?,?,?)";
Any help you can give me would be greatly appreciated.

Cat

[John Bell]

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/d...DisplayLang=en

SQL 2000
http://www.microsoft.com/downloads/d...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" <cl******@nuvell.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.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,DateAssigned,Status,StatusDescription,Re solution,CompletionDate)
values(?,?,?,?,?,?)";
Any help you can give me would be greatly appreciated.

Cat