|
Home > Archive > Microsoft SQL Server forum > December 2005 > Update Web Form
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| John Bell 2005-12-29, 8:24 pm |
| 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
>
|
|
|
|
|