kyriakos70
Programmer
Hello,
I have a database with multiple tables, in one table I have added an sql string in a query for searching purposes, in a parameter I have a field of the database with only two (2) predefined values, values are "simple" and "advanced" in the query "SELECT * FROM Taxinomisi WHERE (id LIKE
hhh) OR a/n LIKE iii) OR country LIKE ccc) AND date BETWEEN date1) AND date2) AND DIAK LIKE diak2)) the field and parameter DIAK is the has the 2 values what I can't figure out is I give the 1 or 2nd value through a combobox but I want in the search string to have a 3rd option to search for both values too, how can I do it?Any help.
Thank you
Kyriakos
I have a database with multiple tables, in one table I have added an sql string in a query for searching purposes, in a parameter I have a field of the database with only two (2) predefined values, values are "simple" and "advanced" in the query "SELECT * FROM Taxinomisi WHERE (id LIKE
hhh) OR a/n LIKE iii) OR country LIKE ccc) AND date BETWEEN date1) AND date2) AND DIAK LIKE diak2)) the field and parameter DIAK is the has the 2 values what I can't figure out is I give the 1 or 2nd value through a combobox but I want in the search string to have a 3rd option to search for both values too, how can I do it?Any help.Thank you
Kyriakos
