[sqlite] Formatting numbers

2007-09-20 Thread T
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 ) ;

Re: [sqlite] multiple databases

2007-09-20 Thread nadiap
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

Re: [sqlite] DBIException: The name 'bdate' is not a valid index.

2007-09-20 Thread Kees Nuyt
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,

Re: [sqlite] multiple databases

2007-09-20 Thread Kees Nuyt
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

Re: [sqlite] multiple databases

2007-09-20 Thread nadiap
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

Re: [sqlite] Formatting numbers

2007-09-20 Thread Kees Nuyt
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(

Re: [sqlite] SQLite.Net

2007-09-20 Thread Yves Goergen
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

RE: [sqlite] SQLite.Net

2007-09-20 Thread Samuel R. Neff
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

RE: [sqlite] Moving database connections across threads

2007-09-20 Thread Mark Brown
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(),

Re: [sqlite] SQLite.Net

2007-09-20 Thread Yves Goergen
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

[sqlite] SQLite and html character entities

2007-09-20 Thread P Kishor
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

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread P Kishor
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

[sqlite] In-Memory Database - problem with DROP TABLE

2007-09-20 Thread Babu, Lokesh
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

[sqlite] Group by without aggregates

2007-09-20 Thread Prakash Reddy Bande
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

Re: [sqlite] Moving database connections across threads

2007-09-20 Thread John Stanton
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

[sqlite] Re: Group by without aggregates

2007-09-20 Thread Igor Tandetnik
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

Re: [sqlite] Group by without aggregates

2007-09-20 Thread Joe Wilson
> 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,

RE: [sqlite] SQLite.Net

2007-09-20 Thread Samuel R. Neff
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

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread Clark Christensen
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

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread P Kishor
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

[sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
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

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread drh
"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

[sqlite] Re: sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Igor Tandetnik
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

[sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
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

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread RaghavendraK 70574
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

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread drh
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

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
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"

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread Clark Christensen
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

Re: [sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread Kees Nuyt
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

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Kees Nuyt
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[_]

Re: [sqlite] sqlite3_open_v2 and SQLITE_OPEN_READONLY

2007-09-20 Thread Liam Healy
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

Re: [sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread Kees Nuyt
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

Re: [sqlite] Precompiled 2.x for Windows?

2007-09-20 Thread epankoke
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

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread Trevor Talbot
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

Re: [sqlite] Multi-User confusion

2007-09-20 Thread Zbigniew Baniewski
Yes, found it: no support for that in 3.3.8. :( Must compile newer version. -- pozdrawiam / regards Zbigniew Baniewski - To unsubscribe,

[sqlite] dates and times in sqlite

2007-09-20 Thread Mark Wyszomierski
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

Re: [sqlite] SQLite and html character entities

2007-09-20 Thread P Kishor
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> > > -

[sqlite] Re: dates and times in sqlite

2007-09-20 Thread Igor Tandetnik
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

Re: [sqlite] Re: dates and times in sqlite

2007-09-20 Thread Mark Wyszomierski
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

Re: [sqlite] dates and times in sqlite

2007-09-20 Thread John Stanton
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

[sqlite] Inserting Problem : More number of records at a single stretch

2007-09-20 Thread Sreedhar.a
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

[sqlite] Insertion and Search at a same time is it possible?

2007-09-20 Thread Sreedhar.a
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