#4 quote not needed

[Anonymous]

it seems that there is a quote that is not needed and
which prevent the execution of the request :
OpenDBConnection()
' Insert the new Case in the DB
SQL = "INSERT INTO Cases ( RefSoftware, RefContact,
RefOperator, CaseOpenDate, CaseObject, CaseNature,
CaseType, CasePriority, CaseDescription, CaseConfirmed,
CaseStepToReproduce, CaseWorkaround, RefStatus,
CaseCloseDate) VALUES ( " & CStr( SoftwareRef) & ", " &
CStr( ContactRef) & ", " & CStr( Session( "RefOperator"))
& ", '" & CStr( today ) & "', " & CStr( CaseObject) & ", "
& CStr( CaseNature) & ", " & CStr( CaseType) & ", " &
CStr( CasePriority) & ", '" & CStr( CaseDescription) & "', "
& CStr( CaseConfirmed) & ", '" & CStr(
CaseStepReproduce) & "', '" & CStr( CaseWorkaround)
& "', " & CStr( CaseStatus) & ", " & CStr( CaseEndDate)
& ");"
'ObjDBConnection.Execute(SQL)
' Close the DB connection
ObjDBConnection.Close

==>'ObjDBConnection.Execute(SQL) : should be :
ObjDBConnection.Execute(SQL)

if you think I'm wrong, please let me know at
rfeingold@fr.cw.net
but doing so, I can then "insert a case" !!!

rf