| # |
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) |
| # |
Aug 7th 2008, 23:50 |
Jonah |
is 'rule' => VALID_NOT_EMPTY depreciated? |
| # |
Aug 7th 2008, 23:44 |
jerrylee |
anthony: i will try your code |
| # |
Aug 7th 2008, 23:42 |
jerrylee |
anthony: ah, maybe you teach me something |
| # |
Aug 7th 2008, 23:42 |
infantigniter |
(and i can't cheat by adding my own quotes; query is smart and delimits them.) |
| # |
Aug 7th 2008, 23:42 |
infantigniter |
anybody have any idea why query() won't put quotes around my varchar field for a condition |
| # |
Aug 7th 2008, 23:41 |
anthony |
it's contain |
| # |
Aug 7th 2008, 23:41 |
anthony |
is it contain or contains? |
| # |
Aug 7th 2008, 23:40 |
anthony |
i think that's right |
| # |
Aug 7th 2008, 23:40 |
anthony |
$this->Course->find("all", array("contain" => array("Attendant" => array("User")), "recursive" => 2)); |
| # |
Aug 7th 2008, 23:39 |
anthony |
always worked like a charm |
| # |
Aug 7th 2008, 23:39 |
anthony |
i've done it with 2 and 3 |
| # |
Aug 7th 2008, 23:39 |
jerrylee |
anthony: in your case it works? |