All
Accepted answers
Daniel Aguilar · Apr 15, 2020 go to post

I missed the webinar , but I'm very interested...crying

Is a recording going to be uploaded? angel

Daniel Aguilar · Nov 9, 2020 go to post

Good morning,

Sorry, I was wrong when writing the question, effectively what I am receiving is a empty string and what I want to store is an null.

David,
I have been trying to overwrite the Normalize method but it is not working for me, maybe I am not overwriting the method well

ClassMethod myPropertyNormalize(%val As %CacheString) As %String [ CodeMode = generator, ServerOnly = 1 ]
{
s str=""
//s code="%val"//i %parameter("TRUNCATE"),%parameter("MAXLEN")'="" s code="$e(%val,1,"_(+%parameter("MAXLEN"))_")"
//$$$GENERATE(" Q "_code)
$$$GENERATE(" Q "_$tr(code,$c(0),""""))
QUIT $$$OK
}

I am doing it right? (I guess not xD )

Thanks!.

Daniel Aguilar · Jun 15, 2021 go to post

Hello Werner.

I had the same problem and I solved it adding this to the answer:

Do %response.SetHeader("Access-Control-Allow-Origin","*")

Regards,

Daniel Aguilar · Mar 15, 2022 go to post

Good morning Michael,

I haven't worked a lot with stored procedures but when I have worked with them, I did it like this.

TestSQLProc()New stmt,status,rSet,SQLQuery  

 SET SQLQuery = "SELECT PackageName.ClassName_ProcedureName('parameter')" 

 Set stmt = ##class(%SQL.Statement).%New() Set status = stmt.%Prepare(SQLQuery) 

 If status'=1 
 {     Set return="%Prepare failed:" Do $System.Status.DisplayError(status) Quit } 

 Set rSet = stmt.%Execute()While rSet.%Next() {    U 0 W rSet."ColumnName" }    

Q

I think that your problem is that you're trying to get information using Call instead of Select.

I hope it helps you.

My best,

Daniel Aguilar · Mar 31, 2022 go to post

Thanks Alexey for your answer but as Jhon says $now doesn't adjunt for Dailyght Save Time and I need it.  wink

Daniel Aguilar · Jun 21, 2022 go to post

Hi, Nicola

I think best option is $Select as Jolyon write, but you have this option too

set a=0set:(a>b) a=1
Daniel Aguilar · Feb 11, 2023 go to post

Hello,
Please add bonuses `Second articule (translation) and YouTube vídeo to cos-url-shortener Project.

I added embedded Python too (but maybe too late) xD

Thanks!.

Daniel Aguilar · Jun 29, 2023 go to post

Hello, I'm getting this error when I execute: publish {myPackageName}

ERROR! Publishing module, authorization required.

Can you help me?

Thanks!!

Daniel Aguilar · Jul 7, 2023 go to post

It happened to me too. My votes were deleted I had to vote again  and I don't know who voted for me

Daniel Aguilar · Sep 21, 2023 go to post

Hello @Evgeny Shvarov 
Thanks for sharing the bonuses results.

Please, can you check the IrisApitester puntuation?

It uses:

-Embedded phyton

-Docker

-ZPM

Or maybe it’s because it’s an update to an existing App?

Thanks!

Daniel Aguilar · Nov 29, 2023 go to post

I answer my self xD

##class(%SYSTEM.Encryption).MD5HashStream(stream)

I hope it can be useful for someone too xD

Thanks!

Daniel Aguilar · Nov 29, 2023 go to post

Thanks Yaron,

I'm not worried about security because I plan to use it on non-critical internal processes, but anyway I've done some research and here is an example using SHA-256:

Set encryptedValue = ##class(%SYSTEM.Encryption).SHAHashStream(256,stream)

The first parameter (in my case the value 256) refers to the bit-length:

160 (SHA-1)
224 (SHA-224)
256 (SHA-256)
384 (SHA-384)
512 (SHA-512)

Daniel Aguilar · Dec 4, 2023 go to post

Thanks Dimitry,

In which scenario could I be affected by the overflow. Sending messages without a listener who read them, for example?

Is there a way to know how many messages are in a queue, to avoid this problem?

Thanks again

Daniel Aguilar · Dec 4, 2023 go to post

My my, I had looked for the Count command but had not found it. Sorry for the silly question.

Thanks Dimitry!

Daniel Aguilar · Dec 5, 2023 go to post

Hello Enrico,

The reason for doing it in this way is because we haven't yet migrate to IRIS. We're working with the 2018 version currently.

Thanks for your answer 👍

Daniel Aguilar · Dec 13, 2023 go to post

Hello, has anyone received this result in Day1 - Part Two puzzle ?

I think my answer it's correct and I've checked the puzzle input and it seems correct... xD

Thanks!

Daniel Aguilar · Dec 13, 2023 go to post

Thanks Robert, it seems that my code has an error because it doesn't match with your results. I will keep trying. Thank you so much!