Re: [sqlite] seeking working PDO-Sqlite with php form example

2012-07-06 Thread Simon Slavin
On 5 Jul 2012, at 3:43am, D A way...@gmail.com wrote: Can anybody explain to me how to set up my sqlite database file with my Linux server? To my limited knowledge, i have uploaded the following files in a directory on my server: 1. sqlite.db 2. form.php Do i have to also upload the

[sqlite] SQLite Provenance

2012-07-06 Thread Gavin T Watt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Can anyone tell me where (what country) the SQLite server(s) are located? Gavin Watt, CISSP Sr. Prin. Sys. Engr. Information Assurance Network Centric Systems (NCS) 714-446-3104 (office) 714-234-8869 (BB) 714-446-4136 (fax) gw...@raytheon.com

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Stephan Beal
On Fri, Jul 6, 2012 at 5:29 PM, Gavin T Watt gw...@raytheon.com wrote: Can anyone tell me where (what country) the SQLite server(s) are located? If i remember Richard's recent presentation properly there are 3 in the US (west coast, Texas, and east coast) and a newer one in the UK(?). --

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/07/12 08:29, Gavin T Watt wrote: Can anyone tell me where (what country) the SQLite server(s) are located? Go to http://centralops.net and enter the site of interest into domain dossier. You will see that the sqlite.org domain name is openly

Re: [sqlite] Inserting from another table...

2012-07-06 Thread Sam Carleton
Pavel, The goal is to get them all into one row, correct. The query does not seem to do anything, the table is empty after I run the query. One question... In the PP_VIEWER_SETTINGS, I have columns of different types, but in DBLookup all the values are varchar's. Since sqlite doesn't actually

Re: [sqlite] Inserting from another table...

2012-07-06 Thread Pavel Ivanov
The query does not seem to do anything, the table is empty after I run the query. This can only mean that there was some error executing insert. It's written in a way that it just cannot leave empty table for any reason except error. You have all columns NOT NULL, so maybe dblookup doesn't have

Re: [sqlite] Inserting from another table...

2012-07-06 Thread Keith Medcalf
Does saying what you want to do this way work better? insert into PP_VIEWER_SETTINGS (COMPANY_NAME, DSPNEXTPREVIOUS, ENABLE_CARTS, ENABLE_DEBUGINFO, ENABLE_FAVORITES, ENABLE_RIGHTCLICK, ENABLE_SLIDESHOW, ENABLE_TIMEOUT, EXIT_KVS, EXIT_PASSWORD,

Re: [sqlite] Inserting from another table...

2012-07-06 Thread David Bicking
Have you tried to replace the Insert into values( with just Select ( to make sure the values are what you expect them to be. That might also point out if any of them are null. David From: Sam Carleton scarle...@miltonstreet.com To: General Discussion of

Re: [sqlite] Inserting from another table...

2012-07-06 Thread Keith Medcalf
You should probably replace all the with ' as well. is for identifiers (column/table names, etc.). ' is for strings. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Gavin T Watt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Thanks for the information. Not a Jingoistic quest, but we're using SQLite in a system for which there is an interest in the provenance of SQLite for security reasons. With the server ins Dalls, we golden! Gavin Watt, CISSP Sr. Prin. Sys. Engr.

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/07/12 14:58, Gavin T Watt wrote: ... the provenance of SQLite for security reasons. Where the server is is of little interest. It would be good if the team actually signed the release in some way then at least you would know it was what they

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Nico Williams
What the OP is interested in, most likely, is that SQLite3 is not from Cuba, Iran, North Korea, ... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Gavin T Watt
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 I totally agree with you about about the server location being of little interest, really, and that the having access to the source is much more important. However, my customer wanted me to check this anyway,a nd you've answered the mail. BTW, do

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Simon Slavin
On 6 Jul 2012, at 11:10pm, Nico Williams n...@cryptonector.com wrote: What the OP is interested in, most likely, is that SQLite3 is not from Cuba, Iran, North Korea, ... This is the question: what does 'from' (or in the original, 'Provenance') mean. SQLite3 is the API which, the way the

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Simon Slavin
On 6 Jul 2012, at 11:24pm, Gavin T Watt gw...@raytheon.com wrote: BTW, do you know if the SQLite team runs any kind of static code analysis on the source? SQLite is plain C code. Note even C++. So static code analysis is tricky and not likely to be much use. However, Clang static analysis

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Stephan Beal
On Sat, Jul 7, 2012 at 12:24 AM, Gavin T Watt gw...@raytheon.com wrote: BTW, do you know if the SQLite team runs any kind of static code analysis on the source? http://www.sqlite.org/testing.html -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal

Re: [sqlite] SQLite Provenance

2012-07-06 Thread PJ Naughter
I would disagree that static code analysis is not useful for plain C code as opposed to C++. I have used SQLite3 in Visual C++ 2010 with SP1 for Windows x86 compilation using its' static code analysis command line option of /analyze as well as using level 4 compilation (/W4) and there are a number

Re: [sqlite] SQLite Provenance

2012-07-06 Thread Stephan Beal
On Sat, Jul 7, 2012 at 3:05 AM, PJ Naughter p...@naughter.com wrote: I would disagree that static code analysis is not useful for plain C code as opposed to C++. Nowhere do they docs say that. They say they have not proven to be an effective use of time *for sqlite3*. In fact, they qualify

Re: [sqlite] Inserting from another table... (resolved)

2012-07-06 Thread Sam Carleton
Folks, I would like to thank one and all, I think this was a group effort. I changed the double quotes to single, changed the value into a select and then just ran the select part and found one NULL filed because I had the wrong category. Fixed that and left it as a select and all is well! Thank