Difference between revisions of "Studies:Case Studies"

From Counting Opinions (SQUIRE)
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
<h1 class="ns-112" style="text-align:left">Case Studies</h1>
+
=Case Studies=
 +
__NOTOC__
 +
 
 
{{#dpl:
 
{{#dpl:
|categoryregexp=.+ Case Studies
+
|categoryregexp=.+tud.+
|notcategory=French
+
 
|namespace=Studies
 
|namespace=Studies
 
|headingmode=H4
 
|headingmode=H4
 
|ordermethod=category,title
 
|ordermethod=category,title
 
|mode=unordered
 
|mode=unordered
|format=,\n*[[%PAGE%|%TITLE%]],,\n
+
|include={Case Study}:library,{Case Study/fr}:library
}}
+
 
+
====Étude de Cas d’une Province====
+
{{#dpl:
+
|category=state Library Case Study
+
|category=French
+
|namespace=Studies
+
|include={Case Study Fr}:library
+
 
|replaceintitle=/fr\//,
 
|replaceintitle=/fr\//,
|format=,\n*[[%PAGE%|,]],
+
|format=,\n*[[%PAGE%|,]],\n
 
}}
 
}}
 
__NOTOC__
 

Latest revision as of 12:14, 5 April 2013

Case Studies

The DPL extension (version 2.01) 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 cl_head.cl_to, `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'Counting_Opinions' WHEN 5 THEN 'Counting_Opinions_talk' WHEN 6 THEN 'File' WHEN 7 THEN 'File_talk' WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN 'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13 THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk' WHEN 100 THEN 'LibSatLibrary Customer Satisfaction Management Service' WHEN 101 THEN 'LibSatLibrary Customer Satisfaction Management Service_talk' WHEN 102 THEN 'LibPASLibrary Performance Assessment Service' WHEN 103 THEN 'LibPASLibrary Performance Assessment Service_talk' WHEN 104 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+' WHEN 105 THEN 'InformsUsForm, Survey and App Builder Service, also Web Form Builder+_talk' WHEN 106 THEN 'News' WHEN 107 THEN 'News_talk' WHEN 108 THEN 'Staff' WHEN 109 THEN 'Staff_talk' WHEN 110 THEN 'Services' WHEN 111 THEN 'Services_talk' WHEN 112 THEN 'Studies' WHEN 113 THEN 'Studies_talk' WHEN 114 THEN 'Support' WHEN 115 THEN 'Support_talk' WHEN 116 THEN 'Minutes' WHEN 117 THEN 'Minutes_talk' WHEN 118 THEN 'CSS' WHEN 119 THEN 'CSS_talk' WHEN 200 THEN 'IPEDSIntegrated Post-Secondary Education Data System' WHEN 201 THEN 'IPEDSIntegrated Post-Secondary Education Data System_talk' WHEN 274 THEN 'Widget' WHEN 275 THEN 'Widget_talk' WHEN 302 THEN 'Property' WHEN 303 THEN 'Property_talk' WHEN 306 THEN 'Form' WHEN 307 THEN 'Form_talk' WHEN 308 THEN 'Concept' WHEN 309 THEN 'Concept_talk' END, ':')), `page`.page_title), '_', ' ') as sortkey FROM `page` LEFT OUTER JOIN `categorylinks` AS cl_head ON (page_id=cl_head.cl_from) INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to REGEXP '.+tud.+') WHERE 1=1 AND `page`.page_namespace IN ('112') AND `page`.page_is_redirect=0 ORDER BY cl_head.cl_to, sortkey ASC LIMIT 0, 500

Error message is:
Character set 'utf8_bin' cannot be used in conjunction with 'binary' in call to regexp_like. (10.39.23.66)