aqui les pego el codigo para que lo vean
Código PHP:
function getBooks(month,IDroom)
fromDate1 = FormatDateTime("1/1/" & year(date),0)
toDate1 = FormatDateTime("12/31/" & year(date),0)
fromDate2 = FormatDateTime(month & "/1/" & year(date),0)
toDate2 = FormatDateTime(month & "/" & days(month,year(date)) & "/" & year(date),0)
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_eCrmHotel_STRING
rs1.Source = "SELECT* FROM Books WHERE Books.dateIn >= #" & fromDate1 & "# AND Books.dateOut <= #" & toDate1 & "# AND IDroom = " & IDroom & ""
rs1.CursorType = 1
rs1.CursorLocation = 2
rs1.LockType = 3
rs1.Open()
rs1_numRows = 0
totalBooks = rs1.RecordCount
rs1.close()
set rs2 = Server.CreateObject("ADODB.Recordset")
rs2.ActiveConnection = MM_eCrmHotel_STRING
rs2.Source = "SELECT* FROM Books WHERE Books.dateIn >= #" & fromDate2 & "# AND Books.dateOut <= #" & toDate2 & "# AND IDroom = " & IDroom & ""
rs2.CursorType = 1
rs2.CursorLocation = 2
rs2.LockType = 3
rs2.Open()
rs2_numRows = 0
[B] getBooks = formatnumber((rs2.RecordCount/totalBooks)*100,2)[/B]
rs2.close()
set rs2=nothing
end function
esta en negrita la parte donde me sale lo de overflow