Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Blocker
-
Resolution: Duplicate
-
Affects Version/s: 1.2.0
-
Fix Version/s: None
-
Component/s: Pager
-
Labels:None
-
Environment:Windows 2003 Server. IIS 6.0. MS SQL Server 2005. Symfony 1.4
Description
Hi,
I can't use a pager. For example :
$q = Doctrine_Query::create()>select( "*" )>from( "utilisateur" );
$pager = new customDoctrinePager( $q, 1, 10 );
$pager->init();
$results = $pager->getResults();
gives me :
SQLSTATE[HY000]: General error: 10007 Invalid column name 'id'. [10007] (severity 5) [SELECT TOP 10 [inner_tbl].[id] AS [u__id] FROM (SELECT TOP 10 [u].[id] AS [u__id], [u].[utisateurnom] AS [u__utisateurnom] FROM [utilisateur] [u]) AS [inner_tbl]]. Failing Query: "SELECT TOP 10 [inner_tbl].[id] AS [u__id] FROM (SELECT TOP 10 [u].[id] AS [u__id], [u].[utisateurnom] AS [u__utisateurnom] FROM [utilisateur] [u]) AS [inner_tbl]"
The query :
SELECT
TOP 10 [inner_tbl].[id] AS [u__id]
FROM
(
SELECT
TOP 10 [u].[id] AS [u__id], [u].[utisateurnom] AS [u__utisateurnom]
FROM
[utilisateur] [u]
) AS [inner_tbl]
is wrong.
This one would be correct :
SELECT
TOP 10 [inner_tbl].[u__id] AS [u__id]
FROM
(
SELECT
TOP 10 [u].[id] AS [u__id], [u].[utisateurnom] AS [u__utisateurnom]
FROM
[utilisateur] [u]
) AS [inner_tbl]
This code works :
$q = Doctrine_Query::create()
->select( '*' )
->from( 'utilisateur u' );
$this->resultSet = $q->execute();
This one gives the save error :
$q = Doctrine_Query::create()
->select( '*' )
->from( 'utilisateur u' );
$q->limit(10);
$q->offset(1);
$this->resultSet = $q->execute();
This is very blocker for me.
Nb. I am not sure of the Doctrine's version used by symfony 1.4
Same problem with
$this->produit = Doctrine::getTable( "TProduit" )
>find( $request>getParameter("produitId") );The inner query gives
t__produit_id
but the main query tries to select
[inner_tbl].[produit_id]