ASP - Changing Numerical values into string values

programming
1

Hi there, i have a search facility for a small database that requests data by date.

The problem begins when i make a search and i enter day values over 10, the variable is taken as 1, if it is over 20 the var is taken as 2 and over 30 is taken as 3, i was told that the vars are being taken as numerical values and i am requesting String values. How could i change my recordset so it can work propperly?, instead of taking the first digit of the number and taking the whole number to process the search.

Here is my recordset:

<%
Dim rsIngresos
Dim rsIngresos_numRows
Set rsIngresos = Server.CreateObject("ADODB.Recordset")
rsIngresos.ActiveConnection = MM_conFlagService_STRING
rsIngresos.Source = "SELECT admissionDate  FROM Ingresos  WHERE DAY(admissionDate) >= '" + Replace(rsIngresos__r_DayA, "'", "''") + "' AND DAY(admissionDate) <= '" + Replace(rsIngresos__r_DayB, "'", "''") + "' AND MONTH(admissionDate) = '" + Replace(rsIngresos__r_Month, "'", "''") + "' AND YEAR(admissionDate) = '" + Replace(rsIngresos__r_Year, "'", "''") + "'"
rsIngresos.CursorType = 0
rsIngresos.CursorLocation = 2
rsIngresos.LockType = 1
rsIngresos.Open()
rsIngresos_numRows = 0
%>

Thanks in Advance