IgnitedRecord 1.0 pre-release - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22) +--- Thread: IgnitedRecord 1.0 pre-release (/showthread.php?tid=7996) |
IgnitedRecord 1.0 pre-release - El Forum - 11-12-2008 [eluser]dcunited08[/eluser] @m4rw3r I figured out to put the fk in the has_many array in the machine_model. It seems there is a bug in your _protect_identifiers with the mssql driver, will report back with a fix. UPDATE: I put a break at line 2298 in file ignitedquery.php and it worked. The issue is it is putting quotes around the table name and making MSSQL error out. A similar but was in the 1.6.3 ver CI_Active_Record class for MSSQL (it has been fixed in 1.7.0). IgnitedRecord 1.0 pre-release - El Forum - 11-12-2008 [eluser]amrnt[/eluser] why i have some problems in QUERIES? e.g. ....... SELECT `posts`.* FROM `posts` ORDER BY `title` DESC ....... and the problem is in (`posts`.*) !!! IgnitedRecord 1.0 pre-release - El Forum - 11-12-2008 [eluser]sophistry[/eluser] your question is unclear. please post code. IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]amrnt[/eluser] when i run an SQL query like this ( SELECT `posts`.* FROM ..... ) it represents me undefined (`posts`.*) column !!?? IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]m4rw3r[/eluser] What SQL server do you use? IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]amrnt[/eluser] MySQL 5.0.11 .. IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]m4rw3r[/eluser] Never had that kind of problem, are you sure that it isn't complaining about the title column? IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]amrnt[/eluser] ... ops .. will DONE .. Thanks for this great library!!! but i have a question ... why limit() doesn't work with this ? or doesn't make sense! controller Code: $data['category'] = $this->category->order_by('posts.id', 'DESC')->limit(1)->join_related('posts')->find($id); SQL Code: SELECT `posts`.`id` AS `posts_id`, `posts`.`title` AS `posts_title`, `posts`.`body` AS `posts_body`, `posts`.`created_at` AS `posts_created_at`, `posts`.`updated_at` AS `posts_updated_at`, `posts`.`permalink` AS `posts_permalink`, `posts`.`category_id` AS `posts_category_id`, `categories`.* where i have to put limit() to limit my posts? IgnitedRecord 1.0 pre-release - El Forum - 11-13-2008 [eluser]m4rw3r[/eluser] The problem with the disappearing LIMIT is that I made a wrong return value from a conditional I inserted in the find single methods, I've fixed it now. The purpose of the conditional is to determine if to apply a limit 1, or if to skip limit (joined). IgnitedRecord 1.0 pre-release - El Forum - 11-14-2008 [eluser]amrnt[/eluser] yeah ,, 'Changeset 219 for trunk/application/libraries/ignitedrecord/ignitedrecord.php' it works fine now ! thanks |