[sqlite] like operator

Hi Guys, select name from employee table where name like '%Araya%' or name like '%Amul%' or name like '%Aj%'; Table - Employee Id | Name | age | 1 | Arayan Kuma | 29 | 2 | Amul Kanth | 30 | 3 | Ajay Kumar | 45 | I dont like to use may or conditions for pattern matching usi

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

On 11/09/2016 02:39 PM, Luca Ferrari wrote: Hi all, this could be trivial, but assuming I need some shell script to query SQLite3 databases with variable-interpolated queries, what can I do? Of course the following does not work because ticks prevent variable interpolation: COUNT=`sqlite3 $db 'S

[sqlite] undefined symbol: Tcl_CreateObjCommand

Hi guys, I am using a module called Tcl-1.05 in perl. But when i try to load a tclsqlite3.5.3.so file it throws an error like undefined symbol: Tcl_CreateObjCommand. If i just specify the tclsqlite-3.5.3.so it will search in this particular location which is /usr/local/lib/tclsqlite-3.5.

Re: [sqlite] undefined symbol: Tcl_TranslateFileName

On 11/02/2016 03:27 PM, no...@null.net wrote: On Wed Nov 02, 2016 at 02:56:01PM +0530, ravi.shan...@cellworksgroup.com wrote: load a tclsqlite3.5.3.so file it throws an error like this. Probably released on 2007-11-27 - nearly 9 years ago. http://search.cpan.org/~vkon/Tcl-1.05/Tcl.pm

[sqlite] undefined symbol: Tcl_TranslateFileName

Hi guys, I am using a module called Tcl-1.05 in perl. But when i try to load a tclsqlite3.5.3.so file it throws an error like this. Module Name - Tcl-1.05 Link : http://search.cpan.org/~vkon/Tcl-1.05/Tcl.pm Perl verison - 5.8.8 Tcl version - 8.5 The tclsqlite3.5.3.so file exists

[sqlite] sqlite3 db is encrypted how to decrypt

Hi guys, I have a sqlite3 db which is encrypted using lib.so file how to decrypt the db. If i access the db it print db is encrypted or not a database. I don't have any idea about lib.so file and encryption used in it. Does lib.so file uses any algorithm for encryption. Any sugges