Thanks, All. I totally missed the nuance between single and double quotes.
Tom
--
Tom Shaw - Chief Engineer, OITC
<[EMAIL PROTECTED]>, http://www.oitc.com/
US Phone Numbers: 321-984-3714, 321-729-6258(fax),
321-258-2475(cell/voice mail,pager)
Text Paging:
Tom Shaw wrote:
Using PHP 5 and SQLite 2.8.14 (This also occurs when commanding SQLite
directly)
I create a table:
CREATE TABLE dnsbl (ip INTEGER PRIMARY KEY, flags VARCHAR(8), ctime
INTEGER, mtime INTEGER, cnt INTEGER, ptr TEXT, refcon INTEGER);
Then I insert a record:
INSERT INTO dnsbl
On Sun, Jul 03, 2005 at 02:59:19PM -0400, Tom Shaw wrote:
> Using PHP 5 and SQLite 2.8.14 (This also occurs when commanding
> SQLite directly)
>
> I create a table:
>
> CREATE TABLE dnsbl (ip INTEGER PRIMARY KEY, flags VARCHAR(8), ctime
> INTEGER, mtime INTEGER, cnt INTEGER, ptr TEXT, refcon
On Jul 3, 2005, at 11:59 AM, Tom Shaw wrote:
Now there should be nothing wrong with the above that I can see BUT
if I change the DB variable name from ip to ip_num all works OK
Strings are quoted with single quotes, not double quotes. Double-
quoted strings are interpreted as column
4 matches
Mail list logo