Log message #110823

# At Username Text
# Aug 8th 2008, 00:09 thestaff what is the best way to do it ?>
# Aug 8th 2008, 00:09 thestaff drop down menu to select only a categorie
# Aug 8th 2008, 00:09 thestaff like input buttons to show a column or not
# Aug 8th 2008, 00:08 thestaff ok say I have a table and I wana have some filters
# Aug 8th 2008, 00:08 thestaff what is the best way to filter a table
# Aug 8th 2008, 00:07 Chezz it gave me headaches 6 months back i switch to mysql.. but now this application requires pg..
# Aug 8th 2008, 00:06 Chezz cakephp support for pg sucks
# Aug 8th 2008, 00:06 Mathachew hrm
# Aug 8th 2008, 00:05 Chezz with ` i get this error ERROR: syntax error at or near "`"
# Aug 8th 2008, 00:05 Chezz yea it works with select fine
# Aug 8th 2008, 00:05 Mathachew but definitely in my selects
# Aug 8th 2008, 00:05 Mathachew I've never used it in an update
# Aug 8th 2008, 00:04 Chezz Mathachew : just wanna let u know that i couldnt find "AS" in the latest PG docs
# Aug 8th 2008, 00:04 Chezz Mathachew : ok
# Aug 8th 2008, 00:04 Chezz i baked my applications and I am just testing the editting feature ..
# Aug 8th 2008, 00:03 Mathachew have you tried changing " to `?
# Aug 8th 2008, 00:03 Chezz http://bin.cakephp.org/view/48673213
# Aug 8th 2008, 00:02 Jonah i'll bookmark it
# Aug 8th 2008, 00:01 Mathachew ty
# Aug 8th 2008, 00:01 Jonah cool man
# Aug 8th 2008, 00:01 Chezz ok
# Aug 8th 2008, 00:01 Mathachew can you pastebin the query?
# Aug 8th 2008, 00:01 Chezz i even took out the double quote still i get this from PG ... ERROR: column "ProfileBio" of relation "profile_bios" does not exist
# Aug 8th 2008, 00:01 Mathachew do you have the full query?
# Aug 8th 2008, 00:01 Chezz it is double quote
# Aug 8th 2008, 00:01 infantigniter jonah: it lets the user know what's valid/not as they type. reallllly easy to implement. and as only 10% or something (and decreasing) of internet users is estimated to not use JavaScript, that's the 10% you can give a message that says "Please enter a username with such and such properties" rather than just empty/not stuff.
# Aug 8th 2008, 00:01 Mathachew " or `?
# Aug 8th 2008, 00:00 Chezz Mathachew : well it is doing this UPDATE "profile_bios" AS "ProfileBio" SET "ProfileBio"."bio" etc.... I am getting an error if I run this statement on pg client
# Aug 7th 2008, 23:59 infantigniter jonah: http://www.livevalidation.com/
# Aug 7th 2008, 23:59 Mathachew running Update in PG shouldn't be any different than in MySQL
# Aug 7th 2008, 23:59 Chezz cakephp is producing invalid Postgres sql statements. has anyone tested "UPDATE" on postgres ?
# Aug 7th 2008, 23:59 Jonah what's that?
# Aug 7th 2008, 23:59 infantigniter jonah: check out livevalidation :)
# Aug 7th 2008, 23:58 infantigniter jonah: i don't know then.
# Aug 7th 2008, 23:58 Jonah depreciated*
# Aug 7th 2008, 23:58 Jonah they're decreciated!
# Aug 7th 2008, 23:57 Jonah http://api.cakephp.org/validation_8php-source.html#l00035
# Aug 7th 2008, 23:57 Mathachew What's the best way to setup cake to work with multiple sites?
# Aug 7th 2008, 23:57 Jonah the thing is that I want a different error message for each rule. one for allowEmpty and one for each of my others
# Aug 7th 2008, 23:56 infantigniter jonah: given you have 'some other rule' to use.
# Aug 7th 2008, 23:56 infantigniter jonah: not sure, but you can always do 'ruleName'=>array('rule'=>'some other rule', 'allowEmpty'=>false)