hi i have designed a program that runs with paradox db and one of the fields of my table is like that
Ex:
----
Field name:Genre
Field 1 Content:Action,Drama,Comedy,Thriller
Field 2 Content:Action,Mystery,War
what i want to do is when user entered Action and Thriller it will find the correct answer for this example field 1
but i couldnt find the appropriate sql query for that
i tried
SELECT Userid FROM divx where Genre LIKE ......
but i couldnt find how to finish
is there any way to do something like that?
My second question is after i do this sql query how can i take the data from a field
i mean i didnt understand how to use
query->GetFieldData()
i would be appreciated for any help
Liars Do Not Fear The Truth If There Are Enough Liars
Ex:
----
Field name:Genre
Field 1 Content:Action,Drama,Comedy,Thriller
Field 2 Content:Action,Mystery,War
what i want to do is when user entered Action and Thriller it will find the correct answer for this example field 1
but i couldnt find the appropriate sql query for that
i tried
SELECT Userid FROM divx where Genre LIKE ......
but i couldnt find how to finish
is there any way to do something like that?
My second question is after i do this sql query how can i take the data from a field
i mean i didnt understand how to use
query->GetFieldData()
i would be appreciated for any help
Liars Do Not Fear The Truth If There Are Enough Liars