Python Forum
display the contents of a sqlite3 database according to the dates
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
display the contents of a sqlite3 database according to the dates
#4
curseur.execute('SELECT * FROM releves where time_releves_axe_loc35R between first_day AND last_day ORDER BY time_releves_axe_loc35R DESC')
it doesn't like the syntax for the between statemant as it relates to time_releves_axe_loc35R
I don't see that column in your create statement above.
I'd open sqlite3 from command line and ay '>' prompt type .schema releves;
make sure you table contains the column
Reply


Messages In This Thread
RE: display the contents of a sqlite3 database according to the dates - by Larz60+ - Mar-03-2019, 01:48 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Create SQLite3 database with peewee Jim53_1980 2 704 Dec-20-2023, 02:38 PM
Last Post: buran
  Regex replace in SQLite3 database WJSwan 1 822 Dec-04-2023, 05:55 PM
Last Post: Larz60+
  Rows not adding to sqlite3 database using SQLAlchemy Calab 11 1,782 Jun-02-2023, 05:53 PM
Last Post: bowlofred
  How to display <IPython.core.display.HTML object>? pythopen 3 46,073 May-06-2023, 08:14 AM
Last Post: pramod08728
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 1,408 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Python Variables and Sqlite3 Database Staples200 1 3,199 May-25-2021, 02:40 AM
Last Post: Staples200
  how to suppress not to display the package contents from pydoc! maiya 3 2,525 Mar-19-2021, 03:41 AM
Last Post: bowlofred
Information Unable to display joystick's value from Python onto display box MelfoyGray 2 2,260 Nov-11-2020, 02:23 AM
Last Post: MelfoyGray
  sqlite3 database problem Maryan 2 2,508 Oct-05-2020, 05:21 AM
Last Post: buran
  sqlite3 database does not save data across restarting the program SheeppOSU 1 3,477 Jul-24-2020, 05:53 AM
Last Post: SheeppOSU

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020