0

Hi all,

We're implementing a web-based database application for keeping track of employee emergency information. I need a sql query to select a row, but leave out any fields that are empty (but not null). I've got it working so that all fields in a row are selected. The problem is, I don't know which fields will be empty, so I cannot hard code the select statement to leave out certain fields.
Any help is appreciated.

Thanks.

4
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by stephen84s
0

Apparently this means a problem with the db design.

But you may freely post your table's schema together with some sample data.

krs,
tesu

0

I guess that I don't understand. If you were to make a temporary table out of the data that you want pulled down, what would it look like?

0

I've got it working so that all fields in a row are selected. The problem is, I don't know which fields will be empty, so I cannot hard code the select statement to leave out certain fields.

First requirement of its types I have seen, Whats the schema ?

-------------
Shucks dint see the last post was 5 days ago

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.