PureBasic Forums - English

TLS has just brought many of my simmering projects to rapid boil Thank you!

Eureka! Found what I was looking for. Adapted from Paul's post here: https://forums.spiderbasic.com/viewtopic.php?p=8378&hilit=extractjsonstructure#p8378

Source:
Enumeration
#json
EndEnumeration

Structure struc_pers
key.s
name.s
EndStructure

Structure struc_attrib
key.s
active.s
date.s ...

Thanks! I was pondering on this line in the manual from ExtractJSONStructure:

The extraction is performed recursively if the structure contains further structures

Hello,

I know I can mash the structures into one, but anyone know how to go about extracting JSON array data to designated structures?

Enumeration
#json
EndEnumeration

Structure struc_pers
key.s
name.s
EndStructure

Define pers.struc_pers

Structure struc_attrib
key.s
active.s
date.s ...

Found my issue, RS: https://forums.spiderbasic.com/viewtopi ... 9544#p9544

Thanks for your excellent contributions!

I have the dll and exe in the same folder with correct permissions. It's running on Windows Server 2022, IIS, and SQL 2022. Your code returns correctly, the parse returns 0, and debugging the variable just before WriteCGIString appears to be normal. The web page is built in SpiderBasic on the server ...

:shock: Amazing. Thank you!

I hate to ask (because you've done such an incredible job on it already), but would you have any hint as to why the debug output is fine, both formatted and straight, but if I do...

If ExecuteSQLQuery("Persist Security Info=False;Trusted_Connection=True ...

Hello, RSBasic,

Quick observation, if I use a query like (SELECT count(*) FROM myTable;) the XML doesn't reflect the result...

<?xml version="1.0" encoding="UTF-16"?>

<Records>
<Record/>
</Records>

...though it is in the raw output.

<Records><Record><>87325</></Record></Records>


UPDATE ...

He means inside the executable, so it doesn't show up in a binary file search with a hex editor.


*bonk*

Yes. I remember reading about this in the SoftIce days. I used AnalogX TextScan to browse strings (it's still available and free).

If the dev wasn't using exe protection like Armadillo or ...

If it's a StringGadget, use #PB_String_Password flag.

I use a pad with factor of 8 pixels between gadgets for breathability. Desktop resolution is a factor of 8, so this works out well when maximized.

; 1. Add button to enumeration
; 2. In window_main() - Define button gadget(s)
; 3. In resize() - Adjust buttonCount to total enumerated buttons
; 4 ...

Thanks for the hint, infratec!

1. Ran this from Visual Studio (PB encoding was different than PS encoding. PS didn't like it.):

$code = {

[My Powershell code here]

}

[convert]::ToBase64String([Text.Encoding]::Unicode.GetBytes($code))

2. Copied the output and placed in PB. Spits out the CSVs with no fuss :)

Encoded ...

Awesome! Thank you, Mindphazer!

May have hit the jackpot here:

https://stackoverflow.com/questions/540 ... n-one-line

Any input is appreciated