Difference between revisions of "Calc/API"
m (playing with DPL) |
m (playing with DPL) |
||
Line 6: | Line 6: | ||
category=Calc | category=Calc | ||
category=API | category=API | ||
+ | nottitleregexp=^Calc/API$ | ||
</DPL> | </DPL> | ||
[[Category:Calc|! API]] | [[Category:Calc|! API]] | ||
+ | [[Category:API]] |
Revision as of 18:41, 12 June 2007
The Spreadsheet related interfaces and services are documented in the ::com::sun::star::sheet IDL reference
Code snippets using the API are available at the Code Snippet Base.
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, `page`.page_title as sortkey FROM `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Calc') INNER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND (cl1.cl_to='API') WHERE 1=1 AND NOT (`page`.page_title REGEXP '^Calc/API$') AND `page`.page_is_redirect=0 ORDER BY page_title ASC LIMIT 0, 500
Error message is:
Character set 'utf8mb3_bin' cannot be used in conjunction with 'binary' in call to regexp_like. (127.0.0.1)