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.
Jump to PostApparently this means a problem with the db design.
But you may freely post your table's schema together with some sample data.
krs,
tesu
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
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?
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.