[symfony-users] Re: Problem Filtering by Date
Thanks a lot Guys, great Help On Aug 20, 5:34 am, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: You can use Criteria's custom parameter like so: $c = new Criteria(); $c-add(RecordPeer::DATE, MONTH( . RecoredPeer::DATE .) = '. $month .', Criteria::CUSTOM); Regards, Jamie Learmonth Boxlight Media Ltd. On 20 Ago, 00:47, Hoaxz [EMAIL PROTECTED] wrote: BTW I;ll like to get a Propel wise solution... On Aug 19, 3:45 pm, Hoaxz [EMAIL PROTECTED] wrote: Hey every one. My problem is simple to understand but I can't find an answerd. I want to filter records by month, meaning that if in my APP the user ask for record with Month 01 (January), the search will return exaclty those records, but I can't find a way to compare the month on a DATE field with the month given. PseudoCode would be something like SELECT * FROM record WHERE MONTH(record.date) = $month Any help or orientation may help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com 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 -~--~~~~--~~--~--~---
[symfony-users] Problem Filtering by Date
Hey every one. My problem is simple to understand but I can't find an answerd. I want to filter records by month, meaning that if in my APP the user ask for record with Month 01 (January), the search will return exaclty those records, but I can't find a way to compare the month on a DATE field with the month given. PseudoCode would be something like SELECT * FROM record WHERE MONTH(record.date) = $month Any help or orientation may help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Problem Filtering by Date
BTW I;ll like to get a Propel wise solution... On Aug 19, 3:45 pm, Hoaxz [EMAIL PROTECTED] wrote: Hey every one. My problem is simple to understand but I can't find an answerd. I want to filter records by month, meaning that if in my APP the user ask for record with Month 01 (January), the search will return exaclty those records, but I can't find a way to compare the month on a DATE field with the month given. PseudoCode would be something like SELECT * FROM record WHERE MONTH(record.date) = $month Any help or orientation may help. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Problem with empty parameter in URL
Would you mind posting how exactly you are passing the values in the
URL.
On Aug 19, 10:42 am, pierrix [EMAIL PROTECTED] wrote:
I've a request parameter food with a empty input_tag, so th parameter
is empty.
In the URL I've parametername//otherparametername/otherparametervalue
When the input_tag is displayed again, the input_tag is initialized
with otherparametename and is not empty.
the input_tag code is :
Rechercher :?php echo input_tag('recherche', $sf_request-
getParameter('recherche'),' ') ?
Thank you for uor help.
Pierrix.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
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
-~--~~~~--~~--~--~---
[symfony-users] Re: Problem with Routing
I setted it off otherwise the routing problem comes back. Any advice is welcome. On 5 jul, 09:25, Tom Haskins-Vaughan [EMAIL PROTECTED] wrote: have you tired playing with no_script_name in settings.yml? Victor Castellanos wrote: Hi everyone, hope someone can help me. My problem is I'm trying to run my project on Prod (http://localhost/ [projectname]/web/). When I get there, I see the login screen, insert Username, Password and click login, and here comes the problem, I'm redirected tohttp://localhost/[projectname]/web/security/login with a 404 message, when it should behttp://localhost/[projectname]/web/index.php/security/login . I've tried everything, even setting the no_script_name to off (when I do that I gethttp://localhost/[projectname]/web/index.php/security/login but everything is white, no action taken, no redirect, nothing... Any help would be really appreciated... Thanks -- Tom Haskins-Vaughan Temple Street Media: Design and Development for the Web [EMAIL PROTECTED] |www.templestreetmedia.com --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Problem with Routing
Development is cool, no problem there, I try localhost/pname/ frontend_dev.php/ and I get the login.. type user and pass and get redirected like it should, it gets messy when I try Prod. On Jul 4, 7:49 pm, Савин Дима [EMAIL PROTECTED] wrote: Hi Victor What about development mode? Do you have the same there? Could you show your logs on redirected page? 2008/7/5 Victor Castellanos [EMAIL PROTECTED]: Hi everyone, hope someone can help me. My problem is I'm trying to run my project on Prod (http://localhost/ [projectname]/web/). When I get there, I see the login screen, insert Username, Password and click login, and here comes the problem, I'm redirected tohttp://localhost/[projectname]/web/security/login with a 404 message, when it should behttp://localhost/[projectname]/web/index.php/security/login . I've tried everything, even setting the no_script_name to off (when I do that I gethttp://localhost/[projectname]/web/index.php/security/login but everything is white, no action taken, no redirect, nothing... Any help would be really appreciated... Thanks -- С уважением, Савин Дима --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com 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 -~--~~~~--~~--~--~---
[symfony-users] Re: Problem with Routing
] {sfTimerManager} Configuration 3.07 ms
(10)
Jul 05 00:48:19 symfony [info] {sfTimerManager} Action main/index
0.17 ms (1)
Jul 05 00:48:19 symfony [info] {sfTimerManager} View Success for
main/index 21.34 ms (1)
Check the Dev Log, where I added the that's the diference, I
does something after the executeLogin().
Any help or comment may help.
Thanks
On Jul 4, 8:26 pm, Савин Дима [EMAIL PROTECTED] wrote:
Maybe you should turn on logging for prod mode and see what error
massages symfony gives?
2008/7/5 Hoaxz [EMAIL PROTECTED]:
Development is cool, no problem there, I try localhost/pname/
frontend_dev.php/ and I get the login.. type user and pass and get
redirected like it should, it gets messy when I try Prod.
On Jul 4, 7:49 pm, Савин Дима [EMAIL PROTECTED] wrote:
Hi Victor
What about development mode? Do you have the same there? Could you
show your logs on redirected page?
2008/7/5 Victor Castellanos [EMAIL PROTECTED]:
Hi everyone, hope someone can help me.
My problem is I'm trying to run my project on Prod (http://localhost/
[projectname]/web/). When I get there, I see the login screen, insert
Username, Password and click login, and here comes the problem, I'm
redirected tohttp://localhost/[projectname]/web/security/login with a
404 message, when it should
behttp://localhost/[projectname]/web/index.php/security/login
.
I've tried everything, even setting the no_script_name to off (when I
do that I gethttp://localhost/[projectname]/web/index.php/security/login
but everything is white, no action taken, no redirect, nothing...
Any help would be really appreciated...
Thanks
--
С уважением,
Савин Дима
--
С уважением,
Савин Дима
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
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
-~--~~~~--~~--~--~---
[symfony-users] Re: Problem with Routing
I believe is something about the sfPropelFinderPlugin, what do you
think?
On 5 jul, 00:53, Hoaxz [EMAIL PROTECTED] wrote:
Already check the logs, and to be honest, I can see the problem but
can't imagine the solution.
These are the logs for the Prod:
Jul 05 00:38:36 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:38:36 symfony [info] {sfContext} initialization
Jul 05 00:38:36 symfony [info] {sfController} initialization
Jul 05 00:38:36 symfony [info] {sfRouting} match route [homepage] /
Jul 05 00:38:36 symfony [info] {sfRequest} request parameters array
( 'module' = 'main', 'action' = 'index',)
Jul 05 00:38:36 symfony [info] {sfController} dispatch request
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfBasicSecurityFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:38:36 symfony [info] {sfAction} call
securityActions-executeIndex()
Jul 05 00:38:36 symfony [info] {sfView} initialize view for security/
index
Jul 05 00:38:36 symfony [info] {sfView} render /home/user/Documents/
projects/project/apps/frontend/modules/security/templates/
indexSuccess.php
Jul 05 00:38:36 symfony [info] {sfView} decorate content with /home/
undermaster/Documents/projects/colicont/apps/frontend/templates/
layout.php
Jul 05 00:38:36 symfony [info] {sfView} render /home/user/Documents/
projects/project/apps/frontend/templates/layout.php
Jul 05 00:38:37 symfony [info] {sfFilter} render to client
Jul 05 00:38:37 symfony [info] {sfResponse} send status HTTP/1.0 200
OK
Jul 05 00:38:37 symfony [info] {sfResponse} send header Content-
Type: text/html; charset=utf-8
Jul 05 00:38:37 symfony [info] {sfResponse} send content (2553 o)
Jul 05 00:38:43 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:38:44 symfony [info] {sfContext} initialization
Jul 05 00:38:44 symfony [info] {sfController} initialization
Jul 05 00:38:44 symfony [info] {sfRouting} match route [default]
/:module/:action/*
Jul 05 00:38:44 symfony [info] {sfRequest} request parameters array
( 'module' = 'security', 'action' = 'login', 'login' = 'asd',
'password' = '123', 'commit' = 'Login',)
Jul 05 00:38:44 symfony [info] {sfController} dispatch request
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:38:44 symfony [info] {sfAction} call securityActions-
executeLogin()
After the executeLogin() I don't get any reponse. Now the Dev logs:
Jul 05 00:48:14 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:48:14 symfony [info] {sfContext} initialization
Jul 05 00:48:14 symfony [info] {sfController} initialization
Jul 05 00:48:14 symfony [info] {sfRouting} match route [homepage] /
Jul 05 00:48:14 symfony [info] {sfRequest} request parameters array
( 'module' = 'main', 'action' = 'index',)
Jul 05 00:48:14 symfony [info] {sfController} dispatch request
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfWebDebugFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfBasicSecurityFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfWebDebugFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:48:14 symfony [info] {sfAction} call
securityActions-executeIndex()
Jul 05 00:48:14 symfony [info] {sfView} initialize view for security/
index
Jul 05 00:48:14 symfony [info] {sfView} render /home/undermaster/
Documents/projects/colicont/apps/frontend/modules/security/templates/
indexSuccess.php
Jul 05 00:48:14 symfony [info] {sfView} decorate content with /home/
undermaster/Documents/projects/colicont/apps/frontend/templates/
layout.php
Jul 05 00:48:14 symfony [info] {sfView} render /home/undermaster/
Documents/projects/colicont/apps/frontend
[symfony-users] Re: Problem with Routing
Problem solved, some kind of bug with my sfPropelFindePlugin. Just
went back to old fashioned Criteria system.
On 5 jul, 00:53, Hoaxz [EMAIL PROTECTED] wrote:
Already check the logs, and to be honest, I can see the problem but
can't imagine the solution.
These are the logs for the Prod:
Jul 05 00:38:36 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:38:36 symfony [info] {sfContext} initialization
Jul 05 00:38:36 symfony [info] {sfController} initialization
Jul 05 00:38:36 symfony [info] {sfRouting} match route [homepage] /
Jul 05 00:38:36 symfony [info] {sfRequest} request parameters array
( 'module' = 'main', 'action' = 'index',)
Jul 05 00:38:36 symfony [info] {sfController} dispatch request
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfBasicSecurityFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:38:36 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:38:36 symfony [info] {sfAction} call
securityActions-executeIndex()
Jul 05 00:38:36 symfony [info] {sfView} initialize view for security/
index
Jul 05 00:38:36 symfony [info] {sfView} render /home/user/Documents/
projects/project/apps/frontend/modules/security/templates/
indexSuccess.php
Jul 05 00:38:36 symfony [info] {sfView} decorate content with /home/
undermaster/Documents/projects/colicont/apps/frontend/templates/
layout.php
Jul 05 00:38:36 symfony [info] {sfView} render /home/user/Documents/
projects/project/apps/frontend/templates/layout.php
Jul 05 00:38:37 symfony [info] {sfFilter} render to client
Jul 05 00:38:37 symfony [info] {sfResponse} send status HTTP/1.0 200
OK
Jul 05 00:38:37 symfony [info] {sfResponse} send header Content-
Type: text/html; charset=utf-8
Jul 05 00:38:37 symfony [info] {sfResponse} send content (2553 o)
Jul 05 00:38:43 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:38:44 symfony [info] {sfContext} initialization
Jul 05 00:38:44 symfony [info] {sfController} initialization
Jul 05 00:38:44 symfony [info] {sfRouting} match route [default]
/:module/:action/*
Jul 05 00:38:44 symfony [info] {sfRequest} request parameters array
( 'module' = 'security', 'action' = 'login', 'login' = 'asd',
'password' = '123', 'commit' = 'Login',)
Jul 05 00:38:44 symfony [info] {sfController} dispatch request
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:38:44 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:38:44 symfony [info] {sfAction} call securityActions-
executeLogin()
After the executeLogin() I don't get any reponse. Now the Dev logs:
Jul 05 00:48:14 symfony [warning] {sfPhpConfigHandler} php.ini
magic_quotes_gpc key is better set to false (current value is
'1' - php.ini location: /etc/php5/apache2/php.ini)
Jul 05 00:48:14 symfony [info] {sfContext} initialization
Jul 05 00:48:14 symfony [info] {sfController} initialization
Jul 05 00:48:14 symfony [info] {sfRouting} match route [homepage] /
Jul 05 00:48:14 symfony [info] {sfRequest} request parameters array
( 'module' = 'main', 'action' = 'index',)
Jul 05 00:48:14 symfony [info] {sfController} dispatch request
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfWebDebugFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfBasicSecurityFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfRenderingFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfWebDebugFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfCommonFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfFlashFilter
Jul 05 00:48:14 symfony [info] {sfFilter} executing filter
sfExecutionFilter
Jul 05 00:48:14 symfony [info] {sfAction} call
securityActions-executeIndex()
Jul 05 00:48:14 symfony [info] {sfView} initialize view for security/
index
Jul 05 00:48:14 symfony [info] {sfView} render /home/undermaster/
Documents/projects/colicont/apps/frontend/modules/security/templates/
indexSuccess.php
Jul 05 00:48:14 symfony [info] {sfView} decorate content with /home/
undermaster/Documents/projects/colicont/apps/frontend/templates/
layout.php
Jul 05 00:48:14 symfony [info] {sfView} render /home/undermaster/
Documents
