On 9 July 2010 06:18, c...@comcast.net wrote:
Thank you very much Simon.
That worked very slick.
Say, is there a way to put all of the SQLite3 commands I used into a script
and have SQLite3 execute them in the script sequentially?
Yes, several ways:
use .read command (sqlite3
Hello All,
I want to navigate to specific position in table for example I want
row number 210 inspite of nevigating one by one how can get that row.
One way could be create a Index and use where clause to get that But
it's not useful in my case.
I have table which have primary key, and product
Hey guys.
I have a query which is very slow, and was wondering if there was any
advice you guys had on it.
Here are two table definitions:
CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY
AUTOINCREMENT, name TEXT NOT NULL UNIQUE, ranking TEXT, score REAL,
record TEXT);
Would
Select * From Product order by ProductName LIMIT 1 OFFSET 209
help?
-- Igor
Piyush Verma-3 wrote:
Hello All,
I want to navigate to specific position in table for example I want
row number 210 inspite of nevigating one by one how can get that row.
One way could be create a
On Fri, Jul 9, 2010 at 11:08, Ian Hardingham i...@omroth.com wrote:
Hey guys.
I have a query which is very slow, and was wondering if there was any
advice you guys had on it.
Here are two table definitions:
CREATE TABLE IF NOT EXISTS globalRankingTable (id INTEGER PRIMARY KEY
Maybe do you want this!
http://www.sqlite.org/syntaxdiagrams.html#select-stmt
Select * From Product order by ProductName LIMIT 210 OFFSET 210;
- Piyush Verma piyush...@gmail.com escreveu:
Hello All,
I want to navigate to specific position in table for example I want
row number
Piyush Verma piyush...@gmail.com wrote:
I want to navigate to specific position in table for example I want
row number 210 inspite of nevigating one by one how can get that row.
See if this helps:
http://www.sqlite.org/cvstrac/wiki/wiki?p=ScrollingCursor
--
Igor Tandetnik
On Fri, Jul 09, 2010 at 08:12:20AM -0300, Israel Lins Albuquerque scratched on
the wall:
Maybe do you want this!
http://www.sqlite.org/syntaxdiagrams.html#select-stmt
Select * From Product order by ProductName LIMIT 210 OFFSET 210;
Close, but not quite. This will return rows 211
If you had the following tables
Table PEOPLERANKINGS(personid INTEGER PRIMARY KEY, personname TEXT, ranking)
Table FRIENDS(personid1, personid2)
and an index on
PEOPLERANKINGS.ranking
and FRIENDS.personid1,FRIENDS.personid2 is a composite unique primary key
You could get the top 10
HI All ,
I have sqlite db name wdb and wdb-journal file was created by power
failure something , when I do any db operation sqlite always prompt disk
I/O error , but when I delete the wdb-journal ,there is no errors
prompted. I think maybe the wdb-journal file was corrupted , does anyone
have
I have long running test in WAL mode (inserting millions of records in
autocommit mode). In other connection by sqlite3 shell I see these errors:
sqlite select (select count(*) from role_exist)/1000/1000;
12
sqlite select (select count(*) from role_exist)/1000/1000;
Error: file is encrypted or is
Hello,
I’m storing encrypted passwords in the sqlite database. The encryption
algorithm generates “null” character, and therefore the password strings can
have nulls in them.
1. Is this an issue for storing in database ? If strcpy is used anywhere, it
would be a problem
2. I’m using
Kavita Raghunathan wrote:
sprintf(SqlStr, INSERT INTO %s (AttrName, AttrEnum, AttrType,
AttrValue, ReadWrite, Entity_id) VALUES('%s', %d, %d, '%s', %d,
%d);, tbl_name, db[i]-attr_name, db[i]-attr_num, db[i]-attr_type,
db[i]-attr_value, db[i]-attr_src, entity_id);
Don't do that. What if
On Fri, Jul 09, 2010 at 11:24:19AM -0500, Kavita Raghunathan scratched on the
wall:
Hello,
I?m storing encrypted passwords in the sqlite database. The encryption
algorithm generates ?null? character, and therefore the password
strings can have nulls in them.
1. Is this an issue for
On 9 Jul 2010, at 5:29pm, Eric Smith wrote:
I have no specific knowledge on whether sqlite handles null characters
within the variables' values--but if I were a bettin man, I'd bet that
it handles them quite cleanly.
You win. BLOBs can handle any sequences of bytes without problems,
Simon Slavin wrote:
BLOBs can handle any sequences of bytes without problems,
including nulls, ETX, and sequences which be illegal if they were used to
express Unicode characters. You can put anything you like in a BLOB.
I assume, due to the manifest typing semantics of the library,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 09:24 AM, Kavita Raghunathan wrote:
1. Is this an issue for storing in database ? If strcpy is used anywhere,
it would be a problem
SQLite quite happily stores/retrieves null bytes in strings. It is part of
my test suite. If you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 09:30 AM, Jay A. Kreibich wrote:
They can't be stored as text values without some type of encoding
(like base64), but they can be stored as BLOBs.
Nulls can be stored in text values. Behind the scenes SQLite treats strings
and
On 9 Jul 2010, at 5:48pm, Eric Smith wrote:
Simon Slavin wrote:
BLOBs can handle any sequences of bytes without problems,
including nulls, ETX, and sequences which be illegal if they were used to
express Unicode characters. You can put anything you like in a BLOB.
I assume, due to
On Fri, Jul 9, 2010 at 10:48 AM, Eric Smith eas@gmail.com wrote:
Will sqlite3_bind_text work properly if the string contains (internal)
nulls? What if I did something like:
char zText[100];
memset(zText, 0, sizeof(zText));
sqlite3_bind_text(stmt, idx, zText, sizeof(zText),
Simo Slavin wrote:
(according to your earlier post)
I'm not OP. I'm Eric. OP was someone else. In this context, I don't
care about blobs or about the right way of doing anything.
Read the documentation for memset().
I know quite well how memset works. I know character!=byte. These
A few questions that are my application specific that is an embedded
application.
I have two databases, the first one is a fixed size configuration database
where
all writes are UPDATES, and the database does not get that many writes. Does
this mean that because of WAL the database itself
--
View this message in context:
http://old.nabble.com/sqlite-query-with-c-tp29120975p29120975.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
My question came purely from a mild curiosity. I was wondering about
the behavior of sqlite call sqlite3_bind_text when it is passed a range
of BYTES that includes nulls.
See this snipper for documentation:
The third argument is the value to bind to the parameter.
In those routines that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 10:54 AM, Eric Smith wrote:
My question came purely from a mild curiosity. I was wondering about
the behavior of sqlite call sqlite3_bind_text when it is passed a range
of BYTES that includes nulls.
bind_text and bind_blob use the
Hi, I want to compose a query that will use a c++ variable. For example I
have:
int i= 5;
char * query = SELECT * from userInfo WHERE count'i'.
The syntax does not work. How do I do that?
Thanks
--
View this message in context:
Hello,
I try to get an sql query string from 2 const chars.
const char *language;
language = '6';
const char *sql2 = SELECT key,name,text FROM uebersetzungen WHERE sprach_id
= ;
const char *sql = strcpy(sql2,language);
// or
const char *sql = SELECT key,name,text FROM
In testing the latest SQLite snapshot with WAL enabled, it seems that
there's no way to use a database in a read-only location. For
example, let's say I've created a database as root, then closed it
(cleanly):
$ ls -l /flash/alarms.db*
-rw-r--r--1 root root 36864 Jan 1 00:14
On Fri, Jul 9, 2010 at 10:38 AM, Ke Tao kota...@gmail.com wrote:
HI All ,
I have sqlite db name wdb and wdb-journal file was created by power
failure something , when I do any db operation sqlite always prompt disk
I/O error , but when I delete the wdb-journal ,there is no errors
prompted.
On Fri, Jul 9, 2010 at 3:21 PM, Jim Wilcoxson pri...@gmail.com wrote:
On Fri, Jul 9, 2010 at 10:38 AM, Ke Tao kota...@gmail.com wrote:
HI All ,
I have sqlite db name wdb and wdb-journal file was created by power
failure something , when I do any db operation sqlite always prompt disk
I/O
On Sun, Jul 4, 2010 at 7:15 PM, P Kishor punk.k...@gmail.com wrote:
On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu pengyu...@gmail.com wrote:
Hi,
I only find row-wise concatenation by not column-wise.
For example, I have table
x1 y1
x1 y2
x2 y3
x4 y4
I want to have the second column
I'm apologise for the reminder, but I think I have become a victim of
thread takeover.
Would someone please kindly answer my questions ?
Kavita
On 7/9/10 11:41 AM, Kavita Raghunathan kavita.raghunat...@skyfiber.com
wrote:
Thanks. Sounds like I have to use BLOBs which is not what I'm doing
From the point of view of a C question, make your array of characters large
enough to hold the characters you want (and terminating null) before copying
them in.
From the point of view of an SQL: if you want to change the comparison
constant in a where clause, look up bind parameters.
read
and don't use strcpy
here is why
https://buildsecurityin.us-cert.gov/bsi-rules/home/g1/848-BSI.html
On Fri, Jul 9, 2010 at 3:06 PM, rollerueckwaerts
rollerueckwae...@gmx.netwrote:
Hello,
I try to get an sql query string from 2 const chars.
const char *language;
language = '6';
const char
You must be thinking of Java or such -- C doesn't do concatenation that way.
There is a strcat() function but that's an ugly way to do it.
Here's how I'd do it:
int language=6;
int nbytes;
char sql[65535]; // big sql buffer to store whatever we need
nbytes=snprintf(sql,sizeof(sql),SELECT
On Fri, Jul 9, 2010 at 2:48 PM, smengl90
fixed-term.seak.meng...@us.bosch.com wrote:
Hi, I want to compose a query that will use a c++ variable. For example I
have:
int i= 5;
char * query = SELECT * from userInfo WHERE count'i'.
The syntax does not work. How do I do that?
smengl90,
You
smengl90 wrote:
Hi, I want to compose a query that will use a c++ variable. For example I
have:
int i= 5;
char * query = SELECT * from userInfo WHERE count'i'.
The syntax does not work. How do I do that?
I think your primary problem is lack of experience in C++. I
strongly recommend
On Fri, Jul 9, 2010 at 2:35 PM, Peng Yu pengyu...@gmail.com wrote:
On Sun, Jul 4, 2010 at 7:15 PM, P Kishor punk.k...@gmail.com wrote:
On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu pengyu...@gmail.com wrote:
Hi,
I only find row-wise concatenation by not column-wise.
For example, I have table
x1
I really don't mean to be a jerk, but this does seem to be really off
topic for this mailing list. Isn't the concatination of two string a
general C/C++ question rather then a sqlite question? Don't you think
you might be better off asking this question on a C/C++ mailing list
or forum, maybe
Hi,
i think you are asking a C question, and not an sql question.
Is your example C code? If this is the case, you should read up on C basics.
Feel free to contact me directly (also in German)
Martin
Am 09.07.2010 21:06, schrieb rollerueckwaerts:
Hello,
I try to get an sql query string from 2
I strongly recommend that you always make the child side of fork(2)
either exit(2) or exec(2) immediately.
Sorry Nico, I never saw this response -- I appreciate it!
What do you mean, immediately? As I said, my child comes to life,
does some work without touching (its copy of) existing
On Fri, Jul 09, 2010 at 04:52:35PM -0400, Eric Smith wrote:
I strongly recommend that you always make the child side of fork(2)
either exit(2) or exec(2) immediately.
Sorry Nico, I never saw this response -- I appreciate it!
What do you mean, immediately?
Good question. One answer:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 01:52 PM, Eric Smith wrote:
What do you mean, immediately? As I said, my child comes to life,
does some work without touching (its copy of) existing SQLite strucures,
and then calls exit(2).
I'll bet you are actually getting exit(3)
On Fri, Jul 09, 2010 at 02:22:37PM -0700, Roger Binns wrote:
On 07/09/2010 01:52 PM, Eric Smith wrote:
What do you mean, immediately? As I said, my child comes to life,
does some work without touching (its copy of) existing SQLite strucures,
and then calls exit(2).
I'll bet you are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 02:31 PM, Nicolas Williams wrote:
The trick to making that go fast is to use pthread_atfork() to get the
new PID on the child side of fork() and store the PID in a global
variable so that you don't need to call getpid().
That assumes
On Fri, Jul 09, 2010 at 02:38:08PM -0700, Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/09/2010 02:31 PM, Nicolas Williams wrote:
The trick to making that go fast is to use pthread_atfork() to get the
new PID on the child side of fork() and store the PID in a
46 matches
Mail list logo