Is there an easy way to have an "alternating" column value in a query,
using sqlite ?
I want to have a column that alternates its value on every row. The
application is web based. I want to alternate colors for each row in
a table.. Something row1 = gray background, row2 = white, row3=grey,
ro
Ignore the previous answer to your post; it's not right.
First, let's call things by their right names; '\' is a
backslash.
Second, the lines in your post that look sort of like the
transcript of a tcl session can't be real, or at least
can't be complete; so I'm going to have to make some
guesses
SQLite Database Browser is a freeware, public domain, open source visual
tool used to create, design and edit database files compatible with
SQLite 2.x. It is hosted at sourceforge, and the home page for the
project lives at
http://sqlitebrowser.sourceforge.net/
Source is available of course, a
I'm afraid I still get //
% db eval "insert into t1 values('')"
% //
Quoting Hell it still is...
-Shamil D.
"Lawrence Chitty"
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 20, 2004 10:02 PM
Subject: [sqlite] How to handle slashes (\) in text columns
> I'm using the TCL binding of SQLITE and was trying to figure out how to
> enter various characters into a text column
On Tue, 20 Jul 2004 07:21:43 -0500, you wrote:
>>> Is there any way to determine the sqlite version ... ?
>
>Look at the first 47 bytes of the file -- or the first 48
>bytes if you want a null-terminated string.
That works.. Thank you..
Randall Fox
I'm using the TCL binding of SQLITE and was trying to figure out how to
enter various characters into a text column. To enter a slash, all I
normally would do is to append another slash to it. However, this only
works fine if the slash is not the last character in the field. Consider
the followi
[EMAIL PROTECTED] wrote:
The documentation lists END [TRANSACTION] as a legal command, but does not
describe it. I assume that END TRANSACTION is a synonym for ROLLBACK but its
action should probably be described explicitly in the documentation
(especially if this assumption is incorrect).
END [TR
The documentation lists END [TRANSACTION] as a legal command, but does not
describe it. I assume that END TRANSACTION is a synonym for ROLLBACK but its
action should probably be described explicitly in the documentation
(especially if this assumption is incorrect).
Cheers,
Derrell
Hi sqlite-users :)
I have found sqlite as the best solution to all my data storage problems - a
great piece of software!
Im currently working on a specific algorithm to fill in a table of numbers.
Within the range of an index (idx), I have to count the numbers of rows where
(in1==in2) and plac
Hello again,
Can anyone answer these simple questions for
me?
Why is the
SHOW_DATATYPES pragma not mentioned on the SQL syntax page under the PRAGMA
keyword section?
Do I have to execute the pragma per
transaction?
If not, why I am intermittently not getting the data
>> Is there any way to determine the sqlite version ... ?
Look at the first 47 bytes of the file -- or the first 48
bytes if you want a null-terminated string.
On Mon, 19 Jul 2004, gohaku wrote:
Hello everyone,
I am currently using SQLite v2.8.11.
I have not had much experience with SQLite other than executing simple
Queries and Updates.
I don't have any problems with SQLite v2.8.11 and as such,
have not upgraded to v3.0.2
I would like to know if v3.0.2 h
PB in sqlite 3.0.2 when define SQLITE_OMIT_DATETIME_FUNCS
I think sqlite3RegisterDateTimeFunctions should be in date.c
void sqlite3RegisterDateTimeFunctions(sqlite *db){
#ifndef SQLITE_OMIT_DATETIME_FUNCS
static struct {
char *zName;
int nArg;
void (*xFunc)(sqlite3_context*,int,sql
Hello, I am posting the announce here because Kexi uses SQLite as its main
backend, for file-based databases.
16 July 2004
The Kexi Team announced the immediate availability of Kexi 0.1 beta 4,
codenamed "FireDuck", newest preview release of the integrated environment
for managing data aimed at d
On 19 Jul 2004, at 23:56, gohaku wrote:
Does sqlite v3.0.2 include such an interpreter?
No. I use dbish which is from the perl DBI::Shell package (on CPAN). If
you install the right modules it has scrollback, EDITOR support, etc.
Matt.
_
Hi to all.
I'm new to this list and I've read here very interesting discussions about
SQLite as a standard for Free Office suites.
I'm an OpenOffice.org user, and I hope SQLite will be choosen as an embeded
database for OOo.
For now, we are able to use SQLite databases with OOo thanks to the OD
17 matches
Mail list logo