Re: HABTM doesn't seem to be working
Sounds like you are on track. You are modifiying an existing DBO file to make the necessary changes to create valid SQL statement for Oracle. What other less obtrusive way could their be? And what is not ideal? You are making a new controller for Oracle that doesn't currenlty exist. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
The code is located at http://cakephp.org/pastes/show/081dbc0d1d0c131feec6be10e02d9285 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
I think I got it figured out: Oracle always returns field values as UPPERCASE. This caused problems with the way that Cake is programmed. I modified the dbo_source and datasource files to compensate for this. It works, but is not ideal. I can place the code up at cakebin for your viewing pleasure. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
The sheet (page) and section controllers and models are at http://cakephp.org/pastes/show/f9985ada4a1e1d83a5eab4f3cceb10f0 Thanks for taking a look at them --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
On 5/4/06, Dave Rogers <[EMAIL PROTECTED]> wrote: > > I can't find cakebin on the newly designed site. http://cakephp.org/pastes/add --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
I can't find cakebin on the newly designed site. After I posted the code, I realized I should have said that I was working on a new dbo for Oracle. I have made modifications to the dbo_source and datasource files, which might be the problem. I am doing this because you can't get the table name from oracle like you can in MySQL. I have already committed to a project using Cake and need to make it work. When a table has other tables associated with it, does Cake parse through all the tables to find all the fields of the current table and the associations? Could that be the reason that all the tables are not showing up? I would like to find a cleaner way to do all this, but the only way I could find so far is to do something like this: In the dbo_source file, fields function, around line 1050 I have modified the code from: $fields[$i] = $this->name($alias) . '.' . $this->name($fields[$i]) . ' AS ' . $this->name($fields[$i]); to $fields[$i] = strtoupper($this->name($alias) . '.' . $this->name($fields[$i]) . ' AS ' . $this->name($alias) . '_#_' . $this->name($fields[$i])); Which in effect prepends the table alias name to the field name and concatonates them with '_#_'. I can then use that to re-generate the table name in the dbo_oracle.php file. Does it all make more sense now? Am I on the right track? Can you point me in another, less intrusive way to do this? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: HABTM doesn't seem to be working
We need to see some more code for this. Put your controller and models in cakebin at http://cakephp.org/ pastes/add Then you can send us the link to it. Jump on IRC if you need a quicker response. http://irc.cakephp.org has a web client. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
HABTM doesn't seem to be working
I have created 3 tables: pages, sections, page_sections. All naming conventions aside, the findAll() query returns Array ( [0] => Array ( [SECTION] => Array ( [ID] => 4 [ACCOUNT_ID] => 5000 [NAME] => accounting [STANDARD] => 1 [VISIBLE] => 1 [DISPLAY_NAME] => Accounting ) ) [1] => Array ( [SECTION] => Array ( [ID] => 3 [ACCOUNT_ID] => 5000 [NAME] => project [STANDARD] => 1 [VISIBLE] => 1 [DISPLAY_NAME] => Project ) ) [2] => Array ( [SECTION] => Array ( [ID] => 2 [ACCOUNT_ID] => 5000 [NAME] => contacts [STANDARD] => 1 [VISIBLE] => 1 [DISPLAY_NAME] => Contacts ) ) [3] => Array ( [SECTION] => Array ( [ID] => 1 [ACCOUNT_ID] => 5000 [NAME] => request [STANDARD] => 1 [VISIBLE] => 1 [DISPLAY_NAME] => Request ) ) ) The $habtm looks like this: var $hasAndBelongsToMany = array('Section' => array('className' => 'Section', 'joinTable' => 'INT_CONF_PAGE_SECTION', 'foreignKey' => 'SECTION_ID', 'associationForeignKey'=> 'PAGE_ID', 'conditions' => '', 'order' => '', 'limit' => '', 'uniq' => true, 'finderSql' => '', 'deleteQuery'=> '', ) ); Any ideas why it isn't returning both page and section information in the resultset? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---