drh_author (view) Content

drh_author (view) Schema


AUTH-001	Boris Kovatchev	ukapY@example.com	INV-001	DCLP1
AUTH-002	Stacey M. Anderson	wrQSN@example.com	INV-002	DCLP1
AUTH-003	John Lum	CiWqK@example.com	INV-019	DCLP1

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in query number 6:

Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:

            SELECT 'text' AS component,
                (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
                                                                                                                                                   ⬆️
                '(Page ' || $current_page || ' of ' || $total_pages || ') ' ||

Backtrace

sql parser error: Expected: END, found: ' ||
                ' at Line: 42, Column: 149

"console/content/view/drh_author.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.

You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.