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