Hi Everyone,
I am implementing server database using sqlite.
I will be having the multiple clients browsing the database.
At the same time the database can also be updated.
I can copy the database into the local memory of my system and can perform
search.
Can i implement inserting the
Hi,
I am working in Sqlite 3.3.6
I want to insert more records[like 20,000.] at a single stretch.
I did the following in shell.c,
Static void process_input (struct callback_data *p)
{
char *zLine;
int nLine;
nLine = 200;
zLine = malloc( nLine );
Strcpy
First make sure that you store the date in Julian format by using the
julianday function. Then you should be able to get the day of the week
by take modulo 7 of the julian date. You can use the strftime function
to do that -
**strftime( FORMAT, TIMESTRING, MOD, MOD, ...)
**
** Return a
Oh I forgot to put quotes around the result, thanks Igor,
Mark
On 9/20/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Mark Wyszomierski <[EMAIL PROTECTED]>
> wrote:
> > I've made a text field called "timestamp" which has dates in the form:
> >
> >-MM-DD HH:MM:SS
> >
> > I want to test
Mark Wyszomierski <[EMAIL PROTECTED]>
wrote:
I've made a text field called "timestamp" which has dates in the form:
-MM-DD HH:MM:SS
I want to test if the day portion is a Tuesday for example -
something like:
SELECT * FROM my_table WHERE DAY(timestamp) = TUESDAY
select * from
Hi,
I've made a text field called "timestamp" which has dates in the form:
-MM-DD HH:MM:SS
I want to test if the day portion is a Tuesday for example - something like:
SELECT * FROM my_table WHERE DAY(timestamp) = TUESDAY
is something like that at all possible? I've looked at the
On 9/20/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
>
> > sqlite> select * from tbl;
> > the first record
> > é ç ñ î
> > more from 3rd row
> > row four
> > these "volunteered" activities
> > <á ø ã ü î & others>
> > -
Yes, found it: no support for that in 3.3.8. :( Must compile newer version.
--
pozdrawiam / regards
Zbigniew Baniewski
-
To unsubscribe,
On 9/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
> sqlite> select * from tbl;
> the first record
> é ç ñ î
> more from 3rd row
> row four
> these "volunteered" activities
> <á ø ã ü î & others>
> -
> sqlite> .mode csv
> sqlite> .output foo.csv
> sqlite> select * from
Actually, it compiled, but it appears that I was not successful. The compile I
made did not work for what I wanted. However, the DLL at the link you provided
for me did work, so thanks for pointing that out.
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
On Thu, 20 Sep 2007 20:42:30 +, you wrote:
> Where? sqlite-2_8_17.zip is just an executable,
> and the other zip for Windows is just the source.
> As it stands, however, I was able to recompile
> the DLL after all and it didn't make a difference.
Oh, sorry, I should have checked.
The link
No, I meant like in http://sqlite.org/capi3ref.html#sqlite3_open,
adding a small logo or box "new in 3.5.0" adjacent to the description
of _v2. Then it is clear what version(s) support the feature.
On 9/20/07, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
> On Thu, 20 Sep 2007 13:57:58 -0400, Liam
On Thu, 20 Sep 2007 13:57:58 -0400, Liam wrote:
> It would be nice if the documentation gave a
> brief indication when a feature is added
> ("new in 3.5.0" unobtrusively somewhere).
Like in http://www.sqlite.org/34to35.html ?
--
( Kees Nuyt
)
c[_]
On Thu, 20 Sep 2007 17:09:27 +, you wrote:
> Would anyone happen to have a precompiled DLL
> for Windows of the latest 2.x version of SQLite?
> I don't have the facilities to make one myself
> where I'm at right now, but I need one to test
> out a problem with an application I'm trying
> to
It's a nightmare. I can think of some ugly client-side scripting things to
investigate, but I think you'd be on the way down a bunny hole :-))
If you submit the data, and do nothing but print it back to the browser, does
it display correctly?
If you submit, store, retrieve and send it back to
OK thanks, I'll upgrade when it hits Debian unstable which I expect
will be fairly soon. It would be nice if the documentation gave a
brief indication when a feature is added ("new in 3.5.0" unobtrusively
somewhere).
Liam
On 9/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Liam Healy"
RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is the performance same,better or
>
Perhaps a little better for some special cases.
Otherwise about the same.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To
Hi,
Is the performance same,better or
regards
ragha
**
This email and its attachments contain confidential information from HUAWEI,
which is intended only for the person or entity whose address is
Liam Healy
wrote:
I tried to use sqlite3_open_v2 and SQLITE_OPEN_READONLY as described
in http://sqlite.org/capi3ref.html#sqlite3_open, but the symbol
SQLITE_OPEN_READONLY is unknown, even though I have included
sqlite3.h. I am using version 3.4.2.
sqlite3_open_v2 is new in 3.5.0. See
"Liam Healy" <[EMAIL PROTECTED]> wrote:
> I tried to use sqlite3_open_v2 and SQLITE_OPEN_READONLY as described in
> http://sqlite.org/capi3ref.html#sqlite3_open, but the symbol
> SQLITE_OPEN_READONLY is unknown, even though I have included
> sqlite3.h. I am using version 3.4.2. Was this symbol
Would anyone happen to have a precompiled DLL for Windows of the latest 2.x
version of SQLite? I don't have the facilities to make one myself where I'm at
right now, but I need one to test out a problem with an application I'm trying
to support. Thank you to anyone who might be able to
I tried to use sqlite3_open_v2 and SQLITE_OPEN_READONLY as described in
http://sqlite.org/capi3ref.html#sqlite3_open, but the symbol
SQLITE_OPEN_READONLY is unknown, even though I have included
sqlite3.h. I am using version 3.4.2. Was this symbol not added until
a later version, or am I supposed
On 9/20/07, Clark Christensen <[EMAIL PROTECTED]> wrote:
> The META tag you include looks correct to me.
>
> Does perl get the chars right after CGI decodes them?
This is what I am not completely sure of.
>
> The browser, ultimately, will escape the accented characters into urlencoded
> chars
The META tag you include looks correct to me.
Does perl get the chars right after CGI decodes them?
The browser, ultimately, will escape the accented characters into urlencoded
chars based on the utf-8 charset you specify in the HTML META tag. Then Perl
(via CGI) is going to decode those
Funny, the first "bug" you pointed out is a question I asked which was
answered same day and was a report of an inconsistency with how
System.Data.SQLite tries to map strong typing on top of SQLite. Certainly
wouldn't call it big issue and I worked around it in just as much time as it
took to
> How does SQLite choose which row to return from a group?
http://www.mail-archive.com/sqlite-users@sqlite.org/msg17778.html
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
Prakash Reddy Bande
wrote:
select SMD_cid, uname, version from users group by version;
SMD_cid|uname|version
66c6263d-e792-f94e-8f57-fd49c2e7b6a6|auser|0
b0b520e9-54b3-224d-8183-09ef08501451|auser|1
I was excepting an error saying columns SMD_cid and uname are not
aggregate. But the query
By making THREADSAFE=0 you have not affected the locking, just other
threadsafe capabilities. If you are launching multiple threads I would
make THREADSAFE=1 so that you can be certain that thread safe versions
of library routines are used.
As I see it Sqlite works around POSIX thread
Hi,
I have the following table:
CREATE TABLE users (SMD_cid varchar(50), uname varchar(50), version
integer);
select SMD_cid, uname, version from users;
2a946e78-0659-4746-aab7-6486ae9a26d3|auser|1
b0b520e9-54b3-224d-8183-09ef08501451|auser|1
Dear All,
I have a piece of code which is shown below, Im doing In-Memory database
operation
I have done these settings in SQLite, in btree.h SQLITE_DEFAULT_AUTOVACUUM =
1, TEMP_STORE=2 in sqliteint.h (this should be made compulsory, if
concentrating only on in-memorydatabase, where no disk is
Thanks Nuno. Since I am raw in this matter, could I ask you for a
little more hand-holding as specified below --
On 9/20/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> You have to know the encoding of the user input. To do that, all your
> html forms _MUST_ have proper tags, and as you will be
On 20.09.2007 15:06 CE(S)T, Samuel R. Neff wrote:
> can you be more specific? Thread links..
http://sqlite.phxsoftware.com/forums/t/731.aspx
"SQLiteDataReader.GetValue() not returning DateTime"
http://sqlite.phxsoftware.com/forums/t/795.aspx
"Cannot retrieve data from a column; inconsistent
Thanks, John, for your reply. We also had the same idea about wanting to
avoid the SQLITE_BUSY possibilities, and just have callers wait.
So, I think if I understand your response correctly, by having THREADSAFE=0
we have effectively commented out any code that would be trying to use
fcntrl(),
Folks,
I come to ask you a question that may be basic for many of you but is
leaving me completely bewildered. My work environment is a Mac OS X
(Tiger) computer, and I use a Cocoa-based text editor, and am writing
a Perl-based web app. Data are in several different languages,
predominantly
Reports of two bugs would not have any bearing on my assertion of the
quality of SQLite.Data.NET, but can you be more specific? Thread links..
Sam
---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the
On 19.09.2007 17:54 CE(S)T, Samuel R. Neff wrote:
> However, I do use the one Robert suggested heavily
> and can attest to the fact that it is extremely well written and works
> without errors.
Ehm, wait, I know of two bugs that have been reported in their forum and
were not even replied to for
On Thu, 20 Sep 2007 17:41:54 +1000, you wrote:
>Hi All,
>
>What's the best way to format a number with a fixed
>number of decimal places?
>
>For instance, if I have an Amount that I want to
>format as dollars and cents, I'm currently using:
>
>begin immediate;
>create temporary table Invoice(
Thanky Mr. Kees!
This help a lot. This is the way i was thinking too.
I have lot things to do though, i am still learning the sqlite!
Thank you once again!
--
View this message in context:
http://www.nabble.com/multiple-databases-tf4480719.html#a12794210
Sent from the SQLite mailing list
On Thu, 20 Sep 2007 00:53:01 -0400, you wrote:
>
>Greetings!
>
>I have this db containing this table:
>
>CREATE TABLE LSOpenJobs
>(
> id integer primary key, ProjID integer, subProjID integer, parent,
>children, login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm,
On Thu, 20 Sep 2007 02:03:59 -0700 (PDT), you wrote:
>
>Hello again!
>I was really surprised and relieved to see that so many people replied to my
>question! I really thank you all!
>I would love to come to the conference but i am from Greece.
>I am going to explain in details what i am trying to
Hello again!
I was really surprised and relieved to see that so many people replied to my
question! I really thank you all!
I would love to come to the conference but i am from Greece.
I am going to explain in details what i am trying to do.
I am indeed using the network simulator 2 in order to
Hi All,
What's the best way to format a number with a fixed number of decimal
places?
For instance, if I have an Amount that I want to format as dollars
and cents, I'm currently using:
begin immediate
;
create temporary table Invoice( Amount real )
;
insert into Invoice values( 123.4 )
;
42 matches
Mail list logo
