|
| Technical information |
| Error type | 256 |
| Error description | [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. |
| URL | www.tbird.info/lincoln/Count_list.php?f=(SeriesName~equals~3) |
| Error file | E:\web\tbirdinf\lincoln\connections\Connection.php |
| Error line | 664 |
| SQL query | SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM "Lincolns" WHERE ( ( ( ( ( [SeriesName] = '3' OR [SeriesName] LIKE '%,3' OR [SeriesName] LIKE '3,%' OR [SeriesName] LIKE '%,3,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] |
| #0 |
connections\Connection.php:664 |
Connection->triggerError |
0. [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. |
| #1 |
connections\ODBCConnection.php:76 |
ODBCConnection->query |
0. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM "Lincolns" WHERE ( ( ( ( ( [SeriesName] = '3' OR [SeriesName] LIKE '%,3' OR [SeriesName] LIKE '3,%' OR [SeriesName] LIKE '%,3,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle] |
| #2 |
connections\dbfunctions\ODBCFunctions.php:117 |
ODBCFunctions->limitedQuery |
0. ODBCConnection
1. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM "Lincolns" WHERE ( ( ( ( ( [SeriesName] = '3' OR [SeriesName] LIKE '%,3' OR [SeriesName] LIKE '3,%' OR [SeriesName] LIKE '%,3,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle]
2. 0
3. -1
4. 1 |
| #3 |
connections\Connection.php:604 |
Connection->limitedQuery |
0. SELECT
[ModelYear], [SeriesName], [BodyStyle], COUNT(1)
FROM "Lincolns" WHERE ( ( ( ( ( [SeriesName] = '3' OR [SeriesName] LIKE '%,3' OR [SeriesName] LIKE '3,%' OR [SeriesName] LIKE '%,3,%' ) ) ) ) ) GROUP BY [ModelYear],[SeriesName],[BodyStyle]
1. 0
2. -1
3. 1 |
| #4 |
classes\datasource\table.php:645 |
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:4874 |
RunnerPage->buildFilterPanel |
N/A |
| #11 |
classes\runnerpage.php:1427 |
RunnerPage->init |
N/A |
| #12 |
classes\listpage.php:2430 |
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:131 |
Global scope |
N/A |