Bug on my AROS... :(

2009-11-09 Thread Xanax
Hello, I don't understand my bug. I've created a parent_node function on my user model that return a role_id. Every user have a role. When i create a new user, it create also an ARO associated with the proper role. The problem is that EVERY user is registred as ADMIN role. Whereas when i

Simple question : model file of a Join Table ?

2009-10-30 Thread Xanax
Hello, I need to configure the model of a join table. Actually, like in my others models, i just need to add this thing : var $sequence = 'MY_SEQUENCE'; I tried to create a model file with the name of the table (singular, whithout the 's') but it doesn't seems to work or perhaps i missed

Re: CakePHP doesn't use my sequence.......

2009-10-26 Thread Xanax
Hello, Thanks for your answer. I've seen this page, i had already modified my code like it is recommanded. I have the version just before the latest stable CakePHP 1.2.5 : mine is 1.2.4.8284 I've seen the changelog of the 1.2.5 version, it doesn't seems that this version correct a bug

Can i modify properties of ACL models please ? :-0

2009-10-26 Thread Xanax
Hello everyone, My problem is simple. I need to specify the $sequence variable in all my models because i use sequences to handle the autoincrement id of my Oracle Primary keys. I created three file in my model folder :aco.php, aro.php, aro_aco.php juste with this code : ?php class Aro extends

CakePHP doesn't use my sequence.......

2009-10-16 Thread Xanax
Good morning everyone, I'm using CakePHP with Oracle and sequences (i can't use triggers because it's forbidden in my company...) I CAN'T add record to my database through my CakePHP app. I respected all naming conventions. I have a table name PROJET, his ID is anumber type, not null. I've

CakePHP + Sequences = weird problem...

2009-10-12 Thread Xanax
Hello, I have a problem with a sequence in my cakePHP app. The problem is simple : when i call the nextval from a sequence, in a script, it increment by one only ONE time. IE when i do this : $sequence_planifications = $this-Planification- query('SELECT PLANIFICATIONS_ID_SEQ.nextval from

Problem with saving id's

2009-09-30 Thread Xanax
Hi everyone, I've got a little problem with my cake app'. My database is Oracle. Every data saving handled by cake engine works fine. The problem is with a 'manual' saving : $this-User-Planification-create($data_planification);

Re: Mapping beetween CakePHP attribute's model's names and real database table's names!

2009-09-04 Thread Xanax
ok :( On 3 sep, 18:27, Miles J mileswjohn...@gmail.com wrote: If you hardcoded the column names, then yes you would have to change them manually. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To

seTable for ACL tables ?...

2009-09-04 Thread Xanax
Hello, Do you know if there is a way to set the $useTable variable for ACL tables ? I changed the names of acos, aros, aros_acos to T_acos,T_aros,T_aros_acos tables and i need to make a mapping beetween the new names and the models. I tried to create 3 models file acos.php etc... with var:

Oracle autoincrement : PROBLEM

2009-09-04 Thread Xanax
Hi, I have a BIG problem. There is no autoincrement option in Oracle like in MySQL. Apparently, with CakePHP and Oracle, people use sequences and triggers to bypass this. My problem : I can't use triggers on my database, it's forbidden by my company. And of course i don't want to replace all

Simple question !

2009-09-04 Thread Xanax
Is it possible to create a beforesave method for all the models ? I mean in a file like app_controller which controll all the controllers --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this

Mapping beetween CakePHP attribute's model's names and real database table's names!

2009-09-03 Thread Xanax
Hi, I would just like to know if it's possible to make this kind of mapping. Example : if I change the name of a column in my database. Must do I change also ALL the name of this column in all my php code ?... I know that in the model's file we can make a mapping with usetable for the real

Re: Change the alias or the name of a table !!

2009-08-28 Thread Xanax
Thanks a lot ! On 28 août, 06:52, Dr. Loboto drlob...@gmail.com wrote: class MyModel extends AppModel {     $this-name = 'MyModel';     $this-alias = 'MyPreferredAlias';     $this-useTable = 'my_actual_table_name'; } On Aug 27, 11:13 pm, Xanax mammer...@gmail.com wrote: Hi, I need

Debug SQL requests in a log file ?

2009-08-28 Thread Xanax
Hi, I've got some problems with my cakephp app : i have this message when i launch it : Fatal error: Maximum execution time of 30 seconds exceeded in C: \Program Files\EasyPHP 3.0\www\cake_1_2\cake\libs\model\datasources\dbo \dbo_oracle.php on line 357 I would like to know how it's possible to

Weird SQL requests with CakePHP on an Oracle DataBase ?!!

2009-08-27 Thread Xanax
Hi everyone, I've transfered all my data from MySQL to an Oracle Database. It used to work very well with MySQL. Now, when i try to launch my application, i've got weird request. I respected all tablename conventions from the CakePHP sites so i've set plural tablenames. For examples for the

Re: Weird SQL requests with CakePHP on an Oracle DataBase ?!!

2009-08-27 Thread Xanax
I found the reason : it's the alis GROUP. This is a keyword reserved by ORACLE database engine. How can i change the alias ? Perahps in the model of the table ? Another solution is to change the tablename so it will change the alias associated but i would have to change a lot of SQL request...

Changing the alias giver to a table ! :)

2009-08-27 Thread Xanax
Hi, I have a problem with some SQL request in Oracle. GROUP is a reserved keyword for Oracle. And Cakephp generate some SQL request with this alias (because my table's name is GROUPS). So these request don't work until i change the alias from GROUP to GROUPE for example. I would like to know

Change the alias or the name of a table !!

2009-08-27 Thread Xanax
Hi, I need to change the alias OR the name of a table. It's weird, i tried to change many variable whithout any changes on requests generated by Cakephp : var $name var $useTable The name of the controller (the name of the file AND the name of the class) The name of the model(the name of the

Connecting to ORACLE Database !

2009-08-24 Thread Xanax
Hello, I've been developing my cakephp application with MySQL sor far and now i must migrate the database to an oracle one. I've created an oracle database and import the tables, everything wrked fine. Here an extract of the tsnames.ora entry concerning this databse : ORACLE_DPRO =

Can i display an Auth Message Error please ?

2009-06-03 Thread Xanax
Hi everyone, My problem is quite simple : i've setup auth and ACL in my application everything seems to work fine unless one thing : When a user try to launch a forbidden (for him) controllers/actions, it' just redirect him to another page autorized for him. I would just like to have an

Re: Can i display an Auth Message Error please ?

2009-06-03 Thread Xanax
Thank you very much, i've just add : ?php $session-flash(); $session-flash('auth'); ? and it works now Bye --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to