How can i access the return values from run_sql

[Bynun]

Hi, i'm currently using run_sql to load up a general header file for all my sql pages and one of the things the header file does is read a cookie and load a user from the supplied information. What i am trying to achive is supplying the aquired user id back to the calling page as a variable so i can customise it with a name or data relative to that user however i can't work out how.
The document for run_sql says "Executes another SQL file and returns its result as a JSON array" but doesn't mention how to access this data or how to add things into this result data assuming that it is even possible?
If not is there anyway to return values from a called file back to the calling file?
Thanks

[lovasoa]

Hi !

I added an example to the docs:

https://sql-page.com/functions.sql?function=run_sql#function

Does this make it clearer ?

[Bynun]

Thank you for the reply, that does make it a bit clearer. 👍

[Bynun]

Tried this today but it seems i can't access the data if run_sql is called as a 'dynamic' component inorder to run the header code before the main body. By including a 'text' component with the 'dynamic' i can see the data inside the properties of the 'shell' component and can add custom objects to that but i can't work out how to access the properties object once the select has completed.

I read in another discussion a few years back about implementing something similar to #include where the header file contents are just added to the existing page but it didn't seem to go anywhere leaving everyone to try and create work arounds and hacks. Coming from an explicit programming background i am finding SQL page and all it's hidden implicit stuff hard to get my head around.

I ended up copying the method described here #301 (comment) which uses 2 header files, one for the shell and the other for the login data.

Thanks again for this fantastic program, all the hard work is massively appreciated :D