By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

Query giving different results between Query Analyzer and ASP Page

P: 3
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!
Jun 5 '07 #1
Share this Question
Share on Google+
3 Replies


Motoma
Expert 2.5K+
P: 3,235
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?
Jun 5 '07 #2

P: 3
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?
Jun 6 '07 #3

Motoma
Expert 2.5K+
P: 3,235
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.
Jun 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.