typo? phone_buisness -> phone_business
On Fri, Jul 18, 2008 at 5:47 AM, RJ <[EMAIL PROTECTED]> wrote:
>
> 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 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
-~----------~----~----~----~------~----~------~--~---
