sql statement

[ebarratt]

Does that look right especially the dteVARIABLENAME variables in the stored procedure call? I'm taking values from a textbox in format xx/xx/xxxx.

strSQL = "spUpdatePromotionAssignment " &_
intIssueNumber & ", " &_
intAssignNumber & ", " &_
intAssignTeam & ", " &_
intAssignCell & ", " &_
intAssignType & ", " &_
"'" & strAssignAbbrev & "', " &_
intAssignStatus & ", " &_
intAssignOwnerCode & ", " &_
"'" & dteAssignDueDate & "', " &_
"'" & dteAssignStatusChangeDate & "', " &_
"'" & strAssignDescription & "', " &_
intApprovedBy & "," &_
"'" & dteApprovedDate & "', " &_
intAssignOriginatorCode & ", " &_
"'" & strContactInfo & "', " &_
intModifiedBy & ", " &_
"'" & dteModifiedDate & "', " &_
"'" & strPromotionType & "', " &_
"'" & strImplementorNumber & "', " &_
"'" & strTargets & "', " &_
intEnvironmentId & ", " &_
intObjectNameId & ", " &_
intObjectTypeId & ", " &_
intAwwStandard & ", " &_
"'" & strAssociatedObjects & "' " Errol Barratt
856-697-1593
New Jersey

 

[Ladyhawk]

Does it give any errors? Ladyhawk.
** ASP/VB/Java Programmer **