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)  data not appear full when viewed in IE

Author  Topic  vikas Starting Member 2 Posts Posted - 2001-08-06 : 06:23:32 I have declared column qdata as varchar with length=2000 in sql server 7.0. I have inserted the data with less than 2000 characters into the field. Now when i view the data by passing the select query in query analyzer ,the data does not appear fully?????? For your convinience I show my data.Please enter in sql server 7.0 database and test it in query analyzer. ************************************ Consider the following code: 1. public void method(String s){ 2. String a,b; 3. a = new String("Hello"); 4. b = new String("Goodbye"); 5. System.out.println(a + b); 6. a = null; 7. a = b; 8. System.out.println(a + b); 9. } Where is it possible that the garbage collector will run the first time? ************************************ Please help me out with this problem. when I display it through asp code on my local system (pws), the display is ok. Now I export my data in text-table conversion on the internet server by using dts import export wizard ( in another sql server 7.0). When I run the same asp code on IIS and display the same data(now on IIS) , the data is displayed but not completely ???????? Can anybody help me out with this problem???????