Re: [sqlite] Unable to make SQLite working with Java

2010-11-28 Thread Timothy A. Sawyer
have libsqlite_jni.so. > > Any idea? > > -- > A+ > > - > Pierre > -- A+ - Pierre ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the

Re: [sqlite] Unable to make SQLite working with Java

2010-11-28 Thread Timothy A. Sawyer
Pierre > -- A+ - Pierre ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing

Re: [sqlite] sqlite cannot find the row

2010-09-27 Thread Timothy A. Sawyer
Without seeing the original schema and more information on what you changed, no idea. ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400 Morristown, NJ 07960 Phone: (973) 285-3261 | Fax: (973) 538-0503

Re: [sqlite] sqlite cannot find the row

2010-09-27 Thread Timothy A. Sawyer
What does the table schema look like? ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400 Morristown, NJ 07960 Phone: (973) 285-3261 | Fax: (973) 538-0503 Web: http://www.mybowlingdiary.com Email: tsaw

Re: [sqlite] Reserve database pages

2010-08-12 Thread Timothy A. Sawyer
sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer,

Re: [sqlite] Encryption

2010-07-24 Thread Timothy A. Sawyer
sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400 Morristown, NJ 07960 Phone: (973) 285-3261 | Fax: (973) 538-0503 Web: http://www.myb

Re: [sqlite] how to get the number of rows in a a table?

2010-07-20 Thread Timothy A. Sawyer
. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ** Sent from my mobile device with the tiny keys ** Timothy A. Sawyer, CISSP Managing Director MBD Consulting, LLC 55 Madison Av., Suite 400

Re: [sqlite] noobie Is there an additional web site for noobie questions.??

2010-07-12 Thread Timothy A. Sawyer
www.sqlite.org is the web site. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of B H Sent: Monday, July 12, 2010 9:48 AM To: sqlite-users@sqlite.org Subject: [sqlite] noobie Is there an additional web site for noobie questions.?

Re: [sqlite] Encryption of sqlite DB

2010-05-04 Thread Timothy A. Sawyer
horse got out. Timothy A. Sawyer, CISSP Managing Director MBD Solutions -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kavita Raghunathan Sent: Tuesday, May 04, 2010 12:19 PM To: Discussion of SQLite Database Subject: [s

Re: [sqlite] WHERE = does not work

2010-04-30 Thread Timothy A. Sawyer
With the like clause you have to use the % sign as a wildcard. So resourceType LIKE %'PSM' returns anything ending in PSM. The SQLite website has excellent docs on standard SQL. -Original Message- From: ecforu Sent: Friday, April 30, 2010 09:22 To: sqlite-users@sqlite.org Subject: [sqli

Re: [sqlite] Using SQLite from Java

2009-10-19 Thread Timothy A. Sawyer
What information are you looking for? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland Sent: Monday, October 19, 2009 9:59 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Using SQLite from

Re: [sqlite] SQLite Windows Mobile 6 Edition

2009-09-05 Thread Timothy A. Sawyer
I would be extremely interested in what you are doing with this project. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dominique Jann Sent: Friday, September 04, 2009 2:00 PM To: sqlite-users@sqlite.org Subject: [sqlite] SQ

Re: [sqlite] Importing data into SQLite

2009-08-31 Thread Timothy A. Sawyer
You can use the sqlite binary to import data from a CSV file - if you do it that way you have to make sure that your data fields in the SQLite database match exactly in order the data in the CSV file. That's been my experience. The other way is to do it programmatically (Java, C++, etc). The advant

Re: [sqlite] pure Java SQLite browser/client?

2009-03-23 Thread Timothy A. Sawyer
of a pure Java client that can be used to browse and run SQL commands? -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing

Re: [sqlite] datetime as integer

2009-03-13 Thread Timothy A. Sawyer
: sqlite-users@sqlite.org Sent: Mar 13, 2009 14:58 Subject: Re: [sqlite] datetime as integer Just a few corrections. On Fri, 13 Mar 2009 13:48:46 +, "Timothy A. Sawyer" wrote: >To be able to do this you need the following data points: > >1. What is the integer representation o

Re: [sqlite] datetime as integer

2009-03-13 Thread Timothy A. Sawyer
s datetime. Can anyone help me please? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132

Re: [sqlite] Date datatype

2009-01-21 Thread Timothy A. Sawyer
iling list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: tsaw...@mybowlingdiary.com ___ sqlite

Re: [sqlite] Documentation to learn sqlite code for newbies?

2009-01-11 Thread Timothy A. Sawyer
s. Of course it is impossible to write everything in a singlo book :-) Thanks in advance Best regards, Silvio ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. S

Re: [sqlite] SQLite file security

2008-11-20 Thread Timothy A. Sawyer
foolproof. If someone really wants access, they are going to get it. All you are trying to do is make it costly for potential attackers to access your data to a point where they consider that the cost outweighs the value. Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 54

Re: [sqlite] Sqlite3Explorer Sqlite Report Designer

2008-11-14 Thread Timothy A. Sawyer
If you want something that is Windows based like you describe, why not use Java to build a Swing GUI? Delphi and Pascal are a little antiquated so if you need to revise you may have a problem finding a resource. Also consider the platform independence if that is a concern Timothy A. Sawyer

Re: [sqlite] Problem with dates

2008-11-04 Thread Timothy A. Sawyer
If anyone is interested in knowing how to do this please let me know Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] -Original Message- From: "Timothy A. Sawyer" <[EMAIL PROTECTED]&g

Re: [sqlite] Problem with dates

2008-11-04 Thread Timothy A. Sawyer
Thanks. Changing the date format when exporting from Access seems to have done the trick. Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[sqlite] Problem with dates

2008-11-03 Thread Timothy A. Sawyer
a from Access? Do I need to convert them to -MM-DD? Any assistance is appreciated. Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: <http://www.mybowlingdiary.com/> http://www.mybowlingdiar

Re: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

2008-10-21 Thread Timothy A. Sawyer
plied." Is there something else I need to do to have the primary key column computed automatically? Thanks, Ken ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer,

Re: [sqlite] from access to sqlite

2008-10-08 Thread Timothy A. Sawyer
quot; 23:59:59" can we help me? -- Fabio ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http:/

Re: [sqlite] Column values

2008-10-06 Thread Timothy A. Sawyer
r etc. I am accessing an unknown file. Have a super one! Merv ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-713

[sqlite] Question on limit with INTEGER PRIMARY KEY

2008-09-23 Thread Timothy A. Sawyer
n unsigned integer? Thanks in advance Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: <http://www.mybowlingdiary.com/> http://www.mybowlingdiary.com Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] __