[sqlite] input using a dropdown list

2016-05-22 Thread Simon Slavin
On 22 May 2016, at 11:57pm, Gary Ehrenfeld wrote: > I corrected the results to result and everything works. Thank for seeing > that. I feel really stupid right now. Don't feel bad. We've all done it. Second pair of eyes always helps. Simon.

[sqlite] input using a dropdown list

2016-05-22 Thread Simon Slavin
On 22 May 2016, at 11:46pm, Gary Ehrenfeld wrote: > Yes. Here is the code I am using but when I run it all I get is an empty list. Just as a test, replace your code which makes the dropdown list with code which just shows the options on the display: "".$value."" Get that working first, then

[sqlite] input using a dropdown list

2016-05-22 Thread Simon Slavin
On 22 May 2016, at 11:15pm, Gary Ehrenfeld wrote: > Any suggestions? I am using SQLIte3 and PHP. Before you try to make a dropdown list with options taken from a SQLite database, do you know how to make a dropdown list with fixed text options ? Simon.

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

2016-05-22 Thread Jason Doherty
Hi We?ve used SQLite rtree indexes successfully on iOS and Android for creating spatial indexes in the past. We can?t seem to make them work on Windows. We are using the System.Data.SQLite ADO.NET library that was downloaded using the NuGet package manager (version 1.0.101) per the instructions,

[sqlite] input using a dropdown list

2016-05-22 Thread Gary Ehrenfeld
It works but how do I get it to work with an input statement so I can insert it into the hive_type column in the hive table. On 5/22/16, 15:58, "Simon Slavin" wrote: > >On 22 May 2016, at 11:57pm, Gary Ehrenfeld wrote: > >> I corrected the results to result and everything works. Thank for seei

[sqlite] input using a dropdown list

2016-05-22 Thread Gary Ehrenfeld
I corrected the results to result and everything works. Thank for seeing that. I feel really stupid right now. On 5/22/16, 15:51, "Simon Slavin" wrote: > >On 22 May 2016, at 11:46pm, Gary Ehrenfeld wrote: > >> Yes. Here is the code I am using but when I run it all I get is an empty >> list.

[sqlite] input using a dropdown list

2016-05-22 Thread Gary Ehrenfeld
Yes. Here is the code I am using but when I run it all I get is an empty list. query($sql); while ($row = $results->fetchArray($result)) { $value=$row["type"]; $options.="".$value; } ?> On 5/22/16, 15:35, "Simon Slavin" wrote: >

[sqlite] input using a dropdown list

2016-05-22 Thread Gary Ehrenfeld
I have a table named hives and one of the fields is named hive_type. I have another table named hive_type with a single field name type. I have tried several methods with not luck. I want to populate hives.hive_type with a selections from a dropdown list from hive_type.type Any suggestions? I

[sqlite] Searching this mailing lsit

2016-05-22 Thread Tom Holden
> Mail-Archive.com returns no hits for 2013 and 2014 even when the search term > is "SQLite". None until sometime in 2015. So the archive is incomplete or its > index is corrupted. > > On the other site, your search has results only in 2013 and 2016. With > Mail-Archive.com having no data for 2

[sqlite] Searching this mailing lsit

2016-05-22 Thread RMtrix
Mail-Archive.com returns no hits for 2013 and 2014 even when the search term is "SQLite". None until sometime in 2015. So the archive is incomplete or its index is corrupted. On the other site, your search has results only in 2013 and 2016. With Mail-Archive.com having no data for 2013, it retu

[sqlite] SQL logic error or missing database no such table

2016-05-22 Thread Rajendra Shirhatti
Hi Randall, Thank you so much for your reply. I don't have enough data to confirm whether database file is missing or it's due to some other reason. According to my initial investigation, it looks like the application is able to create database and perform all the operations successfully upon servi

[sqlite] Sqlite incompatibility with Postgres

2016-05-22 Thread dandl
> > Every aggregation function is at least second order: a function that > > applies a function to the set. So for MIN the function is 'less than', > > for SUM() the function is 'plus' and so on. In Andl aggregation > > functions are provided by fold(), which takes a function as an > > argument. >

[sqlite] Optimising max(datetime()) queries.

2016-05-22 Thread R Smith
On 2016/05/21 5:12 PM, Jonathan wrote: > Hi List, > I've come across a little curiousity and was wondering what was going > on (and if there's an even better way). > > I have some DATETIME data: > > 2013-06-03 16:08:55+01:00 > 2013-06-03 16:46:22+00:00 > 2013-06-03 16:48:57+00:00 > ... > > I wan

[sqlite] SQL logic error or missing database no such table

2016-05-22 Thread R.A. Nagy
Try: .schema [tablename] Since there is probably nothing there, you probably need to create a table. If you are new to SQL / SQLite, then here are some helpful videos: https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy Cheers, -Randall Nagy President, Soft9000.com O

[sqlite] SQL / SQLite for Beginners

2016-05-22 Thread R.A. Nagy
All, A recent convert to using SQLite, I have put together a series of videos on learning SQL, as well as covering the basics of using SQLite. https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy Would this be the proper mailing list / way to let new-users learn more about th