|
| Technical information |
| Error type | 256 |
| Error description | Source: Microsoft JET Database Engine
Description: Data type mismatch in criteria expression. |
| URL | thelincolnregistry.com/registry/Count_list.php?f=(SeriesName~equals~2) |
| Error file | E:\hostingspaces\rotella\thelincolnregistry.com\wwwroot\registry\connections\Connection.php |
| Error line | 668 |
| SQL query | SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM [Lincolns] WHERE ( ( ( ( ( [SeriesName] = '2' OR [SeriesName] LIKE '%,2' OR [SeriesName] LIKE '2,%' OR [SeriesName] LIKE '%,2,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] ORDER BY [ModelYear],[SeriesName],[BodyStyle] |
| #0 |
connections\Connection.php:668 |
Connection->triggerError |
0. Source: Microsoft JET Database Engine
Description: Data type mismatch in criteria expression. |
| #1 |
connections\ADOConnection.php:96 |
ADOConnection->query |
0. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM [Lincolns] WHERE ( ( ( ( ( [SeriesName] = '2' OR [SeriesName] LIKE '%,2' OR [SeriesName] LIKE '2,%' OR [SeriesName] LIKE '%,2,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] ORDER BY [ModelYear],[SeriesName],[BodyStyle] |
| #2 |
connections\dbfunctions\ODBCFunctions.php:117 |
ODBCFunctions->limitedQuery |
0. ADOConnection
1. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM [Lincolns] WHERE ( ( ( ( ( [SeriesName] = '2' OR [SeriesName] LIKE '%,2' OR [SeriesName] LIKE '2,%' OR [SeriesName] LIKE '%,2,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] ORDER BY [ModelYear],[SeriesName],[BodyStyle]
2. 0
3. -1
4. 1 |
| #3 |
connections\Connection.php:608 |
Connection->limitedQuery |
0. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM [Lincolns] WHERE ( ( ( ( ( [SeriesName] = '2' OR [SeriesName] LIKE '%,2' OR [SeriesName] LIKE '2,%' OR [SeriesName] LIKE '%,2,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] ORDER BY [ModelYear],[SeriesName],[BodyStyle]
1. 0
2. -1
3. 1 |
| #4 |
classes\datasource\table.php:629 |
DataSourceTable->getListImpl |
0. DsCommand |
| #5 |
classes\datasource\datasource.php:44 |
DataSource->getList |
0. DsCommand |
| #6 |
classes\controls\FilterMultiselectLookup.php:32 |
FilterMultiselectLookup->addFilterBlocksFromDB |
0. Array
(
)
|
| #7 |
classes\controls\FilterControl.php:216 |
FilterControl->buildFilterCtrlBlockArray |
0. ListPage_Simple |
| #8 |
classes\controls\FilterValuesList.php:602 |
FilterValuesList->buildFilterCtrlBlockArray |
0. ListPage_Simple |
| #9 |
classes\filterpanel.php:70 |
FilterPanel->buildFilterPanel |
N/A |
| #10 |
classes\runnerpage.php:5487 |
RunnerPage->buildFilterPanel |
N/A |
| #11 |
classes\runnerpage.php:1649 |
RunnerPage->init |
N/A |
| #12 |
classes\listpage.php:2500 |
ListPage::createListPage |
0. Count
1. Array
(
[pageName] =>
[pageType] => list
[id] => 1
[flyId] => 0
[mode] => 0
[xt] => XTempl Object
[firstTime] =>
[sortBy] =>
[requestGoto] => 0
[masterPageType] =>
[masterPage] =>
[masterId] =>
[masterTable] =>
[dashElementName] =>
[dashTName] =>
[dashPage] =>
)
|
| #13 |
Count_list.php:135 |
Global scope |
N/A |