Hi,
Bharath Booshan L wrote:
Yeah!! I got it right this time.
Select count(*) from ( select DISTINCT Name from TableA);
But what's not getting into my mind is the difference b/w the following two
queries:
Select count( Name) from TableA -- works fine
Select count(DISTINCT Name)
-- Forwarded Message
From: Bharath Booshan L [EMAIL PROTECTED]
Date: Wed, 27 Feb 2008 14:32:14 +0530
To: Eugene Wee [EMAIL PROTECTED]
Conversation: [sqlite] Query to Find number of distinct records
Subject: Re: [sqlite] Query to Find number of distinct records
I was off for lunch
The thing
Hi Bharath,
Works for me in 3.4.2
SQLite version 3.4.2
Enter .help for instructions
sqlite create table tst( nun integer, nm text );
sqlite insert into tst values( 23, 'A' );
sqlite insert into tst values( 23, 'b' );
sqlite insert into tst values( 24, 'C' );
sqlite insert into tst values( 25,
support for count(distinct) has been added in 3.2.6
your version is certainly 3.2.6 (sqlite -version)
Bharath Booshan L wrote:
-- Forwarded Message
From: Bharath Booshan L [EMAIL PROTECTED]
Date: Wed, 27 Feb 2008 14:32:14 +0530
To: Eugene Wee [EMAIL PROTECTED]
Conversation: [sqlite]
support for count(distinct) has been added in 3.2.6
your version is certainly 3.2.6 (sqlite -version)
Your are right. My version is 3.1.3
Thanks a lot for all your inputs folks :-)
--
Bharath
On 2/27/08 4:31 PM, Cyril SCETBON [EMAIL PROTECTED] wrote:
support for count(distinct) has been
Jason Salas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm used to doing lengthy T-SQL programming in SQL Server, so this is
kinda new to me. How does one replicate doing IF...THEN conditional
blocks in SQLite 3?
One typically doesn't. Instead, one implements complex logic in
While '||' is the standard, unfortunately MSSQL uses '+' for string
concatentation so people that are used to using '+' are most likely coming
from MSSQL and thus using '||' does not make for portable SQL (MSSQL does
not support '||', at least not in version 2005).
In my applications I have a
Hi All,
I used the sqlite3_prepare_v2 in my code and some of the servers are ok but
one of my server return an error message that undefined symbol:
sqlite3_prepare_v2 when the process is started and access the database using
sqlite3_prepare_v2 . I don't have any clue why this problem is only
Joanne Pham [EMAIL PROTECTED] wrote:
I used the sqlite3_prepare_v2 in my code and some of the servers
are ok but one of my server return an error message that undefined
symbol: sqlite3_prepare_v2 when the process is started and access
the database using sqlite3_prepare_v2 . I don't have any
On Wed, Feb 27, 2008 at 12:34 PM, Joanne Pham [EMAIL PROTECTED] wrote:
Hi All,
I used the sqlite3_prepare_v2 in my code and some of the servers are ok
but one of my server return an error message that undefined symbol:
sqlite3_prepare_v2 when the process is started and access the
I have been using 3.5.2 sqlite. I forgot the mention this in my previous email.
If you know the answer to this question please help.
Thanks,
JP
- Original Message
From: Joanne Pham [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, February 27, 2008 9:34:05 AM
Subject:
Hi,
I have been using 3.5.2 sqlite. I forgot the mention this in my previous
email.
If you know the answer to this question please help.
sqlite3_prepare_v2 is available in SQLite 3.5.2. There must be some older
version of SQLite somewhere on the single server where your code doesn't work.
I want to insert a row if its key clm doesn't exist otherwise update
it. I can search for the row and then do either an insert or update
accordingly. However I was wondering whether the SQLite Conflict
Resolution: INSERT OR REPLACE would be more efficient (faster). The
problem is the REPLACE
Hi Igor,
Thanks for the insight. I'm used to doing stored procedures for web
apps, which conditionally execute statements based on state and/or the
presence of variables. Consider this construct, which I built recently
to populate a table with URL for a web spider bot I built:
CREATE
Hello,
For some particular reasons, one process loads two different DLLs, each
one linked with a static library of Sqlite. This two DLLs access the
same database. I know that there is no problem if you access to the
database from 2 different processes. But I was wondering if there would
be a
Hi all,
Thx for the response!
On different Linux server. So how to find out what is the SQLite version on the
server which has the problem.
How to find out the sqlite version using Linux commnad.
Thanks,
JP
- Original Message
From: Dimitri [EMAIL PROTECTED]
To: General Discussion of
Jason Salas [EMAIL PROTECTED] wrote:
Thanks for the insight. I'm used to doing stored procedures for web
apps
There is no such thing as a stored procedure in SQLite.
How would I got about re-writing something like this in SQLite?
You wouldn't. You would write the logic in whatever
On Wed, Feb 27, 2008 at 6:00 PM, Jason Salas [EMAIL PROTECTED] wrote:
Hi Igor,
Thanks for the insight. I'm used to doing stored procedures for web
apps, which conditionally execute statements based on state and/or the
presence of variables. Consider this construct, which I built recently
- Original Message
From: Joanne Pham [EMAIL PROTECTED]
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Wednesday, February 27, 2008 3:23:09 PM
Subject: Re: [sqlite] undefined symbol: sqlite3_prepare_v2
Hi all,
Thx for the response!
On different Linux server. So
On Wed, Feb 27, 2008 at 6:23 PM, Joanne Pham [EMAIL PROTECTED] wrote:
Hi all,
Thx for the response!
On different Linux server. So how to find out what is the SQLite version on
the server which has the problem.
How to find out the sqlite version using Linux commnad.
Doing it with a Linux
shoot. worst suspicions affirmed. :-)
although this is for a C# console app, it's still largely client/server
and i designed the back-end as such, to reduce roundtrips to the DB. no
sweat, a little refactoring won't hurt. thanks again!
Igor Tandetnik wrote:
Jason Salas [EMAIL PROTECTED]
nice work!
Stephen Oberholtzer wrote:
On Wed, Feb 27, 2008 at 6:00 PM, Jason Salas [EMAIL PROTECTED] wrote:
Hi Igor,
Thanks for the insight. I'm used to doing stored procedures for web
apps, which conditionally execute statements based on state and/or the
presence of variables.
On Feb 27, 2008, at 4:48 PM, Mike McGonagle wrote:
Hello all,
I was hoping that someone might share some tips on working with
Blobs? I
would like to be able to store some images and sound files in a
database,
but never having dealt with them, I am kind of at a loss for some
Mike McGonagle [EMAIL PROTECTED] wrote
in message
news:[EMAIL PROTECTED]
My impression from what I have seen is that Blobs are dealt with in a
different way than other data types. Am I correct in assuming that
Blobs need to be created explicitly, and then you repeatedly call
Wow, Peter, didn't expect that anyone would go to the trouble of writing a
program on the spot
Just curious, but from those few things that I have seen, it appears that
you can only put a Blob into the DB if it is already on disc, right? All
three examples I have seen passed the filename to
Hi,
I am working in 3.3.6
My table is as follows:
create table MUSIC(id integer primary key,Album text,Artist text);
IdAlbum Artist
1 z
2 w
3 s
4
Mahalakshmi.m
[EMAIL PROTECTED] wrote
in message
news:[EMAIL PROTECTED]
Rowid Id Album
1 4
2 3
3 2
4 1
SELECT rowid,Album FROM Temp WHERE Album like 'c%';
Output: rowed - 2 and Album -
My doubt is for this statement
SELECT rowid , Album FROM Temp WHERE Album
Mike McGonagle wrote:
Hello all,
I was hoping that someone might share some tips on working with Blobs?
I am also curious about this.
For instance, how can I store a file in a table?
Not read the file and store the text, but the binary file itself?
Thanks.
Hi Mike,
The data in this example happens to come from file, but that isn't
relevant. The line:
rc = sqlite3_bind_blob(stmt, 2, data, sb.st_size, SQLITE_STATIC);
is binding a chunk of data on the heap to the blob column and
inserting that into the database. Where this chunk of data comes from
29 matches
Mail list logo