-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 issu
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
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 virtual table method is
> 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 ta
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 CURRENT_TIMESTAMP
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 a
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
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
http://wanderi
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 varchar
9 matches
Mail list logo