[asterisk-users] Error: 'LENGTH' is not a recognized built-in function name

[Deepak Rawat]

On Mon, Aug 11, 2014 at 3:29 AM, Deepak Rawat <deepaksingh.rawat at gmail.com>
wrote:

> Hi,
>
> I modified the query in res/res_config_odbc.c.
> Original:  "SELECT MAX(LENGTH(var_val)) FROM %s WHERE filename='%s'"
> Modified: "SELECT MAX(LEN(var_val)) FROM %s WHERE filename='%s'"
>
> I rebuilt the code and installed Asterisk again. Now static realtime is
> working. Should I file a bug report?
>
>
> On Mon, Aug 11, 2014 at 2:37 AM, Deepak Rawat <deepaksingh.rawat at gmail.com
> > wrote:
>
>> Hi,
>>
>> I am using Asterisk 12.4 static realtime. I am storing agents.conf
>> related data in MS SQL Server 2012 database. But I keep getting *'LENGTH'
>> is not a recognized built-in function name* error message. I debugged
>> and found that it's due to the changes done in this ticket:
>> https://issues.asterisk.org/jira/browse/ASTERISK-23582. As there is no
>> LENGTH function in MS SQL Server, therefore, I am getting this error. Is
>> this error due to some config issue at my end?
>>
>> Thank you,
>> Deepak
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140811/921396c0/attachment.html>