On Sun, May 24, 2009 at 02:28:36PM +0200, Lukas Haase wrote:
>
> SELECT topic_fulltext.topicID
> FROM fulltext
> JOIN topic_fulltext ON topic_fulltext.fulltextID = fulltext.fulltextID
> WHERE (word LIKE 'Word1%') AND (word LIKE 'Word2%');
Obviously this must be empty because a string can't start
On Tue, May 19, 2009 at 02:06:37PM +0200, Jean-Denis Muys wrote:
>
> There exists unique natural numbers q and r such as:
>
> a = b*q+r
> 0 <= r < b
>
> q is defined as the quotient, r is defined as the remainder.
>
> So if the % operator wants to match that math definition, its results should
On Thu, Apr 02, 2009 at 08:20:38PM -0700, Dave Brown wrote:
> Our software often runs into problems when run on USB keys. Specifically,
> calls to sqlite to read/write to the database hang infinitely, or return
Does it work on harddisk?
I can tell RO-access works nicely on Windows XP.
Do you hav
On Fri, Apr 03, 2009 at 12:25:18PM +0200, Sylvain Pointeau wrote:
>
> How do I specify the character "line feed" (\n)
> in my query?
Depends a little on your wrapper (outer) programming language.
A technic that works in most language is to fill a variable with the
code of LF and then use this va
On Wed, Mar 04, 2009 at 09:05:34AM +0100, ZeWaren / Erwan Martin wrote:
>
> A few days ago I had to migrate my project from linux to windows. It is
> using the php sqlite3 extension, to access sqlite3 database files.
Use the "external" version of the PDO-sqlite and use the normal DLL from
the sql
On Wed, Jan 21, 2009 at 01:37:39PM +0100, Emil Obermayr wrote:
> I am not sure what the standard says, but I am used to single columns
> after a natural join. So if table a and b are joined through column c
> the following statement is valid:
>
> select c from a natural join
On Wed, Jan 21, 2009 at 07:40:53AM -0500, Igor Tandetnik wrote:
>
> Can you just write "select a.c from a natural join b;" ?
Of course, but the DB-application is already written and is used by
other DBs also. The application design currently needs the column to be
unique without the need to speci
I am not sure what the standard says, but I am used to single columns
after a natural join. So if table a and b are joined through column c
the following statement is valid:
select c from a natural join b;
But I get "SQL error: ambiguous column name: c"
Can this behaviour be changed? Will it be
Am Samstag, 10. Januar 2009 schrieb silvio grosso:
> The query is:
> select avg(age), avg(durata), sum(età ) from acoda, main, dipendenti
This is "cross join" over all three tables. The result is a "monster table",
consisting of every possible combination of the records of those three
tables. An
Is there a way to use bool-values to make migration from other DB easier?
e.g.
select * from address where local = true
like defining true as a contant that represents a numeric 1?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
Am Donnerstag, 8. Januar 2009 schrieb Kees Nuyt:
> Note: With Apache, the easiest location for sqlite3.dll is
> the .../apache/bin directory. php_pdo will find it there.
> Perhaps the same goes for lighttpd.
It works with sqlite3.dll in die PHP-directory.
Thanks for that information. Everything
Hello list,
I run a Windows XP system and want to "fill" the sqlite-DB through a
ODBC-connection with data from other databases and then use it on a
independant server (lighttp on USB-stick).
The sqlite-version I get as ODBC-driver works nicely.
The sqlite-version I get included in PHP as well.
12 matches
Mail list logo