T
Tony J
Below is the line of code I'm having difficulties with.
cmd.CommandText = "[Msg_4_Business]"
' Execute command with required parameters
Set rsMissing = cmd.Execute(, Array(cboSurveys.Value, bNSW, bQLD, bSA, bTAS,
bVIC, bWA, "Comp1"), _
adCmdStoredProc)
This works fine, however I would like in some conditions to have the last
parameter equal to 2 values (ie "Comp1" or "Comp2")
Can I somehow pu this in the cmd.execute command? If not is there a way to
combine 2 recordsets together?
Thanks for your assistance
Tony
cmd.CommandText = "[Msg_4_Business]"
' Execute command with required parameters
Set rsMissing = cmd.Execute(, Array(cboSurveys.Value, bNSW, bQLD, bSA, bTAS,
bVIC, bWA, "Comp1"), _
adCmdStoredProc)
This works fine, however I would like in some conditions to have the last
parameter equal to 2 values (ie "Comp1" or "Comp2")
Can I somehow pu this in the cmd.execute command? If not is there a way to
combine 2 recordsets together?
Thanks for your assistance
Tony