Re: [sqlite] a system for arbitrarily tagging rows in a table

On Sun, Jul 26, 2009 at 9:23 PM, Jay A. Kreibich wrote: > On Sat, Jul 25, 2009 at 09:26:16AM -0700, Jim Showalter scratched on the wall: >> You can have the tags in a separate table that has a foreign-key to >> the table with the rows in in you want to tag, > >  That's essentially

Re: [sqlite] Little Help on SQL

On 27/07/2009 12:16 PM, Rick Ratchford wrote: > It's a seasonal map, so every year must overlay onto a 366 day grid. > > The table that contains the data has assigned each day a day number from 1 > to 366. If the year isn't a leap year, then day 60 will simply not be > registered for that year.

Re: [sqlite] a system for arbitrarily tagging rows in a table

On Sat, Jul 25, 2009 at 09:26:16AM -0700, Jim Showalter scratched on the wall: > You can have the tags in a separate table that has a foreign-key to > the table with the rows in in you want to tag, That's essentially what the OP is doing, except they've built a many-to-many relationship

Re: [sqlite] Little Help on SQL

It's a seasonal map, so every year must overlay onto a 366 day grid. The table that contains the data has assigned each day a day number from 1 to 366. If the year isn't a leap year, then day 60 will simply not be registered for that year. Not only will day 60 not appear except every 4 years,

Re: [sqlite] Little Help on SQL

On 27/07/2009 7:40 AM, Rick Ratchford wrote: > I have a TABLE with a column of Day Numbers (1 to 366) called DayNum. > Let's say that you want get a count of each DayNum. > How do I word my statement so that it gives me a count of each DayNum, which > is from 1 to 366? Consider leap years ...

Re: [sqlite] Little Help on SQL

Seems my answer was a simple one after all. I only needed to be aware of GROUP BY. Found it though. GROUP BY DayNum. Works. :-) Rick #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rick Ratchford #>Sent: Sunday,

[sqlite] Little Help on SQL

Hello. I'm not yet there in my study of SQL with Rick's book, so I thought someone might help me with an SQL query I need pretty quick. I have a TABLE with a column of Day Numbers (1 to 366) called DayNum. I already have my SQL to where it will extract a number of complete years from January

Re: [sqlite] .lib file?

Thank A.J. Milan! Forcing VS2008 to compile the amalgamation as C (as opposed to the default C++) took care of everything. I also had the comment-out the #include sqlite3.h header file, and let it use all the 'built-in' stuff (else you get an undefined for the _sqlite3_version extern!) Works

Re: [sqlite] .lib file?

The library created by MinGW's dlltool will be a static archive in ar(1) format. The contained object files might be compatible between ld(1) and Microsoft's linker - I honestly don't know, since I use Qt on the gcc (*nix) and MinGW (Windows) toolchains and have limited experience with recent

[sqlite] .lib file?

Basides the mentioned option of build a .lib file and link it statically against your code, or a dinamic library, there are the option of include the sqlite3.c file in your code without so many problems with the casting of pointers -and some others-. If you are using a C++ project in MS Visual

Re: [sqlite] How to get the actual user-name and password?

Simon: Thanks for your's input. Really it is there, in the last line. I has been blind. A.J. Millan On 26 Jul 2009, at 12:47pm, a...@zator.com wrote: > I can't find the way to accesso to the list and get the forgotten > password. Click on the link at the bottom of every post. Simon.

[sqlite] util.c compilation error in SQLite book

Hi, I got the book, "The definitive guide to SQLite". Wondering if anyone has same issue or know the answer. Following is the error when compiling the example CAPI example code [tjy...@ibm examples]$ ls capi commonfoods.sql perlruby tcl capi_ext foods.db java

Re: [sqlite] How to get the actual user-name and password?

On 26 Jul 2009, at 12:47pm, a...@zator.com wrote: > I can't find the way to accesso to the list and get the forgotten > password. Click on the link at the bottom of every post. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] How to get the actual user-name and password?

I can't find the way to accesso to the list and get the forgotten password. Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Use VDBE in extension

Hey there, I am trying to access the VDBE directly from within a loadable extension. Compiling works, but loading the extension fails with > undefined symbol: sqlite3VdbeCreate My includes look like this: > #include "sqlite3ext.h" > #include "sqliteInt.h" > #include "vdbe.h" Code: > Vdbe *v

[sqlite] sqlite db2 error in symbian

i am writing this query to insert data in symbian but i am getting err1=-311 and sqldb2 error in symbia { TInt err1 =stmt.Prepare(db,_L("INSERT INTO MyContacts(ServerContactID,UserName,FirstName,LastName,Country,IsBlocked,RequestStatus,MarkForDeletion)

Re: [sqlite] Port to C#; Progress report

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Noah Hart wrote: > A progress report because people keep asking ... Unfortunately you don't have the source posted yet so it is hard to see how you approached the conversion. One question I have is if you have the process automated in any way? If