Page 294 of 211,263, showing 20 records out of 4,225,242 total, starting on record 5,861, ending on 5,880
| # | Username | Text | |
|---|---|---|---|
| # | Aug 8th 2008, 16:26 | aarongustafson | 2: I am writing a little custom SQL for a model and (for some reason) my single quotes (around string values) are being converted to html entities and causing the query to fail. is it because I'm building the query as a string ($sql) and then passing that to $this->query()? |
| # | Aug 8th 2008, 16:27 | vudew | ah ha! |
| # | Aug 8th 2008, 16:27 | teknoid | aarongustafson: have you tried double quotes? |
| # | Aug 8th 2008, 16:27 | aarongustafson | same |
| # | Aug 8th 2008, 16:27 | vudew | my form was fuckedu p |
| # | Aug 8th 2008, 16:27 | M4ngoB00M | teknoid - its just that it seems I have to manually "cake bake all tablename" and then answer a bunch of questions for every table. I have 60 tables and I want to know if there is a way for me to write a single script that I can one-click to bake everything at once from a schema... |
| # | Aug 8th 2008, 16:28 | aarongustafson | teknoid: single quotes became and#39; and double quotes became andquot; |
| # | Aug 8th 2008, 16:28 | zmonteca | teknoid: is there any configuration stuff that i might be missing regarding the ajaxhelper? why would my response body be empty every time? |
| # | Aug 8th 2008, 16:28 | teknoid | aarongustafson: not sure, never seen this happen |
| # | Aug 8th 2008, 16:28 | aarongustafson | me either |
| # | Aug 8th 2008, 16:29 | aarongustafson | teknoid: here's the SQL: $sql = "DELETE `keywords_works` |
| # | Aug 8th 2008, 16:29 | aarongustafson | FROM `keywords_works` |
| # | Aug 8th 2008, 16:29 | aarongustafson | JOIN `keywords` ON `keywords_works`.`keyword_id` = `keywords`.`id` |
| # | Aug 8th 2008, 16:29 | aarongustafson | WHERE `keywords_works`.`work_id` = {$data['id']} |
| # | Aug 8th 2008, 16:29 | aarongustafson | AND ("; |
| # | Aug 8th 2008, 16:29 | aarongustafson | foreach( $data['keywords'] as $keyword ){ |
| # | Aug 8th 2008, 16:29 | teknoid | zmonteca: are you loading the correct view/layout? |
| # | Aug 8th 2008, 16:29 | aarongustafson | $sql .= " `keywords`.`name` = '{$keyword}' OR "; |
| # | Aug 8th 2008, 16:29 | aarongustafson | } |
| # | Aug 8th 2008, 16:29 | teknoid | aarongustafson: bin |