Question 1

How to fix 'unable to find library -lodbc' when compiling SQLPage on FreeBSD?

Accepted Answer

Download the precompiled binary from the FreeBSD package repository using 'pkg install sqlpage'. If you cannot install system packages manually, download the .pkg file from https://www.freshports.org/www/sqlpage/ or https://pkg.freebsd.org/FreeBSD:14:amd64/latest/All/sqlpage-0.42.0_1.pkg. No compilation required. If static ODBC linking fails with SHLIBEXT errors, report the bug to https://github.com/pacman82/odbc-api and use the binary as a temporary workaround.

Question 2

Why does "schema sqlpage does not exist" appear when using sqlpage.environment_variable in on_connect.sql?

Accepted Answer

on_connect.sql is executed as raw SQL before SQLPage processing, so the sqlpage schema and its functions are not available. To use environment variables in stored procedures, pass them explicitly when calling the procedure: SELECT my_proc(sqlpage.environment_variable('MY_VAR'), $sqlpage_arg); Alternatively, use sqlpage.run_sql('init.sql') to set session variables, but passing arguments directly is recommended.

Question 3

Why does SQLPage form condition 'IS NOT NULL' not work with empty fields?

Accepted Answer

When a form field is left blank, SQLPage sets the variable to an empty string ('') rather than NULL. Therefore, the condition `:name IS NOT NULL` evaluates to TRUE even when the field is empty. To check if a field has been filled, use `:name <> ''` instead of `IS NOT NULL`.

Question 4

How to create a real-time updating chart in SQLPage without full page refresh?

Accepted Answer

Use a card component with iframe embed_mode to isolate the chart. In the main page: 
```sql
SELECT 'card' AS component, 1 as columns;
SELECT 'plot.sql' AS embed, 'iframe' AS embed_mode, 'height: 400px' AS style;
```
In plot.sql, enable shell refresh and define the chart:
```sql
SELECT 'shell' AS component, 1 AS refresh;
SELECT 'chart' AS component, 'y = f(x)' AS title;
SELECT x, y FROM fakedata;
```
This refreshes only the chart area. For selective refresh control, combine with a form and auto_submit, passing refresh=$checked to the embedded page.

SQLPage

Core Features

What It Can't Do

Use Cases

Tags

Getting Started

Similar Projects