# |
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? |
# |
Aug 7th 2008, 23:37 |
jerrylee |
anthony: yes |
# |
Aug 7th 2008, 23:36 |
anthony |
is attendant associated with course? |
# |
Aug 7th 2008, 23:36 |
jerrylee |
but if i dont set contain, it will give 2 level, including user |