Query giving different results between Query Analyzer and ASP Page

[Torie]

I am successful pulling the appropriate data from a database table and a view (which contains 2 tables) via SQL query tool. However, when I make the selection from my ASP code, several fields will come back empty. There is no difference in the query generated via the code (I've cut/pasted) and what gets run into the query tool. Has anyone else experienced getting back empty fields, but you know that there really is data?

I have the code at work and will add tomorrow, if that would be helpful. But my first real question is if anyone else has experienced data not being returned when it is in the database.

My code is written in ASP and is for displaying on a web page. Not sure if I should post this question on ASP or SQL, so I'll try both! Thank you!

[Motoma]

I am successful pulling the appropriate data from a database table and a view (which contains 2 tables) via SQL query tool. However, when I make the selection from my ASP code, several fields will come back empty. There is no difference in the query generated via the code (I've cut/pasted) and what gets run into the query tool. Has anyone else experienced getting back empty fields, but you know that there really is data?

I have the code at work and will add tomorrow, if that would be helpful. But my first real question is if anyone else has experienced data not being returned when it is in the database.

My code is written in ASP and is for displaying on a web page. Not sure if I should post this question on ASP or SQL, so I'll try both! Thank you!

I am not sure what could be causing this...You say that the full result set is returned when you run the query through Query Analyzer?

[Torie]

I am not sure what could be causing this...You say that the full result set is returned when you run the query through Query Analyzer?

Yes! It's the weirdest thing. The only thing I can narrow it in on is that there is too much data being returned? Is there a limit to how many variables can be retrieved? Also, one of the items being returned is a TEXT data type. Perhaps that throws a monkey wrench into it?

[Motoma]

I have renamed this thread to have a more descriptive title, and moved it to the ASP forum with the hopes that someone there will have encountered a similar situation.