[symfony-users] Re: Select a column

2009-03-26 Thread kusum
Hi, Using this i can get specified no of columns,but using this is it possible to access method of class of that table or not. Thanks, Kusum On Mar 25, 11:37 pm, Sid Bachtiar wrote: > You said: > > >> > >     I want to select data from a table list.I want to select all rows > >> > > and on

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Gareth McCumskey
Just thought I would mention. Propel uses standard SQL. If you are attemtping to use Oracle specific SQL then it wont work. Just as if you were trying to use MySQL only SQL (like the MATCH keyword for a full text indexed column) it wont work because that is not standardised SQL. On Fri, Mar 27, 20

[symfony-users] Re: Mysql query performance from PHP vs Mysql Client

2009-03-26 Thread Gareth McCumskey
Thanks for the response. I do realise this. What I saw was the moment mtop reported the query as running on mysqld. The time it took after interacting with the application until the query was shown as running and the time it took after the query finished to the results actually displaying on screen

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Sid Bachtiar
I've worked with Oracle, but I have never used Symfony with Oracle, so I'm not speaking from experience. To be fair, most of Symfony projects are most likely using MySQL database instead of Oracle. > 1.can not process oracle sequence You mean for generating primary key like auto number? I usual

[symfony-users] Re: problem in displaying js calender

