All database query results dosent show on asp page

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

All database query results dosent show on asp page

Author

Topic

MainSystem
Starting Member

7 Posts

Posted - 2007-12-05 : 16:22:10

Hello
I have just migrate from access database to sql , i have complicated asp pages with lots of sql queries on them , after my migration some of the data are missing on this complicated webpages although they are on database and they are shown when i crate a simple webpage ,so my problem is some of database data which shown up on simple asp page with one sql query doesn't shown on a complicated asp pages
any one can help me with this?
Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-05 : 16:34:43

Your problem is within your application and not inside the database.

This is not a data corruption issue, so I am going to move your thread. Since it is also not a problem with the database, I'll move it to the programming forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

MainSystem
Starting Member

7 Posts

Posted - 2007-12-05 : 16:53:52

Hello,
if it's from my application , why my application works fine with access but , when i change the database its not working fine ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-05 : 16:58:25

The problem is in the application because you stated that the database is in the database and is viewable with a simple webpage.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-05 : 17:14:09

Perhaps you need to be more clear in your problem.

If you run the complex query inside SQL Server Management Studio (2005) or Query Analyzer (2000), does it return the data?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

MainSystem
Starting Member

7 Posts

Posted - 2007-12-05 : 17:29:47

Thank you Tara ,
yes it returns data , but in a web page which i have some other queries some of the data of one of my tables doesn't show up although they are on database

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-05 : 17:35:30

If the query is returning the correct data in SSMS or QA and that query is being used in the application, then the problem is inside your application.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

MainSystem
Starting Member

7 Posts

Posted - 2007-12-05 : 17:36:47

i test it again , even in a simple page if i want to show all data of that table , some of them wont show up , its random , when on field show the other doesn't...

MainSystem
Starting Member

7 Posts

Posted - 2007-12-05 : 17:41:45

I thing it from memo fields , when more than one of them are shown the others doesn't show.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources