hi,
im using RS 2000, i have a report that gets sent an SQL statement as a parameter. this works fine once. but lets say i send "SELECT * FROM table WHERE col1 = 'blah'" (and out put is correct)
but then i send "SELECT * FROM table WHERE col1 = 'foo'"
the second one still returns the results from the first query. this happens no matter what parameter i send - including null and blank.
anyone know a solution to this? i would really appreciate it. thanks.
note: i dont think this is a cache problem but im not sure. cache execution is set to use most recent data, no snapshots are stored. i think its something to do with the stored procedure keeping the first parameter. but then if i knew what it was, i wouldnt be asking here would i...?
also, the error still occurs even if i close and reopen the browser, if i use clearsession=true, if i close the browser and come back the next day...
ok this problem seems to be fixed - though i am still not sure what the problem was / is.
i think it was something wrong with the way RS was dealing with the stored procedure. eg. i changed the procedure's parameter name. but the report didnt pick up on the change and kept trying to force the old name.
to my knowledge, i didnt do anything to fix it, it just fixed itself. so im not confident it will stay fixed...