2009-03-26 Thread Vikaash
hey dude thanks it worked. On Mar 26, 6:39 pm, Gareth McCumskey wrote: > In your link_to_remote do you have the parameter "script"=>"true" set? > > Example: > >     "url"=>"module/action", >     "update"=>"div_to_update", >     "script"=>"true" > )) ?> > > This will allow any javascript (like t

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread yunhui song
I'm using propel in our ptoject. questions here: 1.can not process oracle sequence 2.when insert oracle date type,SQL wrong 3.paging SQL is much slower than straight SQL Sign. I expect to save my time,but I have spend much more time than just SQL way! On 3/26/09, Fási Gábor wrote: > > On T

[symfony-users] Re: symfony mirror at github

2009-03-26 Thread Pablo Godel
I would be interested in a git mirror. I've been using git for a while and love it. Pablo On Thu, Mar 26, 2009 at 9:37 AM, Fabien Potencier wrote: > > This was a test, and was never advertised. > > Fabien > > -- > Fabien Potencier > Sensio CEO - symfony lead developer > sensiolabs.com | symfon

[symfony-users] Re: Multiple routing files

2009-03-26 Thread Pierre
You can do that with your own config handler. Take a look into config_handlers.yml and check the sfDoctrinePlugin schema config handler. On 26 Mrz., 15:04, Michael Boyd wrote: > I've been trying to split my routes into several files (lots of > routes) but don't think this can be done? Is there a

[symfony-users] Re: Atom Template

2009-03-26 Thread Nei Rauni Santos
Thanks Lee and Fási... I was using short tag a lot on templates files.. I won't use it more :) Nei On Thu, Mar 26, 2009 at 11:28 AM, Fási Gábor wrote: > > You have the short open tags php option enabled, so " starts the php interpreter, and you get a syntax error. > > On Thu, Mar 26, 2009 at 1

[symfony-users] urls matching with default route.

2009-03-26 Thread Nei Rauni Santos
Guys, I`m having problems with routes when I use the url /name1/name2.. Can I use it?? hours ago I was having the same problem with this form: but this work alone again.. now I was writing same functional tests and this problem occurred again. my test fail when check the module and action par

[symfony-users] Re: Fixtures: how to self-reference an object ?

2009-03-26 Thread Jonathan Wage
Hmm. This works in Doctrine because all objects are created first before any of them are linked together. - Jon On Thu, Mar 26, 2009 at 2:13 PM, Loïc Vernet wrote: > Table: > Object_1: > default_language_id: Object_1 > > This code obviously doesn't work... > > ++ > > COil > > > > > --

[symfony-users] Re: sfWidgetFormI18nSelectLanguage(array('culture' => 'fr')) - how do you automatically set the culture

2009-03-26 Thread fredlab
Thanks for your help. I finally got what I want and with : .new sfWidgetFormI18nSelectCountry(array('culture' => sfContext::getInstance()->getRequest()->getPreferredCulture(array ('fr', 'en', It works. Note that I define the array of accepted language (here fr , en) in my app.yml file

[symfony-users] Fixtures: how to self-reference an object ?

2009-03-26 Thread Loïc Vernet
Table: Object_1: default_language_id: Object_1 This code obviously doesn't work... ++ COil --~--~-~--~~~---~--~~ 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] Managing male/female labels

2009-03-26 Thread naholyr
Hello, In a project I need to have distinct labels for male or female items. Simple example : User [ gender ('m', 'f') ; role_id ] Role [ id ; label ] Imagine we have : Role#1 : "Directeur" User#1 : [ 'f' ; 1 ] When i display user#1's role i'd like to display "Directrice" and not "Directeu

[symfony-users] CSRF attack in batch actions

2009-03-26 Thread HAUSa
When I try to execute a batch action (delete) which is created by the admin generator, I get an "_csrf_token [CSRF attack detected.]" message. I didn't change the actions.class.php, so it uses the default admin generated class. Does anyone know how this is possible? --~--~-~--~~--

[symfony-users] Re: Special characters in SF

2009-03-26 Thread HAUSa
Forgot to clear my cache. It works, thank you! On 26 mrt, 17:51, HAUSa wrote: > I changed the meta tag. > > This is my settings.yml: > > all: >   .settings: >     csrf_secret:             > >     escaping_strategy:      'on' >     escaping_method:        ESC_SPECIALCHARS > >     charset:    

[symfony-users] Re: Special characters in SF

2009-03-26 Thread HAUSa
I changed the meta tag. This is my settings.yml: all: .settings: csrf_secret: escaping_strategy: 'on' escaping_method:ESC_SPECIALCHARS charset:iso-8859-1 On 26 mrt, 12:49, Fási Gábor wrote: > Now you send utf8 in your meta as

[symfony-users] Re: Atom Template

2009-03-26 Thread Fási Gábor
You have the short open tags php option enabled, so " wrote: > Hi, > > I did the day 15 of Jobeet today, and I got an error when it render the atom > template: > > Parse error: syntax error, unexpected T_STRING in > /var/www/sfprojects/jobeet/apps/frontend/modules/job/templates/indexSuccess.atom.p

[symfony-users] Re: Atom Template

2009-03-26 Thread Lee Bolding
Disable short tags in your php configuration. Short tags are bad, mmmkay? On 26 Mar 2009, at 13:48, Nei Rauni Santos wrote: > Hi, > > I did the day 15 of Jobeet today, and I got an error when it render > the atom template: > > Parse error: syntax error, unexpected T_STRING in /var/www/ > sf

[symfony-users] Multiple routing files

2009-03-26 Thread Michael Boyd
I've been trying to split my routes into several files (lots of routes) but don't think this can be done? Is there a way to do this similar to schemas, e.g. every /config file ending in "schema.yml" is parsed as a schema. But only routes.yml is parsed for routing, and not "more.routes.yml". Any i

[symfony-users] Atom Template

2009-03-26 Thread Nei Rauni Santos
Hi, I did the day 15 of Jobeet today, and I got an error when it render the atom template: *Parse error*: syntax error, unexpected T_STRING in * /var/www/sfprojects/jobeet/apps/frontend/modules/job/templates/indexSuccess.atom.php * on line *2* It's because the template start like a php tag: f

[symfony-users] Re: Mysql query performance from PHP vs Mysql Client

2009-03-26 Thread Thomas Rabaix
[I suppose you are using an ORM] ORM executes pre and post actions while quering the database. Of course these actions can slow down the all application. More over you can have models which perform sub actions while being hydrated. On Thu, Mar 26, 2009 at 2:30 PM, Gareth McCumskey wrote: > Gree

[symfony-users] Re: Fixtures - can I specify a literal value on a linked table?

2009-03-26 Thread djones
On Mar 25, 7:03 pm, Steve the Canuck wrote: > The reason I ran into this is because I have multiple fixture files. > I have some tables that are purely reference tables.  So, I don't use > autonumbering for those fields.  Also, these tables exist in a > different fixture file. > > I wanted to cre

[symfony-users] Re: problem in displaying js calender

2009-03-26 Thread Gareth McCumskey
In your link_to_remote do you have the parameter "script"=>"true" set? Example: "module/action", "update"=>"div_to_update", "script"=>"true" )) ?> This will allow any javascript (like the calendar) to run in the return action. Its a security precaution to help prevent any unauthorised ja

[symfony-users] Re: symfony mirror at github

2009-03-26 Thread Fabien Potencier
This was a test, and was never advertised. Fabien -- Fabien Potencier Sensio CEO - symfony lead developer sensiolabs.com | symfony-project.org | fabien.potencier.org Tél: +33 1 40 99 80 80 Yevgeniy A. Viktorov wrote: > > Hello, > > I just was willing to use "The Official symfony git mirror"

[symfony-users] Mysql query performance from PHP vs Mysql Client

2009-03-26 Thread Gareth McCumskey
Greetings all, I had an interesting observation which I was hoping someone might be able to answer. Maybe I am deluding myself but what I have seen is difficult to just dismiss outright. I run a pretty complex, multi-join query in a symfony application we are building and in investigating its per

[symfony-users] symfony mirror at github

2009-03-26 Thread Yevgeniy A. Viktorov
Hello, I just was willing to use "The Official symfony git mirror" as it's said, but it's was removed :( http://github.com/fabpot/ Anyone know about? Maybe it's just moved to another server/hoster... Thanks. --~--~-~--~~~---~--~~ You received this message becau

[symfony-users] Re: Mysql Restore Issue

2009-03-26 Thread Dheeraj Kumar Aggarwal
Hi Deepak, istead of taking of simple dump, u should again take a dump of rtdb1 with this option mysqldump -u-p--- -t-c database_name > dump.sql -t -c options also maintains the headers of each table in the database then dump your dump file into your new database On Thu, Mar

[symfony-users] problem in displaying js calender

2009-03-26 Thread Vikaash
hai i m just using js calender on my page. in my project when i directly browse the templates the calender appears there. but when i browse the same page throug ajax function (link_to_remote) it doesnot appear. i dont know whats the problem please help me out. --~--~-~--~~

[symfony-users] Re: Special characters in SF

2009-03-26 Thread Fási Gábor
Now you send utf8 in your meta as well, you used to send latin1 there. Are you absolutely sure the file is in utf8? Also, delete the old accented char, and enter it agan, now in utf8, should be fine. I still have to manually switch to iso-8859-1 to make it right. On Thu, Mar 26, 2009 at 09:30, HA

[symfony-users] Re: mysql extension not loaded

2009-03-26 Thread Fási Gábor
Well, the problem is: your mysql extension is not loaded. :P Check your php.ini, make sure there's no semicolon before the pdo_mysql extension. Note: the cli and the cgi versions often have a different php.ini. On Thu, Mar 26, 2009 at 11:01, sachin jain wrote: > [propel-creole-transform] There w

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Fási Gábor
On Thu, Mar 26, 2009 at 09:31, Benjamin wrote: > > Lets say I change a field called name to first_name.  Then I rebuild > the models.  fooPeer::NAME will no longer exist.  Do I then manually > define that constant in a peer class? > Nope, you can use the phpName attribute for fields, not only fo

[symfony-users] Symfony Batch script + Emails + Request Parameters...

2009-03-26 Thread Sumedh
Hi Friends, I am using Symfony 1.0. This is a problem discussed in other places on the forum but I didn't get a concrete answer... I am sending emails via a batch script. I need to send parameters to the email module via request params or attributes... It sends the data but gives warnings like

[symfony-users] Re: Mysql Restore Issue

2009-03-26 Thread Sid Bachtiar
Because mysqldump stores the table structure, so when you restore it re-creates the table with only one column. Do mysqldump for backup, then add your new column, then do another mysqldump for backup with the new column. So you should end up with two mysqldump files. So then when you want to res

[symfony-users] Mysql Restore Issue

2009-03-26 Thread DeepakBhatia
Hi, I have a database name 'rtdb1' with a table 'review_table'. The 'review_table' has one column 'version' of varchar 20 type. I took the mysqldump of the rtdb1 database. Then I changed by table 'review_table' by adding one more column 'category' int type and called the database 'rtdb2'. But

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Benjamin
Thank you Sid, Excellent answers :) On Mar 26, 5:29 am, Sid Bachtiar wrote: > Hi Benjamin, > > > Lets say I change a field called name to first_name.  Then I rebuild > > the models.  fooPeer::NAME will no longer exist.  Do I then manually > > define that constant in a peer class? > > Either that

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Sid Bachtiar
Hi Benjamin, > Lets say I change a field called name to first_name. Then I rebuild > the models. fooPeer::NAME will no longer exist. Do I then manually > define that constant in a peer class? Either that or search and replace. Personally, I tend to search and replace whenever possible. In rel

[symfony-users] Re: Declaring javascript or css files in html head section using IF blocks (

2009-03-26 Thread hello world
Cool ..this is what I was looking for. thanks a lot Tonio. On Mar 26, 9:58 am, Tonio wrote: > Hello, > > Use condition in your view .yml > Example > :http://trac.symfony-project.org/browser/branches/1.2/test/functional/... > > Tonio > > On Mar 25, 1:03 pm, dsb wrote: > > > Hi All, > > > I wa

[symfony-users] mysql extension not loaded

2009-03-26 Thread sachin jain
[propel-creole-transform] There was an error building XML from metadata: mysql extension not loaded [User Info: Array] [propel-creole-transform] Propel - CreoleToXMLSchema finished what could be the issue when i run build schema command and how to solev it ..I am having symfony 1.0 --~--~---

[symfony-users] Re: Declaring javascript or css files in html head section using IF blocks (

2009-03-26 Thread Tonio
Hello, Use condition in your view .yml Example : http://trac.symfony-project.org/browser/branches/1.2/test/functional/fixtures/project/apps/frontend/config/view.yml Tonio On Mar 25, 1:03 pm, dsb wrote: > Hi All, > > I was just wondering how to get the following html output in the > template.

[symfony-users] Re: symfony textmate bundle

2009-03-26 Thread Dennis Benkert
I just pushed the first preview of the bundle (codename 'conductor's baton') to github (http://github.com/denderello/symfony-tmbundle/tree/master). Everybody is invited to give feedback about the features, usage, etc. Happy coding, Dennis 2009/3/24 Dennis Benkert : >> FWIW, I've mapped getReques

[symfony-users] sfDoctrineSimpleCMSPlugin --> admin module not working.

2009-03-26 Thread hello world
Hi, I checkedout copy of sfDoctrineSimpleCMSPlugin from http://svn.symfony-project.com/plugins/sfDoctrineSimpleCMSPlugin/ And copied files from sfDoctrineSimpleCMSPlugin/trunk to plugin/sfDoctrineSimpleCMSPlugin folder. Then again, I copied "web" folder from plugin/ sfDoctrineSimpleCMSPlugin/ a

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Gareth McCumskey
> Lets say I change a field called name to first_name. Then I rebuild > the models. fooPeer::NAME will no longer exist. Do I then manually > define that constant in a peer class? Quite simply .. yes. Thats a lot easier than having to find all the times in your code that you used the old table

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Benjamin
That all makes sense. Here's a question.. er two. Lets say I change a field called name to first_name. Then I rebuild the models. fooPeer::NAME will no longer exist. Do I then manually define that constant in a peer class? Lets say I sell the site to a corporation who only uses the foo datab

[symfony-users] Re: http not working

2009-03-26 Thread DEEPAK BHATIA
Hi, Since we using xampp on linux hence when we start the apache, it automatically starts with SSL on. http://www.apachefriends.org/en/xampp-linux.html Is it possible to start apache without SSL ? Regards Deepak Bhatia [r...@localhost lampp]# ./lampp startapache XAMPP: Starting Apache with SS

[symfony-users] Re: Special characters in SF

2009-03-26 Thread HAUSa
I changed it, but still got the same problem... On 25 mrt, 14:15, Fási Gábor wrote: > Check the encoding of your file, if I view it with iso-8859-1 instead > of utf8, it's fine. > > On Wed, Mar 25, 2009 at 10:56, HAUSa > > wrote: > > > See here: > >http://www.starterswijzerutrecht.nl/zoeken/

[symfony-users] Re: Propel 1.3 on PHP 5.1.x ?

2009-03-26 Thread Gareth McCumskey
I guess partly I am wondering what else migth be included in Propel 1.3, apart from the DateTime class, that would need PHP 5.2. It has to be more than just the DateTime stuff .. surely no one is going to enforce a higher level of PHP as a requirement just to make working with Date types comfier?

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread michael.pie...@googlemail.com
Another thing i like with peer constants is code-autocompletion. So when i type "PasswordLabelPeer::" i can quickly select the columns ... Michael On 26 Mrz., 09:17, Sid Bachtiar wrote: > Fixing misspelled table names from previous developer, changing table > names prefixes, configurable tabl

[symfony-users] Re: alternate stylesheets with title and media type - how to do define them?

2009-03-26 Thread dsb
Yes It works. Thanks Tom Haskins-Vaughan. On Mar 25, 3:55 pm, Tom Haskins-Vaughan wrote: > Try this in view.yml: > >    stylesheets: >      - style >      - style1: { rel: 'alternate stylesheet' title: red } >      - style2: { rel: 'alternate stylesheet' title: blue } > > Tom > > > > dsb wrote:

[symfony-users] Re: routing, link_to, culture

2009-03-26 Thread michael.pie...@googlemail.com
I think this should be: Michael On 25 Mrz., 22:20, lowshoe wrote: > hi all, > > i have problems in using link_to in conjunction with sf_culture. > > suppose i have the following routing.yml: > > # route for articles > article: >   url:    /:sf_culture/article/details/:article_id >   param:  

[symfony-users] Re: http not working

2009-03-26 Thread DEEPAK BHATIA
Hi, Thanks for your response. http://127.0.0.1 is working but http://10.0.1.66/xampp is not working rather https://10.0.1.66/xampp is working. Regards Deepak On Wed, Mar 25, 2009 at 10:33 PM, Eno wrote: > > On Tue, 24 Mar 2009, DeepakBhatia wrote: > > > But I am not able to access my web pa

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Sid Bachtiar
Fixing misspelled table names from previous developer, changing table names prefixes, configurable table names for Symfony plugins, easier to grep/search/replace, etc. Not many reasons but it is still a good practice. There is always reason to go against Abstraction when you writing code because i

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Ian P. Christian
2009/3/26 Benjamin : > > This question may be unrelated to symfony, and more related to > database abstraction, but I'm wondering why I should pull the table > names from the model.  I've been programming for a long time and have > never seen anyone need to use dyamic table names except when they

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Gareth McCumskey
PS .. you shouldn't necessarily write your own SQL for Propel .. you shouyld try using the Criteria objects rather as hand writing your own SQL breaks the whole ORM database abstraction that Propel provides anyways On Thu, Mar 26, 2009 at 9:36 AM, Gareth McCumskey wrote: > Are you complaining abo

[symfony-users] Re: Why should I write queries like this?

2009-03-26 Thread Gareth McCumskey
Are you complaining about the need to use model constants for table names? The entire structure of Propel and its model naming scheme is meant for development eas and maintainability not necessarily for dynamic table names. For example, if right near the end of the development period you suddenly r

[symfony-users] Why should I write queries like this?

2009-03-26 Thread Benjamin
This question may be unrelated to symfony, and more related to database abstraction, but I'm wondering why I should pull the table names from the model. I've been programming for a long time and have never seen anyone need to use dyamic table names except when they have prefixes on them that can

[symfony-users] Re: please, help me!!!

2009-03-26 Thread Gareth McCumskey
Well using the observe_form helper you can pass the current values of the form to an action to do verification server side and then return a result. Not ideal with the new forms system but I am sure there must be a way (I have not investigated as of yet) to use your existing validation setup in you