Re: Error when Reusing ADO Connection & Command

MarketWizard wrote:
Hello,
it fails on the execute command within the body of the loop.
the main question is: how can you re-use a command within the body of
a loop, where with each iteration, the parameters to the stored
procedure change. I am calling a stored procedure which returns a
ref cursor. How should I re-use the connection, command, recordset?

The recordset certainly needs to be closed within the loop.

I have tried to move the creation&closing of these within the loop,
and received the same 'missing expression' error.

any idea on best practices on this? and what may be invalidating my
command (which is what I suspect is going on) thanks much in advance


I have done this many times, much the way you are doing it. again, I
cannot run your code to debug it. I'm not certain what the "missing
expression" error refers to. Could you provide the entire text of the
message?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Sol8 and EVA hangs
    ... Secure Path 3.0D is loaded for channel failover. ... retrying command ... # Adapter hard loop ID address to use on the fibre channel bus. ...
    (SunManagers)
  • Summary: Sol8 and EVA hangs
    ... Oct 8 11:00:41 proddb SCSI transport failed: reason 'aborted': ... retrying command ... # Adapter hard loop ID address to use on the fibre channel bus. ... # before reporting I/O errors. ...
    (SunManagers)
  • Re: Using foreach loop to create radiobutton menu
    ... Your foreach loop is not the problem, the problem is how you define the -command. ... The only possible thing the interpreter can do is substitute the current value of range, which is likely the last value once your loop exited. ... One choice is double quotes. ... The double quotes means that $range gets expanded while in the loop, long before the puts command actually runs. ...
    (comp.lang.tcl)
  • Re: What does Ctrl+C really do
    ... loop) to fgetsthe user's commands. ... As posted before there is a signal handler taking care of that. ... I interprete "windows terminal" as a Command Shell in MS-WIndows, ... Shell detects that the telnet client has been gone it terminates itself. ...
    (comp.os.vxworks)
  • Re: widget updating issue
    ... I have a frame with a number of labels, ... When the "Update" button is pressed I execute a linux rsh command to ... It takes about 8 seconds for the loop of 6 ...
    (comp.lang.tcl)