Have problems with the recordset…if the value of tempPremium is more than > 10,000 than I get no results after this statement executes:

set rsDownPayment = applyFilterAndReloadRecordset(rsDownPayment,"min_p remium <=" & tempPremium & " and b80_userline = '" & objLogic.userline & "' and profile = '" & objLogic.profile & "'")

I was trying to debug the application using response.write statement but get no results if the values of tempPremium is more than 10,000 (values under 10,000 works fine).
Note: does the recordset has any limitations that might be doing this??
Any suggestions or help will be appreciated…ASAP!
Thanks a lot for yr time…

It is probably code in your applyFilterAndReloadRecordset method.
What is the code in that method?
Are there any error messages?
Are you suppressing errors?
Also, are you using that comma in 10,000? It should be 10000.
An ADO recordset has no limitations that would cause this.




Woody Z
http://www.learntoprogramnow.com

Here is the code for the applyFilterAndReloadRecordset method:

function applyFilterAndReloadRecordset(rs, filter)
    dim rsTemp
    set rsTemp = rs.clone

    rsTemp.Filter = filter

    dim zobj
    set zobj = server.CreateObject("ADODB.Stream")

    rsTemp.Save zobj, 0
    rsTemp.Close

    rsTemp.Open zobj

    set applyFilterAndReloadRecordset = rsTemp
end function

No there r no error messages & I am not trying to suppress the error messages.

(If Err.number <> 0 then
response.write ("Your error number is " & Err.number & "<br>")
response.write ("The error source is " & Err.source & "<br>")
response.write ("The error description is " & Err.description & "<br>")
End If)

But I see no error messages. Yes, the value is 10000 & not 10,000!
So what u think the problem could be??
Thanks

There is no obvious reason... so lets look for something that is not obvious.
What is the database? Oracle, Sql Server, Access, MySql, Informix, etc?
What is the datatype of the tempPremium field.
I assume it is numeric - so what are the constraints on it - scale, precision, size, etc - in the database table?

The main observation I can make at this time is that 9999 is four digits, and 10000 is five. So, can this make a difference? It's the only variation that jumps out.

What else...? I'll try to help, but it's tough in this environment.

Woody Z
http://www.learntoprogramnow.com