got the solution....
before saving , i am making a check as follows:
if($this->data[xyz][phone] == ' ')
$this->data[xyz][phone] = 0;
On Jul 18, 2:27 pm, schneimi <[EMAIL PROTECTED]> wrote:
> 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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
