New post
AllAccepted answers
Christopher Kennedy · May 12, 2020

Mr Cemper,

Thank you again for your prompt and informative response.  I was able to resolve this issue with 2 simple steps: 1. add a self signed cert to the windows server 2016 IIS Manager virtual site; and 2. specify the $domain.$tld in the https url.  Previously, I only had $site.  And yes, you are correct again,  the code I sent you is actually the asmx file which I import to ScriptLink to create the available objects from the WSDL response.  The wsdl xml is generated by the web server in response to the application level wsdl import so that I do not need to see the wsdl xml.  I realized all too late that this thread should never had been posted on the InterSystems site.   My new wsdl import which is working is:  https://$site.$domain.$tld/$virtualServer/$WS.asmx.  Where the asmx is what I sent you.  Think of asmx as pseudo xml.  Microsoft claims it is an xml format, but obviously we know it is not.

Thank you again for your prompt advise and assistance,  Chris

Christopher Kennedy · Nov 14, 2019

Hi Mike, 

While I'm not total familiar with the syntax for your ~/.{{tcsh,bash}rc|profile|...} it seems to me that the end should be:

<Location>CSP On  SetHandler csp-handler-sa</Location>

as opposed to: <Location />CSP On  SetHandler csp-handler-sa</Location>

Minor I know, and if it html syntax likely doesn't matter at all.  Still if it is in fact a {u,li}nix resource file, syntax would be important.

Chris

Christopher Kennedy · Oct 28, 2019

drop table if exists [stair];
create table [stair] (
    [purse] integer
);
insert into [stair] (purse) values(9);
insert into [stair] (purse) values(2);
insert into [stair] (purse) values(7);
--++++++
declare cursorA cursor 
for select purse from [dbo].[stair]
declare @col integer
declare @tot integer
open cursorA
set @tot = 0
fetch next from cursorA into @col
while @@FETCH_STATUS=0
begin
   set @tot = @tot + @col;
   print convert(varchar,@col) + ', ' + convert(varchar,@tot);
   fetch next from cursorA INTO @col;
end
close cursorA;
deallocate cursorA;
drop table [stair];