Re: [sqlite] Newbie question: sqlite.exe command usage?

2004-11-18 Thread yesso
 hello :)

 how can i store an image as a blob in sqlite about the java wrapper
 classes?

 thX
 yesso



Re[2]: [sqlite] sqlite.so for php 4

2004-11-08 Thread yesso
Hallo ,

  how can i put an image from my harddisk (C:\bild.jpg) in my sqlite
  database? i am using java-wrapper klasses...

  which sql-statement can i use?

-- 
mfG,
 yessomailto:[EMAIL PROTECTED]



Re: [sqlite] sqlite.so for php 4

2004-11-08 Thread yesso
Hallo ,

  how can i put an image from my harddisk (C:\bild.jpg) in my sqlite
  database?

  which sql-statement can i use?

-- 
mfG,
 yessomailto:[EMAIL PROTECTED]



[sqlite] question

2004-10-14 Thread yesso

can anyone answer the following question:

is that feasible to write a c#-webservice on a windows xp mashine and
bring it to run on linux mashine (with server like apache)?? and how
do i nees for them?

thx
yesso



Re[2]: [sqlite] Version 3.0.8

2004-10-14 Thread yesso
Hallo sqlite,

   can someone help me with ado.net + sqlite?

   i am newbie with ado.net:

   how can i load my database (name is "database.db") in an dataset and
   can load it into an datagrid to show it there?

   thX :)

-- 
mfG,
 yessomailto:[EMAIL PROTECTED]
Thursday, October 14, 2004, 1:33:01 PM, du hattest geschrieben:

JA> Does this version support the verious BEGIN TRANSACTION types?

JA> Thank you,
JA> Jakub

JA> D. Richard Hipp wrote:
>> Version 3.0.8 is now available on the website.  http://www.sqlite.org/.
>> 
>> The primary change is a series of code size optimizations.
>> There are also some obscure bug fixes and a few minor enhancments.
>> If you are not having problems with version 3.0.7 there is little
>> reason to upgrade.




Re: [sqlite] [ANN] 1st pre-alpha release of the SQLite OLE/DB provider

2004-09-11 Thread yesso
Hallo Nuno,

Saturday, September 11, 2004, 5:05:31 AM, du hattest geschrieben:

NL> Hi all.

NL> I just finished a first version of the SQLite OLE/DB provider.
NL> It only implements the basic ADO functionality (execute SQL command and
NL> Recordset view).

NL> I make it available for all (free of charge, with no limitations), so I
NL> can get feedback on the OLE/DB functionality people want most.

NL> You can get it at: http://xpto.ath.cx/sqlite
NL> It includes a sqlite3.dll, so you can change to a more recent sqlite
NL> version without problems.

NL> You need to register it using "regsvr32.exe sqliteoledb.dll"

NL> A basic ADO usage case (in javascript, as I don't know/remember VB), is
NL> attached (and can be found at the directory).

NL> Let me know what it doesn't work in your case, so I know what I need to
NL> implement next (and any bugs, off course ;)

NL> You can contact me at: [EMAIL PROTECTED] or [EMAIL PROTECTED]

NL> Best regards,
NL> ~Nuno Lucas





hi, can i use this provider in a c# project?

-- 
mfG,
 yessomailto:[EMAIL PROTECTED]



[sqlite] typeless / bug or feature??

2004-08-11 Thread yesso
hi,

sqlite is typeless. OK!

but how can i save dates in sqlite because i need dates in my
query...??

for example i have many rows with each one date (everdy needs a row) from the
beginning of the year 2002 until 2004 and i will start a query where i will get all 
rows
from july of the year 2002 until 2004.

how can i realise that, i think its not a good idea to save dates in
this format 20041030 (it means the year 2004, month 10 and 30th day)
to solve my problem---

thx
yesso



[sqlite] sqlite date?

2004-08-06 Thread yesso
hi,

can i use date type in sqlite or i must save as varchar?

thx
yesso