Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-14-2022, 01:31 AM   #1
PowerOffliner
Member
PowerOffliner began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Nov 2016
Location: Germany
Device: Kindle Voyage+Signature
SQL statement not working

I hope my thread is right here?

Until version 5.40 I could send a query to show me which authors do not have a comma in the string like "Ludlum, Robert" and is sorted as column author_sort shows them.

The query string used is: " not author = "," " (1)
Also " not authors = "," "
Where as " authors = "," " shows them when including a comma.

The request ends with an empty list. No error message appears.

Since version 5.41 the query doesn't work anymore.
Does anybody know, why it doesn' work?

Configuration:
Latest version of Calibre 64 with 24.000 titles on
Windows 10-Notebook Panasonic FZ-55,
64 GB RAM + 2 TB m.2.

Thank you for reading and constructive help.

Last edited by PowerOffliner; 05-14-2022 at 01:33 AM. Reason: More information
PowerOffliner is offline   Reply With Quote
Old 05-14-2022, 12:05 PM   #2
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 19,432
Karma: 97346785
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Calibre 5.42 does not use punctuation in searches by default. See Searching broken in V5.42? for some help on this and Proposed change to library search for a possible future change.

Last edited by DNSB; 05-14-2022 at 12:08 PM.
DNSB is offline   Reply With Quote
Old 05-15-2022, 05:16 AM   #3
PowerOffliner
Member
PowerOffliner began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Nov 2016
Location: Germany
Device: Kindle Voyage+Signature
Thank you.
I will have a look soon.
And check, what's possible.
PowerOffliner is offline   Reply With Quote
Reply

Tags
query, sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre and SQL DB testor Library Management 4 02-20-2015 11:38 AM
SQL Queries iain_benson Calibre 9 06-04-2009 06:08 PM


All times are GMT -4. The time now is 11:51 PM.


MobileRead.com is a privately owned, operated and funded community.