Re: [sqlite] how would you allow users to re-order rows arbitrarily?

2007-01-07 Thread Nicolas Williams
On Sat, Jan 06, 2007 at 09:53:39PM -0800, Sean Payne wrote: > Suppose gui-users wanted to drag and drop rows in a table so that > they could shuffle it anyway that they wanted so that the rows > maintained that order the next time they accessed the table. Can > this be done without updating

Re: [sqlite] Error during compilation of sqlite-3.3.8

2007-01-07 Thread Martin Jenkins
Dori Meshulam wrote: Martin, I still get the error. Is it possible that my tclConfig.sh file is not well configured? Does it match the directory structure on your system? That is, do the directories in the script exist on your disk and do they contain the "right" sort of files? Martin --

[sqlite] strange %W behavior

2007-01-07 Thread Will Leshner
In the current release of SQLite (3.3.9) I find that if I execute the following query multiple times in succession I get different values for %W: SELECT strftime('%Y-%W', 'now'); Sometimes the value is '2007-02' and other times the value is '2007-01'. If this sounds like a bug, I'll file a bug r

Re: [sqlite] strange %W behavior

2007-01-07 Thread Joe Wilson
--- Will Leshner <[EMAIL PROTECTED]> wrote: > In the current release of SQLite (3.3.9) I find that if I execute the > following query multiple times in succession I get different values > for %W: > > SELECT strftime('%Y-%W', 'now'); > > Sometimes the value is '2007-02' and other times the value i

Re: [sqlite] strange %W behavior

2007-01-07 Thread Will Leshner
On 1/7/07, Joe Wilson <[EMAIL PROTECTED]> wrote: This problem appears to be pretty old: Interesting. I went ahead and filed a bug report. Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] strange %W behavior

2007-01-07 Thread Martin Jenkins
Joe Wilson wrote: This problem appears to be pretty old: Shows up in 2.8.17 too. Martin - To unsubscribe, send email to [EMAIL PROTECTED] -