Hi All
I am trying to use 3 search parameters to search a database and give me the quantity of records.
I have tried most options I know and this is the only one that does not say tooo many parameters.
If you have an idea what i should be doing please let me know
Thank you
If I use this code below it does bring out all the correct answers but I need to know how many are correct
I am trying to use 3 search parameters to search a database and give me the quantity of records.
I have tried most options I know and this is the only one that does not say tooo many parameters.
If you have an idea what i should be doing please let me know
Thank you
B4X:
Log(Sql2.ExecQuerySingleResult("SELECT count(*) FROM Questions_db WHERE `main_cat` LIKE ? and `subCat` LIKE ? and `difficulty` LIKE ? "&Chr(34)&dtaMainCat.Value&Chr(34)&dtaSubCat.Value&Chr(34)&dtaDifficult.SelectedIndex&Chr(34)))If I use this code below it does bring out all the correct answers but I need to know how many are correct
B4X:
rp = Sql2.ExecQuery2("Select ques_id, main_cat, subCat,question,correct_no,answer1,answer2,answer3,answer4, difficulty FROM Questions_db WHERE `main_cat` LIKE ? and `subCat` LIKE ? and `difficulty` LIKE ? ",Array As String(dtaMainCat.Value, dtaSubCat.Value,dtaDifficult.SelectedIndex ))