InterSystems Caché is a multi-model DBMS and application server
I am trying to fetch the data from cache database. But i got the error like "CSP application closed the connection before sending a responce".
Below is the query.
SELECT
CallbackComment
FROM SQ.CBPhoneResult_View Where PhoneDateODBC = '2018-04-09'
I have investigated and found that "CallbackComment" contains the special character single quotes " ' " for one result and due to this i got this error.
In this field data is enter by customer. so we cannot restrict them like Do Not use single quotes.
I would like to start a discussion regarding Caché Objects and Caché SQL.
It is my understanding that the creators of Caché Objects see Caché SQL as the reporting arm of Objects and as such SQL is essential to Caché Objects.
I once met a Caché Objects programmer who was writing code to $Order through the Globals because that person thought that Caché SQL was too slow and inefficient. I attempted to convince the person otherwise.
So, what say you? Is SQL essential to Caché Objects?
Or
Hi Community!
Sometimes I meet a method which accepts 10+ parameters.
And often I need only the 8th parameter to pass. And I call the method something like:
do ##class(Some.Feature).Method(,,,,,,,"flag")And I don't like this method when I call it like this cause, you know, often I just miss the number of commas and raise some other flag I wanted.
How do you avoid this situations?
If you meet such a code, how do you call it and sure that you didn't miss the number of ","?
What is a good number of parameters in a method and f you need to pass more parameters in a method what do you do?
The dataCombo property columnHeaders is a comma-delimited list of column headers displayed in the dropdown list.
Comma is a delimiter.
But, if I want add comma to columh header, for instance "House number, apartment" - this is value for header of one column.
How can I escape comma in this case?
"House number\, apartment" - is not working.
This post is originally posted on GitHub.
This discussion is open to anyone who use or know about WebTerminal project. It is a result of a long story of the project development, testing and maintaining.
hi
I query large mount of rows from one table with JDBC, and will prompt <store> error. I found that it was out of process memory (default 16M, max 49M in version 2010.2) .
so my question is : how to release memory for large mount of rows query? or how to resolve this error?
Hi, Community!
Last weekend we held the Final of InterSystems Contest on InterSystems Caché and DeepSee as a part of IT Planet Student Championship in Sochi. BTW, this year we had about 2 000 participants in InterSystems Contest.
Let's have a round of CodeGolf!
As usual the goal is to write the shortest solution for a specified problem.
Today we have one of the classics: FizzBuzz.
Write a program that prints the numbers from 1 to 100.
But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”.
For numbers which are multiples of both three and five print “FizzBuzz”
My new question regards connecting to the external database to insert the data. I have the following code:
I have a class (to be deployed) and I want to forbid anyone from extending it.
Is there any way to do that?
I need to start doing unit testing for some of my code.
Why does it delete the unit testing class from Cache when I run the test?
Is there a way to turn this off?
Cache 2016.2.1.603 for windows)
I created a few classes and one class called jitPod.Api.toServer.additionalConsignments and realised even before I did any work,, that the word "Api" (note capital A) needed to be "api" (all lowercase)
it would not allow copying the class to the lowercase name because the directory already exists (i understand that)
so I exported the class to an XML, edited the xml to become lowercase "api" , deleted all the classes (and directory name) and re-imported the class.
I'm looking at adding multilingual support to a couple of open source projects I'm working on. The solutions are already developed in CSP so I am not looking for alternative approaches.
I'm wondering what would be the best approach for CSP and separate JavaScript files.
Initially I was wondering if I should bake the default system language text at compile time, or provide the end user with a language selection option at run time.
I came across $$$TEXT reading the docs...
I am experimenting with Relationships, both Parent to Child and One to Many.
I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?
Thank you in advance for any help provided.
Hi guys!
As you know there are two (at least) ways to get the stored value of the property of InterSystems IRIS class if you know the ID of an instance (or a record).
1. Get it by as a property of an instance with "Object access":
ClassMethod GetPropertyForID(stId As %Integer) As %String
{
set obj=..%OpenId(stId)
return obj.StringData
}
2. Get it as a value of a column of the record with "SQL access":
Hi Community!
Suppose you have a working system on 8-bit Caché database and need to transfer the solution to Unicode database.
How do you manage that?
I have a lot of string properties, which need custom but similar Getters and Setters.
Currently I'm generating Getter and Setter in class generation code but that expands class definition.
Is there a way to specify custom datatype which would generate custom getters and setters?
Good morning,
I'm trying to understand $ZF function, but only documentation isn't enought in this way. So my question is is there any possibility to get enviroment variable by this function into ensemble?
I've tried this as example from ducumentation, but there is an error and I don't know why...
Thanks for your solutions.
Zdenek
Forgive my lack of understanding, but I am working on a vendor created Cache database and the indexes specified in the classes for ODBC connections are not working. A few of them are created, but of the 50+ classes we have, only a handful of them are created when the class is compiled, yet no errors occur.
Example 1:
.png)
.png)
Example 2:
Hello community,
I am trying to parse the below HttpResponse in Cache. Cannot get the Iterator to work. Is there a single loop which can parse both or single messages and grab the error?
{
error:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
]
}
{
error: {
txt1:[
'error msg1',
'error msg2'
]
}
Thanks,
Jimmy Christian
Hi Guys,
I'm looking to Remove file from a location to another similar to CUT & Past function, I'm using this :
s file=##class(%File).%New() d file.CopyFile(File,ArchivePath) d file.Delete(File)
and the copying is happening but not the Deleting, and help pls?
Thanks
We are going to start using Git within Cache.
One question came up - if the branch that you checked out does not have the class or mac file, what is the correct thing to do?
Should we delete from Cache or should we just keep it?
I'm leaning more towards deleting it because Cache should reflect what is in your work folder in git. But other team members are saying to keep it.
Some may think it's a strange / daft idea, but just today the Raspberry Pi folks have announced that they've now sold more than 10 million of them..and counting. That's a huge potential marketplace, and a great platform for getting people to hear about Cache and try it out. Given its focus on the education sector, another great way of getting heard about.
Im using below code to display page number. But i only display as 1,2..etc. I need to display it as I,II,III..etc...
special="page-number"
Hi all!
I'm developing a mini-framework to implement annotations in Cache. I want to support two kind of annotations: metadata and method decorators. I've got stuck trying to implement the second one.
With metadata annotations I can add metadata to any kind of target. A target can be a method/classmethod, parameter, property and class.
For example:
WebSockets look to be supported reasonably well in Cache. I have yet to use them in production so I am wondering how well it has worked for other developers.
In particular what happens when the browser does not support WebSockets, or when a firewall blocks the connection.
Have you had to write your own long polling fall-back?
I've read the documentation and found this interesting article...
https://community.intersystems.com/post/asynchronous-websockets-quick-tutorial
I understand this is a rather broad topic (and at times involves religious sentiments) yet I would like to look at it from the Caché perspective:
If you had to choose Angular 1 or 2 for a new web project using Caché/Ensemble as a backend, Which one would you choose?
I'm trying to figure this out with a short pros/cons list:
