[Vtigercrm-developers] Vtiger edit contact records in mysql

[Arnold den Boer]

I have a question about editing values using mysql.

What have I missed when editing a lastname value in the contact table.

After changing some values, the changes where applied in the contact
records, but not when doing a search. For example:

 

There was a record Arnold den Boer

Firstname : Arnold
middle name: den
Lastname: Boer

 

I created a query to merge middlename with lastname an update the field
lastname with this.

So record now is

Firstname : Arnold
middle name: den (this record will be removed when finished)
Lastname: den Boer

 

When I do a search “Arnold den Boer” returns nothing, while “Arnold Boer”
does.

 

Please help me out.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140111/051d8963/attachment.html>