GetMessage() function modification
Posted: Mon Apr 20, 2020 11:32 pm
Hi OpenDental,
I found that the following code could raise some errors (SmsToMobiles.cs line 108-110)
Although most of the time, the phoneNumber should be number but in some cases, it could be a name of a special sender. Can you add the string quote to enclose the phoneNumber value?
Example of error below. It's because 'Whitecoat' is a special number in Australia.
SELECT * FROM smstomobile WHERE PatNum = 0 AND MobilePhoneNumber = Whitecoat
Is it possible to fix it?
Thanks,
M
I found that the following code could raise some errors (SmsToMobiles.cs line 108-110)
Code: Select all
if(!string.IsNullOrEmpty(phoneNumber)) {
listCommandFilters.Add($"MobilePhoneNumber = {phoneNumber}");\
}Example of error below. It's because 'Whitecoat' is a special number in Australia.
SELECT * FROM smstomobile WHERE PatNum = 0 AND MobilePhoneNumber = Whitecoat
Is it possible to fix it?
Thanks,
M