Re: [sqlite] How to store and retrieve list of images from sqlite in android
* I wrote the code in java file for displaying images.But those images are not displaying in emulator. If you possible give me a sample application to retrieve list of images from sqlite. -- View this message in context: http://old.nabble.com/How-to-store-and-retrieve-list-of-images-from-sqlite-in-android-tp32469610p32483518.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 *may* be able to test with that this weekend, but do you have a specific > reason for suggesting it? Is there a known issue with Thursby's CIFS? If > not, is Apple's AD known to work? Sorry, I don't know whether there's a known problem with ADMitMac, I just thought it would be fast, cheap and easy to check with some software you must already have. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 issue with Thursby's CIFS? If not, is Apple's AD known to work? Thanks, Jim On 9/16/11 1:03 PM, Simon Slavin wrote: Can you use the OS X SMB client rather than ADmitMac ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 not supported." The problem, however, is with the application using sqlite to store the data. The environment is this: 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 When logged in with a domain account and using a network home, Firefox will never quit properly. Launching and using it are fine, but when trying to quit, log out, or shutdown, the sqlite files are still listed as open files (Both in Open Files on the Windows DC and when running "lsof" on the Mac). I am in the process of testing this with Apple's built-in AD and SMB client, but based on the information I've found, I expect the problem to be the same. Since this will affect every Mac user attempting to use Firefox on an AD network, this would seem to me to be a bit more than a minor problem with sharing a file on an SMB volume. Any assistance or advice is greatly appreciated. Regards, Jim Thomas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 To: Steve Parrish ; General Discussion of SQLite Database Sent: Friday, September 16, 2011 11:15 AM Subject: 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. SQL Server is a completely different thing. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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. SQL Server is a completely different thing. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 culture or the neutral culture. Make sure "System.Data.SQLite.SR.resources" was correctly embedded or linked into assembly "System.Data.SQLite" at compile time, or that all the satellite assemblies required are loadable and fully signed. (mscorlib) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 time < strftime('%s', 'now', '-30 days') * 100
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 expectations.
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 geometry data inside the database. And that, quite simply, is what I have here: http://www.baboonz.org/shapefile2.php Only 1269 lines of code, liberally licensed. -- The content of this e-mail message and all attachments thereto (`this message`) does not necessarily reflect the views of IMQS Software (Pty) Ltd (`IMQS`). Before acting on the contents thereof, the recipient should verify that the originator has the appropriate delegated authority. In the event that this message has not been appropriately authorised in terms of IMQS`s delegation of authority, or in the event of the personal usage of IMQS`s e-mail facility, IMQS will not be liable for the contents of this message. 1. This message may contain information which is confidential, private or privileged in nature and subject to legal privilege. If you are not the intended recipient you may not peruse, use, disseminate, distribute or copy this message or its attachments. Please notify the sender immediately by e-mail, facsimile or telephone and thereafter return and or destroy this original message. 2. Please note that the recipient must scan this message and any attachments for viruses and the like. IMQS accepts no liability, damage or expense resulting directly or indirectly from the access of any message or it`s attachments or the use thereof. 3. IMQS reserves the right to monitor, read, filter, block, delete, use and act upon any incoming or outgoing message or it`s attachments sent or received by the employee, including hyperlinks in such message attachments and files copied or saved, automatically or by the employee on IMQS`s equipment. -- Please report email abuse / misuse to itsupp...@imqs.co.za ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 frustation on other systems. When I know a computed column or something similar is unique (or unique enough, such as only caps differences), it is nice to be able to keep the groupings simple. -j Thanks Jay and others for very thoughtful answers. My personal preference would be for a (perhaps optional) strict enforcement of the syntax, supplemented by two aggregate functions: choose_one() : Chooses one value, could be identical to current behavior, but make it explicit. all_identical() : Returns the value of the column if there is only one distinct value there. Otherwise it will throw an error. I find this use-case, which is the one Jay mentioned, very useful, but sometimes it is very important to guard against insane data. Having SQLite automatically figure out if a non-grouped column is actually guaranteed to be unique seems useful, but probably more involved than a pragma simply implementing this restriction in all cases. Anyway, since this is not something that can be changed currently, I'll find a way to work around this. Best, Magnus ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 it does not give the intended results.
Show your data, show the results you get from the statement, and explain how
the observed outcome differs from your expectations.
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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,
Miklos
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 wildcard > character? Not with a built-in function. You can always write a custom function, and do whatever you want there. > Also, if I want to remove single or double quotes in addition to > alpha-numeric characters how can I include them in > the string of characters to trim? I've tried \' and \" without success. You include double quotes as-is. You escape an apostrophe by doubling it up: 'Here''s a "quote"' -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
