Re: [sqlite] Question on Blobs

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

Re: [sqlite] Question on Blobs

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.

Re: [sqlite] Like operator

"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

[sqlite] Like operator

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

Re: [sqlite] Question on Blobs

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

Re: [sqlite] Question on Blobs

"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 >

Re: [sqlite] Question on Blobs

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 >

Re: [sqlite] IF...THEN constructs

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

Re: [sqlite] IF...THEN constructs

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

- Original Message From: Joanne Pham <[EMAIL PROTECTED]> To: General Discussion of SQLite Database 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.

Re: [sqlite] IF...THEN constructs

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

Re: [sqlite] IF...THEN constructs

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

[sqlite] Two different DLLs linked statically to Sqlite and loaded in the same process

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

Re: [sqlite] IF...THEN constructs

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

[sqlite] Keeping ROWID for INSERT OR REPLACE

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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:

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

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

[sqlite] undefined symbol: sqlite3_prepare_v2

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

Re: [sqlite] Concatenating values from multiple varchar fields

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

Re: [sqlite] IF...THEN constructs

"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

Re: [sqlite] FW: Query to Find number of distinct records

> 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)

Re: [sqlite] FW: Query to Find number of distinct records

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:

Re: [sqlite] FW: Query to Find number of distinct records

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(

[sqlite] FW: Query to Find number of distinct records

-- 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

Re: [sqlite] Query to Find number of distinct records

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