Re: [sqlite] [Query] Sqlite

2012-11-01 Thread Brian Curley
What's your question on SQLite? (The sqlite-users@sqlite.org address is fairly straightforward. It's sort of like a forum style of help, where you ask your question via e-mail and 90-95% of the answers come from roughly 10 seemingly never-sleeping experts from around the English-speaking world.

Re: [sqlite] Export Blob data from sqlite database to html

2011-11-17 Thread Brian Curley
I'd agree with the SQLite Expert option (Windows)...it ships, or at least used to ship with sample data that presents a scenario like you're describing (ie, jpeg and text as BLOB), plus it allows visual assists, such as BLOB masking over a certain size of data in a column. Otherwise, you'd need

Re: [sqlite] Using dot commands with the command line binary

2011-08-16 Thread Brian Curley
Use of a heredoc to simulate a session...or staging it all into a file for use via .read are good too. On Aug 16, 2011 6:55 AM, Ryan Henrie r...@henrie.org wrote: I finally figured out how to load multiple dot commands or settings from the command line tool. (Some users only have the default

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. On Aug 10, 2011 12:18 PM, Kit kit.sa...@gmail.com wrote: 2011/8/10 Simon Slavin slav...@bigfraud.org: I've never tried using this before for some reason but

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
logic by piping sqlite output into use. It's much better than some on this forum give it credit. But as mentioned elsewhere: you've got the recompile option too... On Aug 10, 2011 12:58 PM, Kit kit.sa...@gmail.com wrote: 2011/8/10 Brian Curley bpcur...@gmail.com: Depending on your preferred shell

Re: [sqlite] Shell doesn't do TABLE/TABLE

2011-08-10 Thread Brian Curley
Brian Curley bpcur...@gmail.com: Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. It is not entirely primitive. It needs only tags in lowercase. cite href=http://www.sqlite.org/sqlite.html; The last output

[sqlite] Trigger mask entities...

2010-10-01 Thread Brian Curley
Looking for some guidance or enlightenment on the available fields within a given trigger. In reading through the code as a non-C kind of guy, it looks like there's an array of columnar values lumped together as old.* and new.* would need them, but nothing that contains the individual field or