I understand now...
Thanks Dan!!!
Dan <[EMAIL PROTECTED]> wrote:
On Apr 8, 2008, at 2:16 AM, Ken wrote:
> Dan,
>
> Doesn't that just return the VFS part ??? I'm looking for the
> sqlite3_io_methods part for the default vfs ( or is this really
> the sqlite3_file )?
Right. Sorry, I didn'
On Apr 8, 2008, at 2:16 AM, Ken wrote:
> Dan,
>
> Doesn't that just return the VFS part ??? I'm looking for the
> sqlite3_io_methods part for the default vfs ( or is this really
> the sqlite3_file )?
Right. Sorry, I didn't read carefully. :)
I don't really see why you will need it unless you
> > On Sat, Apr 5, 2008 at 11:42 PM, Cory Nelson <[EMAIL PROTECTED]> wrote:
> > > Sort order is highly dependent on locale. You can add custom
> > > collations to do this.
> <[EMAIL PROTECTED]> wrote:
> > That was not was I was talking about. I was not talking about Sort Order but
> > about
On 4/7/08, sqlfan <[EMAIL PROTECTED]> wrote:
>
> I guess I fit in the more ambitious category then. I hope my workload will
> increase at any rate.
>
> Anyway I've looked at some tutorials, but I'm a bit daunted.
>
> What do you think about this layout:
>
> [integer booking # (=unique ID)] -
I am developing an application that needs both SQL capability and also
simple Btree functions. I searched the SQLite FAQ for information about
direct access to the Btree level, but was unable to find any help or
examples. I have successfully gained access to the Btree routines after
making minor
An Sqlite database is one file. How about using an encrypted file system.
If you have web access try SSL,
Jay A. Kreibich wrote:
> On Mon, Apr 07, 2008 at 09:34:51AM -0700, Gerald Johnson scratched on the
> wall:
>> Hope I am sending this to the correct group. Sorry if I should be
>> posting t
I guess I fit in the more ambitious category then. I hope my workload will
increase at any rate.
Anyway I've looked at some tutorials, but I'm a bit daunted.
What do you think about this layout:
[integer booking # (=unique ID)] - [integer start date] - [integer end date]
- [text everything el
On Mon, Apr 07, 2008 at 09:34:51AM -0700, Gerald Johnson scratched on the wall:
> Hope I am sending this to the correct group. Sorry if I should be
> posting this to a different one.
>
> I have a CD application that a vendor is suggesting that I use SQLite as
> the db. My concern is security. C
Dan,
Doesn't that just return the VFS part ??? I'm looking for the
sqlite3_io_methods part for the default vfs ( or is this really the
sqlite3_file )?
Thanks,
Ken
Dan <[EMAIL PROTECTED]> wrote:
On Apr 8, 2008, at 2:03 AM, Ken wrote:
> Hi all,
>
> I'm trying to implement a vfs that will dis
On Apr 8, 2008, at 2:03 AM, Ken wrote:
> Hi all,
>
> I'm trying to implement a vfs that will disable journalling.
>
> But i've hit a little stumbling block / learning curve.
>
> In the vfs implementation I need to implement a sqlite3_io_methods
> type. Basically I'd like to get the default sql
Hi all,
I'm trying to implement a vfs that will disable journalling.
But i've hit a little stumbling block / learning curve.
In the vfs implementation I need to implement a sqlite3_io_methods type.
Basically I'd like to get the default sqlite3_io_methods and use those as part
of my code as fo
Dennis Cote wrote:
> You can use the replace() function to strip the newlines from your
> strings. You could replace the newlines with empty strings or with a
> single space. The trick is entering the newlines. You can enter them
> directly in an sql script file.
>
> select replace(some_column
On Apr 7, 2008, at 6:27 PM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> See http://en.wikipedia.org/wiki/Julian_day
>>
>> Note that "Julian" in Julian Day Number and Julian Calendar
>> refer to two different people named Julius. The Julian Day Number
>> Julian is Julius Scaliger, the father
Cory, sorry, I had a bad day.
Keith
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp wrote:
>
> See http://en.wikipedia.org/wiki/Julian_day
>
> Note that "Julian" in Julian Day Number and Julian Calendar
> refer to two different people named Julius. The Julian Day Number
> Julian is Julius Scaliger, the father of the guy who invented
> the julian day number in 15
Dennis Cote wrote:
Chris Pierce wrote:
>>
>> Here's what I'm doing/getting:
>>
>> AIX$ ./sqlite3 test.db
>> SQLite version 3.5.7
>> Enter ".help" for instructions
>> sqlite> create table mytest(first smallint);
>> Unable to open database "mytest": SQL logic error
or
>> missing database
>> AIX$
You can use a key to protect your sqlite database. You can get it from the
home site of sqlite. It is not posted as open source. Your database will be
encrypted and no one will be able to read it with out that KEY. If you use
encryption the speed may reduced according to the size of your Databas
Gerald Johnson <[EMAIL PROTECTED]> wrote:
> I have a CD application that a vendor is suggesting that I use SQLite
> as
> the db. My concern is security. Currently we are using Access which
> is
> password protected, but very slow. I have not found any information
> about having SQLite password p
Gerald Johnson wrote:
>
> I have a CD application that a vendor is suggesting that I use SQLite as
> the db. My concern is security. Currently we are using Access which is
> password protected, but very slow. I have not found any information
> about having SQLite password protected. Is it poss
sqlfan wrote:
> I'm booking five resources, and right now I just use an excel sheet with all
> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
> columns are the five resources. When I book one, I just scroll to the
> appropriate date and change the color of the column for
Hope I am sending this to the correct group. Sorry if I should be
posting this to a different one.
I have a CD application that a vendor is suggesting that I use SQLite as
the db. My concern is security. Currently we are using Access which is
password protected, but very slow. I have not fo
dark0s dark0s <[EMAIL PROTECTED]> wrote:
> Hi all, after writing my program, I typed:
>
> bash-3.1# gcc -lsqlite3 CreaDB.c -o creadb
> CreaDB.c: In function 'main':
> CreaDB.c:35: error: too few arguments to function 'sqlite3_bind_text'
> CreaDB.c:36: error: too few arguments to function 'sqlite3_b
I am worse than a newbie at C, but...
On 4/7/08, dark0s dark0s <[EMAIL PROTECTED]> wrote:
> Hi all, after writing my program, I typed:
>
> bash-3.1# gcc -lsqlite3 CreaDB.c -o creadb
> CreaDB.c: In function 'main':
> CreaDB.c:35: error: too few arguments to function 'sqlite3_bind_text'
> CreaDB
Hi all, after writing my program, I typed:
bash-3.1# gcc -lsqlite3 CreaDB.c -o creadb
CreaDB.c: In function 'main':
CreaDB.c:35: error: too few arguments to function 'sqlite3_bind_text'
CreaDB.c:36: error: too few arguments to function 'sqlite3_bind_text'
CreaDB.c:37: error: too few arguments to f
Fred J. Stephens wrote:
> How can I limit the width of column returned by a query?
> In a bash script I am returning an ID, and a text field from a table.
> The text field can be any length, contain newlines, etc. The problems is
> if a row of results contains a new line, the "grid" of rows and c
Bill wrote:
> Hello all,
> I've searched the list archive and didn't find any mention of this.
> Google has lots of hits, but every board posting with a resolution was
> left as 'resolved' with little explanation. :(
>
> I have clean install of Debian Etch with lighttpd, php5-cgi,
> php-sqlite3,
Chris Pierce wrote:
>
> Here's what I'm doing/getting:
>
> AIX$ ./sqlite3 test.db
> SQLite version 3.5.7
> Enter ".help" for instructions
> sqlite> create table mytest(first smallint);
> Unable to open database "mytest": SQL logic error or
> missing database
> AIX$
>
There is something fishy go
dark0s dark0s wrote:
> bash-3.1# gcc CreaDB.c sqlite3.c -o CreaDb
> gcc: sqlite3.c: No such file or directory
>
> What is the problem? CreaDB is not present
>
You don't have sqlite3.c in the same directory as your source CreaDB.c.
You can download the sqlite3 amalgamation source and use that or
On 4/7/08, sqlfan <[EMAIL PROTECTED]> wrote:
>
> I'm booking five resources, and right now I just use an excel sheet with all
> the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
> columns are the five resources. When I book one, I just scroll to the
> appropriate date an
I'm booking five resources, and right now I just use an excel sheet with all
the dates in the first column (1/1/2000, 2/1/2000 ..., and the next five
columns are the five resources. When I book one, I just scroll to the
appropriate date and change the color of the column for that resource for
all
I would like to contribute in a Dutch translation and will do the
necessary for downloading the repository if this is OK with you.
Yves Maingoy schreef:
> D. Richard Hipp a écrit :
>
>>> Thank you for your answer D. Richard,
>>>
>>> So I continue the translation and I will see fossil for futur
Someone sent a sqlite3_unicode.c file to this mailing list in the last week of
December, 1st week of January which implemented upper/lower and some other
functions. File was released as public domain if I remember correctly and used
data from Unicode 5.1 standard.
As ICU brings a lot of bulk i
32 matches
Mail list logo