|
|
Posted by John Bell on 12/30/05 00:09
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/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en
SQL 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&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,DateAssigned,Status,StatusDescription,Resolution,CompletionDate)
> values(?,?,?,?,?,?)";
>
>
> Any help you can give me would be greatly appreciated.
>
> Cat
>
Navigation:
[Reply to this message]
|