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
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.
_
"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 Tem
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
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 the
"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
> 'sqlite3_bl
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
> ex
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
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]
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 examples.
I have looked on the web, and there are few examples that were of
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
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.
> Thanks,
> JP
- 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. So how to find out what is
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
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 appli
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
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 p
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 PROCEDU
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 delete
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 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: [sql
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
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 h
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 onl
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 cust
"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 logi
> 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
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: [sq
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(
-- 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 t
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(DISTIN
Jason Salas wrote:
> Never mind folks...I got it!
>
> Double-pipes does the trick! "||"
>
> lastName || ', ' || firstName as [name] from myTable
>
>
> Awesome. Admittedly confusing at first glance, but awesome. :-)
This is plain vanilla, standard SQL according to the standard. You will
fi
32 matches
Mail list logo