RE: [sqlite] FW: BLOB data retrieval

2007-06-28 Thread Krishnamoorthy, Priya (IE10)
: Jonas Sandman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:41 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: BLOB data retrieval Still would be nice to know why you feel like stepping through the whole lot to count rows? On 6/28/07, Krishnamoorthy, Priya (IE10) <[EM

Re: [sqlite] FW: BLOB data retrieval

2007-06-28 Thread Trevor Talbot
On 6/27/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]> wrote: I am writing a program (in MS VC++) which has to read the blob data in all the rows of the above mentioned table one after another. I am using cppSQLite3 which is C++ wrapper function for accessing sqlite3 db. Mine is an

Re: [sqlite] FW: BLOB data retrieval

2007-06-28 Thread Jonas Sandman
essage- From: Trevor Talbot [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:35 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: BLOB data retrieval On 6/27/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]> wrote: > I am writing a program (in MS VC++) which has to rea

RE: [sqlite] FW: BLOB data retrieval

2007-06-28 Thread Krishnamoorthy, Priya (IE10)
Thanks all for the help. I fixed the problem by stepping through one row after another. Thanks a lot. Priya -Original Message- From: Trevor Talbot [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:35 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: BLOB data retrieval

Re: [sqlite] FW: BLOB data retrieval

2007-06-28 Thread Jonas Sandman
You need to know the number of rows, don't you already have that in b.numRows() ? /Jonas On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: On 6/27/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]> wrote: > for (int i=1;i <= b.numRows() ; i++) >

Re: [sqlite] FW: BLOB data retrieval

2007-06-27 Thread Trevor Talbot
On 6/27/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]> wrote: for (int i=1;i <= b.numRows() ; i++) sql_command.format("select Data from %s where Row_Num = %d;",table_name,i); q = db.execQuery(sql_command); if (!q.eof()) This method

Re: [sqlite] FW: BLOB data retrieval

2007-06-27 Thread RaghavendraK 70574
it! * - Original Message - From: "Krishnamoorthy, Priya (IE10)" <[EMAIL PROTECTED]> Date: Thursday, June 28, 2007 1:21 pm Subject: [sqlite] FW: BLOB data retrieval > Hi, > > > > I have a database which has a table that cont

Re: [sqlite] FW: BLOB data retrieval

2007-06-27 Thread John Stanton
Krishnamoorthy, Priya (IE10) wrote: Hi, I have a database which has a table that contains BLOB data. The table has two columns - one is "Row_Num" which is of type AUTO_INCREMENT (INTERGER_PRIMARY_KEY) and the other column "Data" contains BLOB data. I am writing a program (in MS VC++)

[sqlite] FW: BLOB data retrieval

2007-06-27 Thread Krishnamoorthy, Priya (IE10)
Hi, I have a database which has a table that contains BLOB data. The table has two columns - one is "Row_Num" which is of type AUTO_INCREMENT (INTERGER_PRIMARY_KEY) and the other column "Data" contains BLOB data. I am writing a program (in MS VC++) which has to read the blob data in all