Log message #109961

# At Username Text
# Aug 7th 2008, 14:47 Eddie_CRO don't see it there...?
# Aug 7th 2008, 14:46 ADmad Eddie_CRO: yeah
# Aug 7th 2008, 14:46 Eddie_CRO or?
# Aug 7th 2008, 14:46 Eddie_CRO you mean database.php?
# Aug 7th 2008, 14:46 Eddie_CRO wait to check...
# Aug 7th 2008, 14:46 Raphael__ hello
# Aug 7th 2008, 14:46 ADmad Eddie_CRO: have u set 'encoding'->'utf8' in db config
# Aug 7th 2008, 14:45 moelee ah
# Aug 7th 2008, 14:45 _psychic_ Inflector::pluralize("sheep");
# Aug 7th 2008, 14:45 _psychic_ you can just call the Inflector to find out
# Aug 7th 2008, 14:45 Eddie_CRO )
# Aug 7th 2008, 14:45 Eddie_CRO that would be nice application
# Aug 7th 2008, 14:45 _psychic_ moelee: sheep, probably
# Aug 7th 2008, 14:45 Eddie_CRO better to give table name World or Universe -> WorldController or UniverseController
# Aug 7th 2008, 14:44 Eddie_CRO D
# Aug 7th 2008, 14:44 moelee or sheepcontroller
# Aug 7th 2008, 14:44 moelee the controller would be name sheepscontroller?
# Aug 7th 2008, 14:44 moelee err if the table was named sheep
# Aug 7th 2008, 14:43 moelee sheep
# Aug 7th 2008, 14:43 moelee so like
# Aug 7th 2008, 14:43 Eddie_CRO maybe retrival from db should be somehow formatted?
# Aug 7th 2008, 14:43 Eddie_CRO anyone has any experience with non english characters? mysql db is in utf-8, pages are in utf-8 but they don't display them right...?
# Aug 7th 2008, 14:43 bG^_ generally speaking, it's a VERY bad habit inserting/updating with views
# Aug 7th 2008, 14:42 bG^_ but yeah... i've seen many db treat this differentl
# Aug 7th 2008, 14:42 bG^_ i think it's an ANSI SQL limitation
# Aug 7th 2008, 14:42 teknoid bG^_: depends on the db, no?
# Aug 7th 2008, 14:42 bG^_ teknoid: you can't insert/update to views which are not 1-to-1 relation on the tables of the view
# Aug 7th 2008, 14:39 teknoid bG^_: hmm... why couldn't you do a save() on a view? ... the only thing that might be missing is a primary key, but you can define some column to act as one
# Aug 7th 2008, 14:37 TommyO moelee: the Inflector can handle some pretty complex exceptions. it also gives you a place to define your own rules
# Aug 7th 2008, 14:36 bG^_ teknoid: as long you you don't call save() on such model, and only do reads, it should work
# Aug 7th 2008, 14:36 teknoid bG^_: i'm don't see why not... although i haven't tried it :)
# Aug 7th 2008, 14:36 TommyO moelee: quite well
# Aug 7th 2008, 14:36 moelee how does cake handle words that are both plural and singular
# Aug 7th 2008, 14:35 moelee just out of curiosity
# Aug 7th 2008, 14:35 moelee hm
# Aug 7th 2008, 14:35 bG^_ teknoid: oh.. great :) didn't know if it's ok with cake to treat views as models as well...
# Aug 7th 2008, 14:35 teknoid bG^_: just make a model for the view
# Aug 7th 2008, 14:32 bG^_ is there an easy way to make all my "reads" from db views instead of db tables rather than writing the query myself?
# Aug 7th 2008, 14:27 TommyO contain is driving me batty. one minute it creates a left join, the next minute it doesn't :) first time really exploring its depths
# Aug 7th 2008, 14:24 lqdice__ oh ok
# Aug 7th 2008, 14:24 TommyO no, I mean in my own models