I have a report that I'm trying to send in a SQL String to via an ASP page.
When I try to do this the ASP errors but it gives no error description.
My original thought was a bad Query String, but I've run the query through a Query Analyzer and it's just fine.
The reason for trying to send the SQL string in is that the table I'm working with is 1.3 million records long and I need to narrow that down and I think I can do this with this function. (record selector doesn't work like this - the report will still go thru all 1.3 million records)
What I think is the problem is the order of which I'm using it - maybe.
Any examples or info on this function would be great.
When I try to do this the ASP errors but it gives no error description.
My original thought was a bad Query String, but I've run the query through a Query Analyzer and it's just fine.
The reason for trying to send the SQL string in is that the table I'm working with is 1.3 million records long and I need to narrow that down and I think I can do this with this function. (record selector doesn't work like this - the report will still go thru all 1.3 million records)
What I think is the problem is the order of which I'm using it - maybe.
Any examples or info on this function would be great.