How help: VC2010mfc for database query, query is greater than or less than I want all of the variables of input data, and all the data query two time variables, mainly is the SQL statement
1,

For example, the first date is COleDateTime m_d1, a second date is COleDateTime m_d2, how to query all the data in the two periods, m_d1, m_d2 are variable, how to said it in the SQL statement

2,

A value with an int variable m_num said
Here is how to use the SQL statement said is greater than the value of the variable A