Re: [sqlite] AD domain, Mac OS X, network homes, and Firefox's sqlite files

On 16 Sep 2011, at 7:20pm, Jim Thomas wrote: > I haven't yet had a chance to test with Apple's built-in. The preference is > to keep ADmitMac due to the ease of configuration, management, and the > support offered. Apple's built-in SMB client has none of these. It's just a client. > I

Re: [sqlite] AD domain, Mac OS X, network homes, and Firefox's sqlite files

Simon, I haven't yet had a chance to test with Apple's built-in. The preference is to keep ADmitMac due to the ease of configuration, management, and the support offered. I *may* be able to test with that this weekend, but do you have a specific reason for suggesting it? Is there a known

Re: [sqlite] AD domain, Mac OS X, network homes, and Firefox's sqlite files

On 16 Sep 2011, at 7:01pm, Jim Thomas wrote: > Mac OS X 10.6.8 > ADmitMac v6.0.1 (Active Directory and CIFS Client) > Network Home folder resides on Windows Server 2008 DC > Firefox v6 Can you use the OS X SMB client rather than ADmitMac ? Simon. ___

[sqlite] AD domain, Mac OS X, network homes, and Firefox's sqlite files

Greetings, I have done my due diligence to the best of my ability, and I believe that the information I've come across indicates a file locking issue on sqlite files if using CIFS/SMB on a Mac to connect to a Windows share. That in itself would not be an issue as I could simply say "That is

Re: [sqlite] Error while using provider to import into SQL Server

The issue you are seeing is detailed here: http://www.mail-archive.com/sqlite-users@sqlite.org/msg62336.html It has already been fixed in the source tree and the fix will be in the next release. -- Joe Mistachkin ___ sqlite-users mailing list

Re: [sqlite] Error while using provider to import into SQL Server

The error is in System.Data.SQLite, as included in my original post. The support link for System.Data.SQLite lists this mailing list! http://system.data.sqlite.org/index.html/doc/trunk/www/support.wiki     Is there another list for System.Data.SQLite issues?     From: Simon Slavin

Re: [sqlite] Error while using provider to import into SQL Server

On 16 Sep 2011, at 5:14pm, Steve Parrish wrote: > TITLE: SQL Server Import and Export Wizard > -- > Cannot get the supported data types from the database connection > "Password=;Data Source=C:\MyDatabase.db3". Why are you posting to this list ? This list is about

[sqlite] Error while using provider to import into SQL Server

TITLE: SQL Server Import and Export Wizard -- Cannot get the supported data types from the database connection "Password=;Data Source=C:\MyDatabase.db3". -- ADDITIONAL INFORMATION: Could not find any resources appropriate for the specified

Re: [sqlite] select where date < 30 days ago

Miklos Koren wrote: > I was finally able to make it work with > > WHERE CAST(time AS int)/100/86400+2440588 < JULIANDAY('now','-30days') It appears your timestamp is in microseconds since 1/1/1970. In this case, it might be a bit more straightforward to write where

Re: [sqlite] select where date < 30 days ago

I was finally able to make it work with WHERE CAST(time AS int)/100/86400+2440588 < JULIANDAY('now','-30days') 2011/9/16 Igor Tandetnik > > Show your data, show the results you get from the statement, and explain > how the observed outcome differs from your

[sqlite] Shapefile 2.0

SQLite, in its 'default' code configuration, contains enough functionality to be a replacement for a shapefile. However, there is one very significant feature that is wasteful to ignore: spatial indexes. In order for the SQLite RTree to be used, it needs accompanying code that understands the

Re: [sqlite] No error on selecting non-grouped column

On 9/14/2011 15:29, Jay A. Kreibich wrote: Most RDBMS systems will throw an error if you don't group or aggregate column references, but SQLite trust you to know what you're doing. Personally I've always found this to be very useful, as I often have queries that lead to great

Re: [sqlite] select where date < 30 days ago

Miklos Koren wrote: > This is probably a basic SQL question, but I could not make it work under > sqlite. How do I select records for which a datetime column is less than > today - 30 days? I tried > > SELECT * FROM ticket WHERE time < DATETIME('now','-30 days'); > > but

[sqlite] select where date < 30 days ago

Hi, This is probably a basic SQL question, but I could not make it work under sqlite. How do I select records for which a datetime column is less than today - 30 days? I tried SELECT * FROM ticket WHERE time < DATETIME('now','-30 days'); but it does not give the intended results. Thanks,

Re: [sqlite] regexp within trim function

Linuxed wrote: > Is it possible to use regexp within a trim function? For example, if I wanted > to remove every alpha-numeric character at the end > of a string I could use the statement below. Is there any way to > simplify/condense the statement through regexp or a

Re: [sqlite] Clarification about Triggers

Today I came at work with cleared mind (after a long time I would say!) and within minutes have found an easy and rather silly solution to my initial request. Here's the code: CREATE TABLE tmp_name( id integer primary key, name text); CREATE TABLE [temp_01] (   [id] INTEGER PRIMARY KEY