Member Avatar for guruOfCool

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
  • 84 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by stephen84s
Member Avatar for tesuji

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

Member Avatar for R0bb0b

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?

Member Avatar for stephen84s

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.