| # |
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) |
| # |
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.) |