If there is no value set for this field, I guess it's trying to set an
empty string as default. I guess the only way is to care about the
field not beeing empty respective is set to 0.
But it looks like you are using an int-field for a phone-number, so I
suggest to simply change it to a (var)char-field, so you also don't
get trouble with phone-numbers that have a leading zero.
Hope this helps
On 18 Jul., 10:10, RJ <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
