Keith … THANKS.
I should have caught that — these senior citizen eyes ain’t what they used to
be.
> On Nov 23, 2016, at 8:24 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
>
>
> If what appears is what was entered, then you need to change the closing ’ to
> a closing ' (that is, from a funny word-processor symbol that looks like a
> quote but is really an apostrophe used in typesetting but is not a quote that
> terminates a string, into a quote to terminate the string) ...
>
> sqlite> select
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
> sqlite> select
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib');
>
> You have to be careful because most modern e-mail clients, unless
> specifically configured otherwise, are designed specifically for sending
> web-pages containing glossy-brochures by SMTP and are not suitable for use in
> exchanging plain-text that must not be tampered with. In this case the
> culprit was likely a configuration option that substituted "pretty quotes"
> and "apostrophes" for functional quotes. You can tell because the
> pretty-quotes are, well, pretty and curvy, such as are around your original
> “median”, while actual quotes that-do-something (other than look pretty) do
> not have curves: "median". The same mis-feature also changes single-quotes
> ' into apostrophes ’ in the circumstances it thinks such changes are
> appropriate depending on its substitution rules.
>
>> -----Original Message-----
>> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org
>> <mailto:sqlite-users-boun...@mailinglists.sqlite.org>]
>> On Behalf Of Ronald Gombach
>> Sent: Wednesday, 23 November, 2016 04:57
>> To: SQLite mailing list
>> Subject: Re: [sqlite] SQLite binary with Math Functions for OS-X?
>>
>> David,
>>
>> The brew/install worked and created the sqlite app and library in the
>> locations specified in your instructions.
>>
>> I can load the math lib from the .load (dot load) command line,
>> The median function works as I wanted
>>
>> but the ‘load_extension’ select statement did not work; I get a command
>> entry continuation line as follows
>>
>> sqlite> select
>> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
>> …>
>>
>> I need to be able to load the extension from within a PHP script
>>
>> Thoughts?
>>
>> Thanks.
>>
>> Ron Gombach
>> mailto:ron...@gombach.com <mailto:ron...@gombach.com>
>> <mailto:ron...@gombach.com <mailto:ron...@gombach.com>>
>>
>>
>>> On Nov 21, 2016, at 12:15 PM, David Goldwich
>> <david.goldwich+sql...@gmail.com> wrote:
>>>
>>> On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach <ron...@gombach.com>
>> wrote:
>>>>
>>>> Is there a pre-c binary of SQLIte available for down load that includes
>> a math library. I particularly need the “median” function.
>>>>
>>>> If not, can someone point me to instructions on compilation command
>> line to include the math library (OS-X).
>>>
>>> Homebrew can do that conveniently:
>>>
>>> $ brew update && brew install --with-functions sqlite
>>> $ /usr/local/opt/sqlite/bin/sqlite3
>>> sqlite> select
>> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
>>> sqlite> select pi();
>>> pi()
>>> 3.14159265358979
>>>
>>> The “math library” here being extension-functions.c from
>>> https://www.sqlite.org/contrib/.
>>> _______________________________________________
>>> sqlite-users mailing list
>>> sqlite-users@mailinglists.sqlite.org
>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@mailinglists.sqlite.org
>> <mailto:sqlite-users@mailinglists.sqlite.org>
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> <mailto:sqlite-users@mailinglists.sqlite.org>
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
