vendredi 1 avril 2016

Syntax error in SQLite: Exception Name: NS_ERROR_FAILURE

What is the meaning of this syntax error in the second line of this query?

SELECT hash FROM files WHERE localUrl LIKE '%TextInPDFFileName%'
SELECT documentId FROM documentfiles WHERE hash = [Hash I just found]
SELECT title FROM documents WHERE (NOT deletionPending = 'true') AND id = [ID I just found]
SELECT lastName FROM documentcontributors WHERE documentId = [ID I just found]
SELECT publication FROM documents WHERE (NOT deletionPending = 'true') AND id = [ID I just found]

The error message from SQLite Manager is:

> SQLiteManager: Likely SQL syntax error: SELECT hash FROM files WHERE
> localUrl LIKE '%TextInPDFFileName%'   SELECT documentId FROM documentfiles WHERE
> hash = [Hash I just found]  [ near "SELECT": syntax error ] Exception
> Name: NS_ERROR_FAILURE Exception Message: Component returned failure
> code: 0x80004005 (NS_ERROR_FAILURE)
> [mozIStorageConnection.createStatement]

I'm following instructions from http://ift.tt/1q8TOHy

Aucun commentaire:

Enregistrer un commentaire