Re: [sqlite] built in function hex

2007-10-08 Thread Andy Goth
On Mon, 8 Oct 2007 10:03:40 -0700 (PDT), Ken wrote > is there a built in function to display numeric values as > hexidecimal strings? to_hexstr (40) would display 0x28 hex() isn't quite what you want. hex(40) gives 3430, since '4' is 0x34 and '0' is 0x30. Moving on... This is the sort of

Re: [sqlite] 'dump' from the C API

2007-10-08 Thread John Stanton
Does anyone know how to do a database dump from the C API? I'm linking to sqlite3.o (the amalgamated file) and was hoping to open a database and dump the contents to an sql file. I know this can be done from the shell, but as of yet, I can't get the shell running on AIX. What version of AIX

Re: [sqlite] A Question: Use of the sqlite3_exe( ) function?

2007-10-08 Thread John Stanton
Lee Crain wrote: Igor, I have a question. Why is it "highly recommended" to use the function call sequence you iterate in preference to the sqlite3_exe call, since it is implemented using that sequence? Lee Crain The callback method did not turn out to be such a good idea in practice and

Re: [sqlite] many-one relation

2007-10-08 Thread John Stanton
A brute force method would be to store the rowid of the owner row in each of the detail rows. chetana bhargav wrote: Is this a garbage collection situation, where you want a row in B to go away when all referring rows in A are deleted? Yes exactly this is what I wanted :) Sorry for the

RE: [sqlite] 3.5.1 build issues

2007-10-08 Thread Evans, Mark (Tandem)
Thanks Joe > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Monday, October 08, 2007 1:45 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] 3.5.1 build issues > > "make test" already fixed in CVS. > > http://www.sqlite.org/cvstrac/tktview?tn=2689 >

Re: [sqlite] 3.5.1 build issues

2007-10-08 Thread Joe Wilson
"make test" already fixed in CVS. http://www.sqlite.org/cvstrac/tktview?tn=2689 --- "Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > A glitch or two got introduced into the 3.5.1 build for cygwin and > possibly other platforms. Please advise if I did something wrong: > > There are undefined

FW: [sqlite] 3.5.1 build issues

2007-10-08 Thread Evans, Mark (Tandem)
Addendum: There is a new file, src/test_onefile.c, that needs to be added to Makefile.in. -Original Message- From: Evans, Mark (Tandem) Sent: Monday, October 08, 2007 12:23 PM To: sqlite-users@sqlite.org Subject: [sqlite] 3.5.1 build issues A glitch or two got introduced into the 3.5.1

Re: [sqlite] many-one relation

2007-10-08 Thread Trevor Talbot
I wrote: > On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote: > > >> Is this a garbage collection situation, where you want a row in B to go > > >> away when all referring rows in A are deleted? > > > > Yes exactly this is what I wanted :) > Maintaining a reference count in table B may be

Re: [sqlite] many-one relation

2007-10-08 Thread Trevor Talbot
On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote: > >> Is this a garbage collection situation, where you want a row in B to go > >> away when all referring rows in A are deleted? > > Yes exactly this is what I wanted :) Okay. A trigger on table A can accomplish it without any extra

Re: [sqlite] many-one relation

2007-10-08 Thread Kees Nuyt
On Mon, 8 Oct 2007 09:04:53 -0700 (PDT), you wrote: >>> Is this a garbage collection situation, where >>> you want a row in B to go away when all >>> referring rows in A are deleted? > >Yes exactly this is what I wanted :) > >Sorry for the confusing message earlier > >-x- >Chetana This might

[sqlite] built in function hex

2007-10-08 Thread Ken
is there a built in function to display numeric values as hexidecibmal strings? to_hexstr (40)would display 0x28 Thanks, Ken

[sqlite] Re: A Question: Use of the sqlite3_exe( ) function?

2007-10-08 Thread Igor Tandetnik
Lee Crain <[EMAIL PROTECTED]> wrote: Why is it "highly recommended" to use the function call sequence you iterate in preference to the sqlite3_exe call, since it is implemented using that sequence? 1) It's usually easier to write a loop, than to break out the body of the loop into a separate

[sqlite] Re: user defined function

2007-10-08 Thread Igor Tandetnik
Aviad Harell <[EMAIL PROTECTED]> wrote: I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return:

[sqlite] A Question: Use of the sqlite3_exe( ) function?

