drh_investigator (view) Content

drh_investigator (view) Schema


INV-001	Boris Kovatchev	EBwC7@example.com	INST-001	DCLP1
INV-002	Stacey M. Anderson	Dd0nk@example.com	INST-001	DCLP1
INV-003	Dan Raghinaru	RLam3@example.com	INST-001	DCLP1
INV-004	Yogish C. Kudva	4pKUS@example.com	INST-001	DCLP1
INV-005	Lori M. Laffel	CVTDE@example.com	INST-001	DCLP1
INV-006	Carol Levy	hwedl@example.com	INST-001	DCLP1
INV-007	Jordan E. Pinsker	DTm7W@example.com	INST-001	DCLP1
INV-008	R. Paul Wadwa	5Hg9r@example.com	INST-001	DCLP1
INV-009	Bruce Buckingham	E9Usl@example.com	INST-001	DCLP1
INV-010	Francis J. Doyle III	rXskX@example.com	INST-001	DCLP1
INV-011	Sue A. Brown	Vfzrl@example.com	INST-001	DCLP1
INV-012	Mei Mei Church	qEfoS@example.com	INST-001	DCLP1
INV-013	Vikash Dadlani	7EO6S@example.com	INST-001	DCLP1
INV-014	Eyal Dassau	EZ3Or@example.com	INST-001	DCLP1
INV-015	Laya Ekhlaspour	nRGTG@example.com	INST-001	DCLP1
INV-016	Gregory P. Forlenza	eIm46@example.com	INST-001	DCLP1
INV-017	Elvira Isganaitis	Kii6Y@example.com	INST-001	DCLP1
INV-018	David W. Lam	ETUb6@example.com	INST-001	DCLP1
INV-019	John Lum	Ktcu9@example.com	INST-001	DCLP1
INV-020	Roy W. Beck	MBWM5@example.com	INST-001	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_investigator.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'.