Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL SELECT workaround needed
There is a bug in the view designer which prevents me from creating the SELECT I want to use because it scrambles the parenthesis. I am creating an application with a search which allows the user to enter multiple substrings and retrieves these records. Ordinarily, the SELECT statement would look like this:
SELECT {fields}
FROM {table}
WHERE ((table.subject = m.Term1a) OR
(table.subject = m.Term1b)) AND
((table.subject = m.Term2a) OR
(table.subject = m.Term2b)) AND
(table.subject = m.Term3) AND
(table.subject = m.Term4) AND
(table.subject = m.Term5)
The user can enter 5 terms, the first two of which can be one field OR the other (For entering a word and an abbreviation. The last three are single terms used in the search.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement