Search found 657 matches

by Scott Klement
Mon Apr 01, 2024 6:05 pm
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

Again, if you want help, post an example that I can load and run on my system. Don't waste my time with another example that I can load and run. The example you posted relies on external files and programs that are unique to your system and cannot be loaded and run on mine. Provide a simple example ...
by Scott Klement
Thu Mar 28, 2024 5:13 pm
Forum: Other ScottKlement.com Tools
Topic: SNDPIPE
Replies: 1
Views: 335

Re: SNDPIPE

You are attempting to run "PATH=$PATH:/QOpenSys/pkgs/bin" as if it is a program, and then send it a string that says "curl -help". Seems to me that this is correct behavior, you should receive nothing, since setting the PATH variable is not a program, and therefore sending data t...
by Scott Klement
Wed Mar 27, 2024 4:37 am
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

Curramt = HSSFWorkbook_createCellStyle(wb); DataFmt = HSSFWorkbook_createDataFormat(wb); TempStr = new_String('$#,##0.00'); NumFmt = HSSFDataFormat_getFormat(DataFmt: TempStr); HSSFCellStyle_setDataFormat(Curramt: NumFmt); Curreur = HSSFWorkbook_createCellStyle(wb); DataFmt = HSSFWorkbook_createDat...
by Scott Klement
Tue Mar 26, 2024 11:07 pm
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

The fact that you're seeing the ¬ character means that, somehow, it is being translated into EBCDIC (and translated incorrectly at that.) Nothing in my code -- or the code that you just posted -- translates the text to EBCDIC. Please provide a full, complete, program that I can load and run on my sy...
by Scott Klement
Tue Mar 26, 2024 8:22 pm
Forum: HTTPAPI
Topic: No JSON Returned if its not HTTP/1.1 200 OK
Replies: 7
Views: 398

Re: No JSON Returned if its not HTTP/1.1 200 OK

Thanks for the that, Scott I can get the 406 now ... I am more concerned about seeing the returned JSON. As I said, when it is not 200 OK the JSON does not get returned ! Any help appreciated I'm sorry, I don't understand where you are stuck. You've already discovered from another thread as well as...
by Scott Klement
Tue Mar 26, 2024 12:40 am
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

Here's a quick and dirty example of using RPG's built-in support for Unicode to solve the problem. Notice that I used the hex codes for dollar and euro sign, so if your system doesn't have an EBCDIC that supports those symbols, it's okay, because the hex code for Euros and Dollars in Unicode will be...
by Scott Klement
Tue Mar 26, 2024 12:36 am
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

To me, this means you are probably using a form of EBCDIC that doesn't contain the euro symbol. Please consider either using Unicode or switching to a form of EBCDIC that does have the Euro symbol.
by Scott Klement
Mon Mar 25, 2024 11:59 pm
Forum: HTTPAPI
Topic: No JSON Returned if its not HTTP/1.1 200 OK
Replies: 7
Views: 398

Re: No JSON Returned if its not HTTP/1.1 200 OK

Yes, use http_req() if you need to get back the response variable when you get a code like 406.
by Scott Klement
Mon Mar 25, 2024 6:36 pm
Forum: HTTPAPI
Topic: No JSON Returned if its not HTTP/1.1 200 OK
Replies: 7
Views: 398

Re: No JSON Returned if its not HTTP/1.1 200 OK

I don't understand what you are asking.

Are you telling me that the "406 Not Acceptable" code should also return a JSON and you are not getting it?

Or are you saying that you want to receive a "200 OK" every time?
by Scott Klement
Mon Mar 25, 2024 6:33 pm
Forum: HSSFR4
Topic: HSSF how can format cell with currency "$"
Replies: 15
Views: 876

Re: HSSF how can format cell with currency "$"

It's interesting that you are mentioning XLS (an obsolete format no longer used) and AS400 (an obsolete computer no longer used.)

You say that your code doesn't work, but it works for me. Please explain enough detail to make it fail the way it is failing for you.