Thanks, this answer gave me a start where to look.
You still can hydrate, if you do it like this:
ProductPeer::addSelectColumns($oCriteria);
$oCriteria->addAsColumn('current_price', 'IF(MAX(' . BidPeer::BID . ')
> ' . ProductPeer::PRICE . ', MAX(' . BidPeer::BID . '), ' .
ProductPeer::PRICE . ')');
Then all the "normal" table columns are added, after that the custom
column is.
On 19 jul, 00:17, xplo <[email protected]> wrote:
> Hello,
>
> you probably can call raw sql on select clause with addAsColumn on
> your criteria but it wont be hydrated in your result objects so you
> should try propel 1.5 with the new "with" method that add custom
> select statement and hydrate them in the object.
>
> On Jul 18, 7:58 pm, HAUSa <[email protected]>
> wrote:
>
> > If everything goes well, a SQL file is created in your /data/sql
> > folder.
> > I don't know why that does not happen, it should :)
> > Otherwise try build-all. Beware, this creates the model files as well
> > and replaces the database.
>
> > Please back to topic! Feel free to open a new discussion for this one.
>
> > I'm eager to use the IF() SQL statement, but I can't find anything
> > about it in the Propel documentation.
> > Anyone who knows how that is possible?
>
> > On 18 jul, 19:36, Richard Zulu <[email protected]> wrote:
>
> > > Hi,
>
> > > I installed symfony 1.4.6. However, whenever i run the propel:build-sql
> > > command it doesn't generate my schema.sql file in the data directory. Am
> > > using Ubuntu and have phing active too. It gives me this output:
>
> > > php symfony propel:build-sql
>
> > > >> schema converting "/home/zulu/sfprojects/config/schema.yml" to XML
> > > >> schema putting /home/zulu/sfprojects/config/generated-schema.xml
> > > >> propel Running "sql" phing task
> > > >> file- /home/zulu/sfprojects/config/generated-schema.xml
> > > >> file- /home/zulu/sfprojects/config/generated-schema-transformed.xml
>
> > > then after this i cannot find my schema.sql file
>
> > > Anyone know why
>
> > > --
> > > Richard Zulu
> > > Managing Director
> > > Time Information Company
> > > P.O Box 31842
> > > Clock Tower
> > > Kampala, Ugandawww.time.co.ug
>
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
