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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ASP is not retrieving all the data!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-26 : 13:00:28
Alex writes "I have a database connection using the following string......

strSQLData = "SELECT * FROM [Screen] WHERE Module_T='" & Module & "' AND Segment_N=" & SegNum & " AND Screen_N=" & ScreenNum & "

then I use the getrows method to get all the data.....

But the only data display is the one from the first 4 fields of the database, I have different types of fields with in the table. The first 4 fields are nvarchar, and the fifth one is a ntext, and then a have alternating nvarchar with ntext fields...

Why is my data not being displayed ?"
   

- Advertisement -