On Tuesday, 12 June 2012 04:31:48 UTC+2, Brad Koch wrote: > > I'm currently facing an issue regarding the data types being read from the > database. Regardless of the type specified in the schema definition, all > data is read in as a string. It's a well documented issue. The encoding > of numbers as strings wrecks general havoc when it gets converted to JSON > and hits the client side code. > > My intended solution is to write a behavior that utilizes Model::_schema > to automatically sanitize the results. However, I don't want to go out and > reinvent the wheel if there's a solution out there I don't know about yet. > > Is anyone aware of a CakePHP framework feature / library that correctly > sanitizes the database input? >
You can use a simple function like this: https://gist.github.com/4a9fed75521d885658f4 All the data coming out of the db is a string - becuase that's how mysql returns it. AD -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
