Zaky, thanks for your reply. But this doesn't really answer my question. I didn't ask how to generate an xml file from a sql query, I know how to do that...
I asked how to do it from cake, as a response to a request, on demand, because I need to consider various input parameters, dynamically associate models, etc... On Mar 10, 11:20 pm, Zaky Katalan-Ezra <procsh...@gmail.com> wrote: > Put this line into a script file, .sh ot .bat, without the square brackets. > mysql -u[youruser] -p[youruserpassword] [yourdatabase] -e"select * from > yourtable" --xml > data.xml > Run the script from your site. > When the script return use the text file data.xml. > There is a security issues you need to address in order to use this file > only in a specific session or for a specific user. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
