Search Function Help (database support)

I have created a Database application in Visual C++ 6.0 through the MFC application wizard. I have almost completed my application except for a few touch ups.  So far i have been able to search only if i get an exact match by using m_strFilter which is a function of CRecordSet class (function made available for me through the mfc application wizard).  I would like to be able to filter partial matches as well.

Application Interface: http://www.public.iastate.edu/~cshoun/DrinkRecipes.jpg

example: I will search the term "Summer" in the field called RecipeName
I will get records with the Recipe Name of Summer Breeze, Summer Baybreeze, Summer Dream and so on..
so all the records i would like filtered will at least contain "Summer" in the RecipeName field.

Question: How can I search my records and filter partial matches as well as exact matches?

App info: MFC SDI with database support

here is part of the code that calls my search button:

code:
void CDrinkRecipesView::OnSearchbutton2()
{
      CString m_Input="";
      GetDlgItemText(IDC_SEARCHEDIT, m_Input);
            

      m_pSet->m_strFilter = "RecipeName = ?";
      m_pSet->m_RecipeNameParam = m_Input;
      m_pSet->Requery();
      
      if (m_pSet->IsBOF())
      {      
            m_pSet->m_strFilter = "RecipeName = RecipeName";
            m_pSet->Requery();
            
            AfxMessageBox("Record not found!");
            UpdateData(FALSE);
            m_ctlSearchEdit.SetFocus();
            m_ctlSearchEdit.SetSel(0,-1);
      }
            
      else
      {
            UpdateData(FALSE);
            m_ctlSearchEdit.SetSel(0,-1);
            m_ctlSearchEdit.Clear();
            m_ctlSearchEdit.SetFocus();
      }

}

Additional info: Here is the web address to all of my files http://www.public.iastate.edu/~cshoun/DrinkRecipes/

Thanks for your help
cshounAsked:
Who is Participating?
 
AndyAinscowConnect With a Mentor Freelance programmer / ConsultantCommented:
my mistake (end of a hard day)
try
m_pSet->m_strFilter = "RecipeName LIKE 'summer*'";

also the wildcard can be provider dependant, alternative could be %
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
instead of
m_pSet->m_strFilter = "RecipeName = ?";
try
m_pSet->m_strFilter = "RecipeName = 'summer*'";

note for searching on a string you need the single quotes, the * is a wildcard to match else it finds only the exact string.
0
 
cshounAuthor Commented:
just tried that it still only finds exact matches and it excepts the * as part of search criteria
0
 
cshounAuthor Commented:
Thanks I have found though that the star doesn't work...but your % does

example: m_pSet->m_strFilter = "RecipeName LIKE '%summer%'";
             will take all summer matches

m_pSet->m_strFilter = "RecipeName LIKE '%summer'";
will only take summer matches when the field ends with summer!

m_pSet->m_strFilter = "RecipeName LIKE 'summer%'";
will only take summer matches when the field begins with summer!

i gave up on an answer so I just started writing my own filter...which was taking forever...Thank god i haven't saved yet :)

A thousand thanks to you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.