SQLite Forum

How to display count(*)

How to display count(*)

(1) By Tony S (tonyATMS) on 2020-03-30 14:52:02 [link] [source]

I am using jQuery and JavaScript to get a count of records from a SQLite table. I used count() and the data returned shows Count(): 342. I want to put the count into an html input value. All I see is [object] and not a number. How do I get the actual number from the returned data? Thanks.

(2) By Stephan Beal (stephan) on 2020-03-30 15:31:12 in reply to 1 [source]

You're going to need to ask whoever authored the JS/sqlite3 bindings you're using. This forum is for the sqlite3 C library and command-line app - the developers here have nothing to do with any of the various JavaScript bindings for sqlite, nor does jQuery have anything at all to do with sqlite - it's for managing/manipulating HTML DOMs, not databases.