[symfony-users] Re: about custom query with criteria (postgis)
Hi, Don't get a solution for Propel, but there's a plugin to deal with postgis geographical data doctrine: http://www.symfony-project.org/plugins/sfMapFishPlugin Tonio On Sep 7, 10:18 am, Dennis Hellmich dennis.hellm...@googlemail.com wrote: Hi Francisco, I am also using Postgis sometimes and I have not found a clean solution to integrate this into Propel yet. It begins with the definition of the schema and how to define non- standard datatypes like geometries. I also don't know how to call SQL-Functions without calling raw SQLs. I will see, if doctrine is more flexible with this... I don't think, that it is good practice to use bare/raw SQLs, because you lose the benefit of the database abstraction. But on the other hand it is necessary sometimes. Here is a description, of how to use raw sqls:http://www.symfony-project.org/book/1_2/08-Inside-the-Model-Layer#cha... Cheers, Dennis Am 14.08.2009 um 20:13 schrieb Francisco Calderón: Hi everybody, im new using symfony, im working in a GIS project, with PostGIS, and i need to make a custom query like this: SELECT b.gid, b.name FROM a, b WHERE a.the_geom b.the_geom AND a.gid=2 the problem is the operator , i add it in the begining of the Criteria Class with other operator const INTERSECTA = ; and after that did this: $criteria = new Criteria(); $criteria-add(APeer::THE_GEOM, BPeer::THE_GEOM, Criteria::INTERSECTA); $this-sectoresList = BPeer::doSelect($criteria); do not work, then i saw in the Criteria class the function addJoin receive an operator and i tried: $criteria = new Criteria(); $criteria-addJoin(APeer::THE_GEOM, BPeer::THE_GEOM, Criteria::INTERSECTA); $this-sectoresList = BPeer::doSelect($criteria); and nothing, which would be the best way to make this query work with propel? there is a way to send the bare sql query? is it a good practice? Thanks in advance Francisco Calderón --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: about custom query with criteria (postgis)
Hi Dennis, On Sep 7, 11:06 am, Dennis Hellmich dennis.hellm...@googlemail.com wrote: Does it also has an interface to use the usual Postgis functions like intersect? You can take a look at the mfQuery class http://trac.symfony-project.org/browser/plugins/sfMapFishPlugin/branches/1.2/lib/mfQuery.class.php Doctrine does also support to call sgbd function in where clause like: -addWhere($geom_column GEOMETRYFROMTEXT(?, $epsg), $bbox) -andWhere(DISTANCE(GEOMETRYFROMTEXT(?, $epsg), $geom_column) = $tolerance, $geometry); Hth, Tonio --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: REST : How to get HTTP request body? (XML)
Hi, Here's the way I deal with it : http://gist.github.com/170304 Tonio On Aug 19, 11:55 am, Nicolas CHARLOT nicolas.char...@isics.fr wrote: Le 18 août 09 à 17:58, Nicolas CHARLOT a écrit : Hi all, For a REST web service, we've to retrieve the HTTP request body (POST and PUT). The HTTP request content-type is text/xml and the body contains only an XML string. There is no parameter. I haven't found anything in sfRequest that allows me to retrieve the body. Any ideas? Answer to myself: $request_body = file_get_contents('php://input'); I think there's no way to do that directly with sfRequest. -- Nicolas CHARLOThttp://www.isics.fr --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: routing + parameters
Hello, Try options: { generate_shortest_url: false } from: http://www.symfony-project.org/tutorial/1_2/whats-new#chapter_3fb3b0c857177a2b6740a5dcbc0fb8c7_routing Tonio On Jul 21, 10:52 am, mlu...@gmail.com mlu...@gmail.com wrote: Hi! has anybody an idea about this? it's really urgent. thank you. michael On 20 Jul., 19:09, mlu...@gmail.com mlu...@gmail.com wrote: Thank you for the feedback. Now it's working, but the url looks like this: /search/q/funny/page/2 Can I change this? Michael On 20 Jul., 18:14, Eno symb...@gmail.com wrote: On Mon, 20 Jul 2009, mlu...@gmail.com wrote: I think I have to define something in the routing.yml, but I have no idea what. I want the url to look like this www.example.com/search?q=word1+word2p=1 You could try: url: /search/* -- --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: routing + parameters
Oups, too quick: options: { extra_parameters_as_query_string: true } On Jul 21, 11:24 am, Tonio brankg...@gmail.com wrote: Hello, Try options: { generate_shortest_url: false } from:http://www.symfony-project.org/tutorial/1_2/whats-new#chapter_3fb3b0c... Tonio On Jul 21, 10:52 am, mlu...@gmail.com mlu...@gmail.com wrote: Hi! has anybody an idea about this? it's really urgent. thank you. michael On 20 Jul., 19:09, mlu...@gmail.com mlu...@gmail.com wrote: Thank you for the feedback. Now it's working, but the url looks like this: /search/q/funny/page/2 Can I change this? Michael On 20 Jul., 18:14, Eno symb...@gmail.com wrote: On Mon, 20 Jul 2009, mlu...@gmail.com wrote: I think I have to define something in the routing.yml, but I have no idea what. I want the url to look like this www.example.com/search?q=word1+word2p=1 You could try: url: /search/* -- --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: ExtJs JSON response
Hi, There are pretty useful ff extension to view JSON response: https://addons.mozilla.org/en-US/firefox/addon/10869 Tonio https://addons.mozilla.org/en-US/firefox/addon/10869 On May 25, 3:20 pm, Lee Bolding l...@leesbian.net wrote: This is the correct solution. Your browser attempts to download the response as a file because it doesn't know what to do with the mime type application/json If you set the headers to text/html for testing purposes you'll see the response as plain text in your browser On 25 May 2009, at 06:00, Leon van der Ree wrote: My guess is your content-type. Try keeping it text/html instead of application/json On May 25, 10:21 am, santail nikolai.muh...@gmail.com wrote: Action executes of file upload. If that helps to find a bug. --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: url_for in controller
Hello, $this-getContext()-getConfiguration()-loadHelpers('Url'); makes helper accessible. Tonio On Apr 22, 1:58 pm, HAUSa jeroen_heeft_behoefte_aan_r...@hotmail.com wrote: Is there a way to use the url_for() (available in the template files) in my actions.class.php? --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Declaring javascript or css files in html head section using IF blocks (!--[if IE 6]) ????
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 dalj...@gmail.com wrote: Hi All, I was just wondering how to get the following html output in the template. For css !--[if IE 6] link href=/css/mystyle-ie6.css rel=stylesheet type=text/css / ![endif]-- For javascript !--[if IE 6] script type=text/javascript language=javascript src=/js/ myJS_IE6.js/script ![endif]-- Thanks for your help. Dj --~--~-~--~~~---~--~~ 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Strange problem with autoloading and cache
I dont have access to the cli interface in production server, only FTP and HTTP. Why do you think it could fix the error ? On 24 nov, 06:55, Roberto Carvajal [EMAIL PROTECTED] wrote: Have you tried rebuilding your model from the CLI on your production server? r. Tonio escribió: Hi I've a problem really strange withsymfony1.0. Sometimes I get the Fatal Error : Cannotredeclareclass on the production server . It happens on Base classes, Map classes or class in model directory. These errors do not happen on dev environment. If I delete all files in cache directory, clear cookies, clear sessions files on server, disable cache in settings.yml : Nothing, still get the error. I must upload again by FTP the file of the class and voila no more trouble. But I can't spent my time to retest all the application to verify what kind of class files I have to upload twice. And sometimes uploading one file cause an error on another.. Please someone to explain me whats the problem. Is there anything with last update time of files insymfonyautoloadsystem ? please HELP -- Roberto Carvajal [EMAIL PROTECTED] Web Developer- Masquer le texte des messages précédents - - Afficher le texte des messages précédents - --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---