Re: [sqlite] INSERT question

2010-07-16 Thread Andreas Henningsson
does it overwrite or ignore? > > mtia > Mark > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Andreas Henningsson "Vanligt sun

Re: [sqlite] BLOB Support

2010-06-16 Thread Andreas Henningsson
ndation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > --- > Assertions are politics; backing up assertions with evidence is scie

Re: [sqlite] Select question

2010-05-10 Thread Andreas Henningsson
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Andreas Henningsson "Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite update with joins

2010-05-01 Thread Andreas Henningsson
cant you do something like this? update tTmp set tTmp.fileName = hTmp.fileName from t tTmp inner join h hTmp on t.id = h.id 1 maj 2010 kl. 14.20 skrev wdl...@web.de: > The general problem with this issue is that it is not possible > > to set an alias for the table in an update statement. >

Re: [sqlite] SQLite Wrapper

2010-04-14 Thread Andreas Henningsson
Looked at the source code. It is some parts in C also. I did not know that is was possible to mix java and C. You have using a very rare platform. Why do you use mips? My guess is that you have to build it yourself. /Andreas On Wed, Apr 14, 2010 at 11:16 AM, Andreas Henningsson

Re: [sqlite] SQLite Wrapper

2010-04-14 Thread Andreas Henningsson
> I would like to know a couple of things about the wrapper you used : > > 1. Is that available for mips-linux? > 2. Is it available under public license? > 3. Does it have any performance issues? > > Thanks & Regards, > Sen > > On 4/14/2010 1:52 PM, And

Re: [sqlite] SQLite Wrapper

2010-04-14 Thread Andreas Henningsson
; > Regards, > Sen > * > * > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Andreas Henningsson "Vanligt sunt förnuft är inte särkilt vanligt." -- Vo

Re: [sqlite] Export sqlite database to H2

2010-04-09 Thread Andreas Henningsson
t; Does that have a port on Linux-MIPS platform? > Does it have any licensing issues?(whether open source) > Can it perform better than SQLite? > Or what made you move to H2 from SQLite? > > Regards, > Sen > > On 4/9/2010 5:07 PM, Andreas Henningsson wrote: > > Hi &

[sqlite] Export sqlite database to H2

2010-04-09 Thread Andreas Henningsson
Hi I am about to change database from SQLite to H2 in a project of mine. Is there any tools I can use to do i it? What is the best way to export data from an SQLite database? /Andreas -- Andreas Henningsson "Vanligt sunt förnuft är inte särkilt vanligt." -

[sqlite] SQLite Java Store Files in database

2010-04-04 Thread Andreas Henningsson
Hi I use SQLite in a project of mine. I want to strore files in the database. I tried to do it something like this. See Code section below. I get an error that say it is not implementet. See Message section below. I use this driver Class.forName("org.sqlite.JDBC"); The Jar files name is