|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi All,
I have created a Stored Procedure to add these fields. Below is the code am trying to run in ASP. But getting syntax error at ",". Can anyone help me. Its urgent.. oMonitorName = Request.Form("MonitorName") oCheckInterval = Request.Form("ChkInterval") oMaxTime = Request.Form("MaxChkDuration") oRetryCheckAfter = Request.Form("RChkWarning") oRetryFailAfter = Request.Form("RChkFail") oAlertAfter = Request.Form("failuer_count") oStopAlert = Request.Form("max_alerts") oActive = Request.Form("Enabled") oMonitorType = 128 oID = GenID() oStartTime = "11:00:00" oStopTime = "23:00:00" oRegion = "SFO" oDownTime = 0 oCheck_Creds = 128 oAlert_Creds = 128 oAlert_Value = 128 If oActive = "true" Then oEnabled = 1 Else oEnabled = 0 End if strQuery = "AddMonitor " & oID & ",'" & oMonitorName & "'," & oCheckInterval & "," & oMaxTime &","& oRetryCheckAfter &","& oRetryFailedAfter &","& oAlertAfter &","& oStopAlert &","& oStartTime &","& oStopTime &","& oActive &",'"& oRegion &"',"& oDownTime &","& oMonitorType &","& oCheck_Creds &","& oAlert_Creds &","& oAlert_Value Thansks, Sameer |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > PLease help INSER INTO Syntax Error - Urgent |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|