MS-SQL 7.0, sqsh, not returning null values

Bill Doulass bill at tcada.state.tx.us
Thu Feb 17 11:10:05 EST 2000


When I run a query that returns null and non-null values for a field, each 
row that contains a null field is overwritten with the previous non-null 
value for that field.

Example:

sqsh 1.7, compiled on Red Hat Linux 6.1, talking to MS SQL 7.0.

When I query address1 and address2 fields, address2 returns null until it 
hits a row that contains a non-null value.  Thereafter, it returns the 
previous non-null value.

1> select addr_line_1, addr_line_2 from dOffender_Ed_Site where county='El 
Paso'
2> go
 addr_line_1                    addr_line_2                   
 ------------------------------ ------------------------------
 P.O. Box 370173                                              
 215 Willow                                                   
 701 Montana Ave.                                             
 P.O. Box 370173                                              
 P.O. Box 370173                                              
 701 Montana Ave. - Norton Room                               
 701 Montana Ave. - Norton Room                               
 10622 Montwood Dr., Suite D                                  
 7665 Leconte                                                 
 7665 Leconte                                                 
 7665 Leconte                                                 
 7665 Leconte                                                 
 P.O. Box 370173                                              
 10536 Montwood Dr., Ste. B                                   
 7665 Leconte                                                 
 215 Willow                                                   
 10737 Gateway W., Ste. 108                                   
 The Center Building            2104 E. Yandell, Ste. D-5  
 701 Montana Ave. - Norton Room 2104 E. Yandell, Ste. D-5     
 2104 E. Yandell, Ste. D-5      2104 E. Yandell, Ste. D-5     
 701 Montana Ave. - Norton Room 2104 E. Yandell, Ste. D-5     
 10737 Gateway W., Ste. 108     2104 E. Yandell, Ste. D-5     
 10536 Montwood Dr., Ste. B     2104 E. Yandell, Ste. D-5     
 The Center Building            2104 E. Yandell, Ste. D-5     
 Travel Lodge Hotel             409 E. Missouri               
 10737 Gateway W., Ste. 108     409 E. Missouri               
 701 Montana Ave. - Norton Room 409 E. Missouri               
 The Center Building            2104 E. Yandell, Ste. D-5     
 9005 Dyer, Ste. 106            2104 E. Yandell, Ste. D-5     
 10737 Gateway West, Ste. 108   2104 E. Yandell, Ste. D-5     
 10536 Montwood Dr., Ste. B     2104 E. Yandell, Ste. D-5     
 4625 Alabama St.               2104 E. Yandell, Ste. D-5     
 4625 Alabama St.               2104 E. Yandell, Ste. D-5     

Any suggestions are greatly appreicated.  

BTW - the snapshot seems much more stable than 0.5 - thanks for the help in 
getting that compiled.



More information about the FreeTDS mailing list