[sqlite] is updating Blobs different than inserting??

2008-03-19 Thread C S
hi all. wondering if there is any difference in updating blobs vs inserting? for instance if you have a small blob and when you update the blob increases in size and also going from larger to smaller. is there anything special that i need to check for or do to make sure i dont lose any data?

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
hey i wanted to thank Igor, Ron, Dennis and Matthew (sorry if i forgot anyone else) with helping me with this blob stuff. -cheers c.s. --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > C S <[EMAIL PROTECTED]> wrote: > > -so it seems that despite my byte order being > wron

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
ngineer III, Tyco > Electronics, 434.455.6453 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of C S > Sent: Wednesday, March 12, 2008 12:07 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQL Blobs - what a

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
n or why i should change the order? would like your response -- thanks! oh yeah - i am running on a Linux Ubuntu machine. the only big endian machines now a days that i can think of are old SGI's(didnt they switch to intel) and old mac's(which now use intel(little endian)). *

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
replying to my own message - update should my myString2 - that is not an actual error, just copied and pasted it wrong. also i noticed a problem with i in my final for loop. i changed it to j since i was being incremented. i still get the same output however. just to clarify. --- C S <[EM

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
cessfully, yes!) but it never increments after that. the statement is also finalized successfully. any reason why the other two blobs are not printing out? as a side note i commented out the deleting of the image because i got a major abort crash, no doubt memory leaks/forbidden access issu

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
ies; i++) { numBytes = sqlite3_column_bytes(statement, i); sqlite3_column_blob(statement, i); } --what do you think? thanks all for the help. its appreciated. --- Dennis Cote <[EMAIL PROTECTED]> wrote: > C S wrote: > > > > i get nothing. i have a printout statement

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
or there is nothing there at all. any suggestions? --- C S <[EMAIL PROTECTED]> wrote: > Dennis mentioned before that it was not necessary to > do a bind on something that was defined as an > integer > primary key. > > when i do: > > select * from Images; >

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
..and it "seems" to make no difference. if i am supposed to bind the imageID what would that bind look like? which bind statement am i looking for? thanks!! --- "Matthew L. Creech" <[EMAIL PROTECTED]> wrote: > On Wed, Mar 12, 2008 at 9:37 AM, C S > <[EMAIL PROTECTED]&

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

2008-03-12 Thread C S
urned to the prompt. is there anything that i missed? thanks again!!! --- Dennis Cote <[EMAIL PROTECTED]> wrote: > C S wrote: > > hi all - i am trying once again to insert an > image(an > > array of shorts) into a blob. > > > > i created a table that is descri

Re: [sqlite] using SQLite for binding blobs.

2008-02-15 Thread C S
Tandetnik <[EMAIL PROTECTED]> wrote: > "C S" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > insert << "insert into Images values(NULL, '" << > Hello > > World << "')" > > As predicted, you don't ha

Re: [sqlite] using SQLite for binding blobs.

2008-02-15 Thread C S
> > Why not create a table that has the integer value > and insert the data? One row per array element > > HTH > > C S <[EMAIL PROTECTED]> wrote: hi all i have a > question regarding Blobs, that is > storing images into the database. > > my imag

Re: [sqlite] using SQLite for binding blobs.

2008-02-15 Thread C S
to anything here for the blob? i might have to come back to understand more about the casting but right now i just wanted to show you my code. i hope it is readable and once again thanks for your help in advance! --- Fin Springs <[EMAIL PROTECTED]> wrote: > > On Feb 15, 2008, at

[sqlite] using SQLite for binding blobs.

2008-02-15 Thread C S
hi all i have a question regarding Blobs, that is storing images into the database. my image by default is an unsigned short array and to bind blobs it wants a byte array. i am not sure i am doing this right at all. is there a universal cross platform way for this easy conversion? so far the