Re: [sqlite] Warnings when compiling under clang on the Mac

2011-10-21 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 21/10/11 20:55, Matt Davies wrote: > May I safely ignore the warning messages, as such things always worry > me? Do be appear that compiler warnings are often useless nitpicking. Making them go away can often make the code worse or hide later

[sqlite] Warnings when compiling under clang on the Mac

2011-10-21 Thread Matt Davies
Hi, I get a lot of warning messages complaining about implicit conversion loses when compiling on the iMac. Is this a known issue? May I safely ignore the warning messages, as such things always worry me? Looking at the code, it routinely implicitly casts unsigned integers to integers and this

Re: [sqlite] triggers & last_insert_rowid?

2011-10-21 Thread James Hartley
On Fri, Oct 21, 2011 at 12:31 PM, Pavel Ivanov wrote: > http://www.sqlite.org/c3ref/last_insert_rowid.html > > "If an INSERT occurs within a trigger or within a virtual table > method, then this routine will return the rowid of the inserted row as > long as the trigger or

Re: [sqlite] triggers & last_insert_rowid?

2011-10-21 Thread Pavel Ivanov
> Because of the trigger's insertion into the second table, should not the > second select statement return a value of 2 instead of 1 since the last > insertion occurred in table t_log? http://www.sqlite.org/c3ref/last_insert_rowid.html "If an INSERT occurs within a trigger or within a virtual

[sqlite] triggers & last_insert_rowid?

2011-10-21 Thread James Hartley
After implementing simple auditing of table changes, last_insert_rowid() still provides the value I really want even though additional table inserts are being performed in the background. To illustrate: CREATE TABLE t (a); CREATE TABLE t_log ( timestamp DATETIME NULL DEFAULT

Re: [sqlite] Doc bug in on-line description of round() function

2011-10-21 Thread David Garfield
I think the use of "integer" was the mathematical concept, not the sqlite concept. That makes that part of the description correct. There are other possible issues: 1) It says "truncated" not "rounded". 1.7 truncated is 1, rounded is 2. 2) It says nothing about negative values of Y. For me

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Simon Slavin
On 21 Oct 2011, at 12:05am, Prashant Prabhudesai wrote: > $db = new SQLiteDatabase('db/reg.s3db'); This is the old-style SQLite2 interface. I strongly suggest you switch to the new SQLite3 interface as documented here: http://www.php.net/manual/en/book.sqlite3.php In that your line would be

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Stephan Beal
On Fri, Oct 21, 2011 at 1:05 AM, Prashant Prabhudesai < prashantprabhude...@gmail.com> wrote: > $row = $res->fecth(); > ... After the script exits successfully I inspect the value in the Token column > Are you 100% sure the above command executes correctly? -- - stephan beal

[sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token