Question Andy Stobirski · May 21, 2022 ZEN - Getting currently logged in user name Hi all I'm working in Zen - how might I get the name of the currently logged in user? Andy #ZEN #Caché 0 2 0 243
Question Andy Stobirski · May 19, 2022 %CSP.StreamServer not fully downloading file Hi I have a few Zen pages, one of which is implementation of %CSP.StreamServer which I'm using to download a PDF file, however, any file downloaded is 5Kb smaller than the original. This is the code I'm using: #ZEN #InterSystems IRIS 0 1 0 229
Question Andy Stobirski · May 18, 2022 Downloading files from ZEN pages Hi all I have a Zen page which displays the contents of a table. One of the columns is a file path to a file on a local disk. Is it possible, on a Zen page, to allow that file that described by the file path to be downloaded when a hyperlink is clicked on? Cheers #ZEN #Caché 0 7 1 384
Question Andy Stobirski · May 6, 2022 User code location Hi Does anyone know where the user generated code resides, the stuff one might write for a production, I presume it lives in a table somewhere within a database? Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know I can export it to an XML file and work on that, but direct access on a table would be quicker for me. Cheers #Databases #Caché 0 1 0 190
Question Andy Stobirski · Apr 21, 2022 Using host variables with embedded SQL isn't working for me Hi I'm using an embedded SQL statement with a a cursor-based Embedded SQL query that uses host variables in the where clause, however, what I'm doing doesn't seem to work. Can anyone help? The code I'm using is #SQL #InterSystems IRIS 1 15 0 324
Question Andy Stobirski · Mar 15, 2022 How to use LOAD DATA How do I use the LOAD DATA command as described here. I have the following LOAD DATA statement: LOAD DATA FROM FILE 'E://Temp/Values.txt' into PARIS.UAGU_MNDOOUT1 (AHSU_ID, AHSU_UAG_ID) Where do I run it? It doesn't work in the SQL Gateway, in the terminal, in an embedded SQL command. What am I missing? #SQL #InterSystems IRIS 0 2 0 338
Question Andy Stobirski · Feb 12, 2022 Encoding XML carriage return / line feed Hi I'm using %XML.Writer to write XML files from a database source, and I see that it is not encoding carriage return or line feed as 
 and 
 respectively, and is instead leaving them unencode. What can I do to have them encoded? Andy #ObjectScript #XML #Caché 0 3 0 2.7K
Question Andy Stobirski · Dec 29, 2021 Adding multiple namespaces in an XML file Hi I'm using a class which extends %XML.Adaptor adaptor and I want to create an XML file with multiple namespaces, like the following: <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> </soap> However, I don't see how to do this with the code I have. So far, I have #ObjectScript #XML #InterSystems IRIS 0 2 0 477
Question Andy Stobirski · Dec 22, 2021 Studio classes tree items with italics Hi I have a question about something in Studio that has been bugging me for a while. Why does the font of some items in the Classes treeview (View > Class View) appear in italics whilst others do not? Cheers Andy #Studio #Other 0 2 0 321
Question Andy Stobirski · Dec 13, 2021 Log4Shell Apache exploit / Intersystems products Hi everyone I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything? Andy #Caché 0 7 0 794
Question Andy Stobirski · Nov 23, 2021 Not all XML child items are loaded into a class list when using XML.Reader correlate Hi all I'm new to ObjectScript and I've been experimenting the correlate method of %XML.Reader to convert an XML file I've loaded into its corresponding class. But, I have found that I am not getting all the child items of an element in a List contained within the converted class, only the last item. The XML file content is as follows: #ObjectScript #XML #InterSystems IRIS 0 6 0 387
Question Andy Stobirski · Nov 11, 2021 Alternative applications to SQL Portal Hi Guys I'm rather new to HealthConnect, and I've been doing a lot of work with the browser based SQL portal and don't particularly like it. Is there an alternative application that I can use, something like SQL Express or VScode with a plugin? Andy #SQL #InterSystems IRIS 0 4 0 382