freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

MS-SQL 7.0, sqsh, not returning null values

From: "Bill Doulass" <bill AT tcada.state.tx.us>
To: freetds
Subject: MS-SQL 7.0, sqsh, not returning null values
Date: Thu, 17 Feb 2000 11:10:5

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.

MS-SQL 7.0, sqsh, not returning null values, Bill Doulass, 02/17/2000
- <Possible follow-up(s)>
- Re: MS-SQL 7.0, sqsh, not returning null values, Andreas Tille, 02/18/2000
- Re: MS-SQL 7.0, sqsh, not returning null values, Brian Bruns, 02/18/2000
- Re: MS-SQL 7.0, sqsh, not returning null values, Michael Peppler, 02/18/2000
- Re: MS-SQL 7.0, sqsh, not returning null values, Bill Doulass, 02/18/2000
- Re: MS-SQL 7.0, sqsh, not returning null values, Brian Bruns, 02/18/2000