Write and if statement

[sanika1507]

Hi all

i got the part of this code i have written

Set CmdApp = Server.CreateObject("ADODB.Command")
    CmdApp.ActiveConnection = c
    CmdApp.CommandText = "sp_ Attachment"
    CmdApp.CommandType = adCmdStoredProc
 
    Set Param =CmdApp.CreateParameter("@Id",adInteger,adParamInput,4,Id)
    CmdApp.Parameters.Append Param
 
    set    RS=CmdApp.Execute
    Set CmdApp = Nothing
 

no i want to add tht if Id = 0 then i dont want to call the sp_Attachment
i tried adding it
n i m gettin error in application and it says :
Operation is not allowed when the object is closed.
how do I go on .
Please help

Thanks in advance

[markrawlingson]

"Operation is not allowed when the object is closed" Usually means that you're trying to close an object that isn't open, or you're trying to clean up an object which is open. Most likely cause of this is that you've opened your in an if statement, and you're closing the object outside of the if statement. This means that if the if statement is not true, the object will not get created.

You would want to do something like the following...

If condition = "condition" Then
   Set CmdApp = Server.CreateObject("ADODB.Command")
   CmdApp.ActiveConnection = c
   CmdApp.CommandText = "sp_ Attachment"
   CmdApp.CommandType = adCmdStoredProc
   Set Param =CmdApp.CreateParameter("@Id",adInteger,adParamInput,4,Id)
   CmdApp.Parameters.Append Param
   Set RS=CmdApp.Execute
   CmdApp.Close
   Set CmdApp = Nothing
End If
 

If condition is equal to "condition" - the object is created, your work is done, you close the object and cleanup. If condition does not equal "condition" then the object is not created, therefore there is no need to clean it up outside of the if statement.

Sincerely,
Mark