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!