quote:

---

Originally posted by AskSQLTeam

Pari writes "I take a date from the html form and wish to pass on to the stored procedure where the value is inserted . . .<BR><P>Article <a href="/item.asp?ItemID=226">Link</a>.

---

CREATE PROC update_issue_by_issue_id (
					@IssueID bigint,
					@CustomerID bigint,
					@SiteID bigint=NULL,
					@CommissionID bigint=NULL,
					@IssueTypeID bigint=NULL,
					@Originator varchar(50),
					@TargetDate datetime,
					@ClosedDate varchar(40)=NULL,
					@Issue varchar(8000),
					@ModifiedBy varchar(50),
					@ModifiedOn datetime
				    )
--sproc: insert_issue
--Created By: Jon Hermiz
--Created On: October 8, 2004
--Modified By:
--Modified On:
--Reason For Modification:
--Function: To insert an issue
AS
DECLARE @CD DATETIME
SELECT @CD = CONVERT(datetime, @ClosedDate)

IF @@ERROR <> 0
 /* no closed date */
UPDATE Issue SET
		CustomerID=@CustomerID,
		SiteID=@SiteID,
		CommissionID=@CommissionID,
		IssueTypeID=@IssueTypeID,
		Originator=@Originator,
		TargetDate=@TargetDate,
		Issue=@Issue,
		ModifiedBy=@ModifiedBy,
		ModifiedOn=@ModifiedOn
WHERE IssueID=@IssueID
ELSE
/*with closed date*/
UPDATE Issue SET
		CustomerID=@CustomerID,
		SiteID=@SiteID,
		CommissionID=@CommissionID,
		IssueTypeID=@IssueTypeID,
		Originator=@Originator,
		TargetDate=@TargetDate,
		ClosedDate=@CD,
		Issue=@Issue,
		ModifiedBy=@ModifiedBy,
		ModifiedOn=@ModifiedOn
WHERE IssueID=@IssueID
GO