Searching for a contact

[Morgan Gunter]

Programmer is trying to set up a CRM custom integration but is having issues when searching for a contact.

Here is the trouble he is having.
Ok, so the verbose logs are indicating that 'column number does not exist'. Here's the SQL query:

 

[Morgan Gunter]

 

[Evolute IT]

Is that in the lookup query or the search query?

 

[paulodagraca]

Hi Morgan Gunter,

Well i almost never understand code from somebody else
But when I see this query, like below, in my head it should change into something like the part below.

SELECT * FROM contacts WHERE
phonebusiness LIKE CONCAT ('%',@Number,'%') or
phonemobile LIKE CONCAT ('%',@Number,'%') or
faxbusiness LIKE CONCAT ('%',@Number,'%');

Change into this?

SELECT * FROM contacts WHERE
phonebusiness LIKE CONCAT ('%',4802855146,'%') or
phonemobile LIKE CONCAT ('%',4802855146,'%') or
faxbusiness LIKE CONCAT ('%',4802855146,'%');

Leave the reference @number, where number has the value 4802855146
or replace the @number in the query by the number 4802855146

What should never happen is change the column name (phonebusiness, phonemobile, faxbusiness) in the number 4802855146

Not sure if any of this information will help, but it's out of my head now

Paulo

 

[Morgan Gunter]

Hello Paulo, thank you for taking the time to look at this. I have sent your reply to the programmer.