got the query by putting the DEBUG level to 2...
the error that i get is :

Warning (512): SQL Error: 1366: Incorrect integer value: '' for column
'phone_buisness' at row 1

the column phone_buisness is 'int' with default as null.
When i enter any valid number , the record is saved , but when i leave
it blank it gives me this error.

Any help would be appreciated.

On Jul 18, 12:57 pm, RJ <[EMAIL PROTECTED]> wrote:
> Still not able to figure out the error, i feel its with the query
> thats formed when Model::save() is called.
>
> Could any one tell me how to get the query string when Model::save()
> is called.
>
> On Jul 18, 12:03 pm, schneimi <[EMAIL PROTECTED]> wrote:
>
> > Just set the debug level to 2 in the core.php:
>
> > Configure::write('debug', 2);
>
> > RJ schrieb:
>
> > > I am having problem in saving the records in the database.The code is
>
> > > if($this->User->create($this->data) && $this->User->save())
> > > {
> > >  //success
> > > }
> > > else
> > > {
> > >  //Failed
> > > }
>
> > > The control always goes to else block .How can i track the problem.
> > > Basically is there any way to get the SQL query string.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" 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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to