Re: [sqlite] CROSS keyword disables certain join optimizations

2005-09-12 Thread Cam Crews
> People who visit a website that looks like junk _NEVER_ say "oh my web > browser is being a piece of shit." ...unless they're the same people who designed it ;)

Re: [sqlite] SUM and NULL values

2005-09-09 Thread Cam Crews
> I heard someone say that SUM is a binary operation. It is not, because you > can feed it any number of values. It is not the same as "+". While I don't believe anyone has claimed SUM represents a binary operation, the function's behavior has been contrasted to the binary '+' operator. Certainly

Re: [sqlite] 2.8.16

2005-09-08 Thread Cam Crews
qlite-2.8.16.tar.gz gunzip sqlite-2.8.16.tar.gz tar -xvf sqlite-2.8.16.tar cd sqlite-2.8.16 su -- now what happens when you configure/install from here? On 9/8/05, Richard Nagle <[EMAIL PROTECTED]> wrote: > > On September 08 2005, Cam Crews <[EMA

Re: [sqlite] 2.8.16

2005-09-08 Thread Cam Crews
> So, its something with the C compiler... Well, you can test your compiler pretty easily.. Are you able to compile anything else? At minimum, try compiling hello world first: create a file test.c : --- #include int main( ) { printf("oh my, 1 step closer to using

Re: [sqlite] v3 number handling and relational design help...

2005-09-07 Thread Cam Crews
> > I'd like to create another table with > > "AverageSalaries" combining the ID's from (a) and (b) > > into a unique 8 byte ID. I'm thinking that the > > columns would be "SuperID" (8 bytes integer created by > > combining each ID from the city table with the ID from > > each job table and "AveSa

[sqlite] C++ API: Retrieve multiple rows into struct, using callback

2005-08-26 Thread Cam Crews
Hi. I'm new to sqlite and would like to use the sqlite C++ API to return multiple rows from a SELECT statement. I'm able to load a single row's result into a struct & pass it back by reference through the callback, but haven't been able to find any resources recommending a method for returning *m