2007-10-08 Thread Lee Crain
Igor, I have a question. Why is it "highly recommended" to use the function call sequence you iterate in preference to the sqlite3_exe call, since it is implemented using that sequence? Lee Crain _ -Original Message- From: Igor Tandetnik [mailto:[EMAIL

Re: [sqlite] many-one relation

2007-10-08 Thread chetana bhargav
>> Is this a garbage collection situation, where you want a row in B to go away >> when all referring rows in A are deleted? Yes exactly this is what I wanted :) Sorry for the confusing message earlier -x- Chetana - Original Message From: Trevor Talbot <[EMAIL PROTECTED]> To:

Re: [sqlite] many-one relation

2007-10-08 Thread Trevor Talbot
On 10/8/07, chetana bhargav <[EMAIL PROTECTED]> wrote: > We got two tables, tableA & tableB. > > tableB is turning out to be a many-one relation where in we have many rows of > tableA mapping to one row of tableB, would like to know what is the best way > to delete a row in tableB > > 1. Keep a

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Trevor Talbot
On 10/8/07, Markus Wolff - NorthClick <[EMAIL PROTECTED]> wrote: > I find this to be a bit irritating - shouldn't it be enough that the > server can dive into that subdir and find a file it can actually write > to within the dir? How does it make sense that the entire directory > containing the

[sqlite] user defined function

2007-10-08 Thread Aviad Harell
Hey, I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return: customerA productA 100 0 customerA

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Andy Goth
On Mon, 08 Oct 2007 13:12:08 +0200, Markus Wolff - NorthClick wrote > How does it make sense that the entire directory containing the > directory must be writeable? Sounds like a temporary file or lock file is being created. Somebody who knows more about PHP or SQLite can tell you which is

[sqlite] many-one relation

2007-10-08 Thread chetana bhargav
Hi All, We are designing a data base landed in some problems would like to know what approach is the best. We got two tables, tableA & tableB. tableB is turning out to be a many-one relation where in we have many rows of tableA mapping to one row of tableB, would like to know what is the

[sqlite] Re: Null-ifying the columns

2007-10-08 Thread Igor Tandetnik
chetana bhargav wrote: Want to know is there any easy way to make all the columns in a particular row to NULL other than specifying column name and NULL value, no delete as that would change the row-id Well, you could remember the ROWID, then delete the row and insert the new blank one with

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
I have found the problem. PHP was happily reporting that the frontend.db file itself is writeable (which was true all the time), but the directory containing the database was not writeable by the webserver. I find this to be a bit irritating - shouldn't it be enough that the server can dive into

RE: [sqlite] Re: Merge two rows/records

2007-10-08 Thread B V, Phanisekhar
Hi Daan, You can make the columns (a, b) unique across (a, b), but not separately unique; by that whenever you are trying to insert a row with same (a, b) combination it will give an error and at that time you can update the column values c and d. I hope this will solve your problem.

Re: [sqlite] Re: Merge two rows/records

2007-10-08 Thread Simon Davies
Hi Daan, You could try this: sqlite> CREATE TABLE foo(a integer, b integer, c integer, d integer, ...> unique (a, b) on conflict ignore); sqlite> CREATE TRIGGER fooUnique before insert on foo ...> when exists (select a from foo where a=new.a and b=new.b)

[sqlite] CONFIG_FPE_FASTFPE and the text representation of a float

2007-10-08 Thread Frank van Vugt
L.S. Here's the patch for those interested: --- sqlite-3.4.2-orig/src/printf.c 2007-06-28 14:46:19.0 +0200 +++ sqlite-3.4.2/src/printf.c 2007-10-08 11:56:49.0 +0200 @@ -158,7 +158,11 @@ static int et_getdigit(LONGDOUBLE_TYPE *val, int *cnt){ int digit;

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
Am Freitag, den 05.10.2007, 01:03 +0200 schrieb Kees Nuyt: > I can't reproduce the exception (the PDO->query > version) on an environment I happened to have > available. > > - MS Windows XP Professional (5.2 build 2600) > - Apache 2.2.4 > - PHP 5.2.2 > - PDO SQLite 1.0.1 2007/03/23 > - SQLite

Re: [sqlite] Problems with SQLite and PHP

2007-10-08 Thread Markus Wolff - NorthClick
Hi Joe, standard temp directory in my setup is /tmp, which is both readable and writeable by Apache. Available space is 21GB, which should be more than sufficient for the task at hand :-) CU Markus Am Donnerstag, den 04.10.2007, 16:13 -0700 schrieb Joe Wilson: > See if the apache/mod_php

Re: [sqlite] Merge two rows/records

2007-10-08 Thread Simon Davies
On 08/10/2007, Daan van der Sanden <[EMAIL PROTECTED]> wrote: > Hi, > > Is it possible to merge two rows with SQLite? Say I have the following table": > CREATE TABLE foo(a integer, b integer, c integer, d integer); > CREATE INDEX idx ON foo(a,b); > > With the following data: > > INSERT INTO foo

[sqlite] Merge two rows/records

2007-10-08 Thread Daan van der Sanden
Hi, Is it possible to merge two rows with SQLite? Say I have the following table": CREATE TABLE foo(a integer, b integer, c integer, d integer); CREATE INDEX idx ON foo(a,b); With the following data: INSERT INTO foo VALUES (1,1,1,2); INSERT INTO foo VALUES (1,2,3,4); INSERT INTO foo VALUES