Please illustrate how to omit null field from a DB using a datalist.

T

Troy

I am at the end of my rope here. Would someone mind showing me some code
that would leave out all of the fields that are not null. In my Container I
have blank lines all over the place becuase it is returning the null fields
from the db.

I would like to then take it one step further and run some other conditions
as well, but this container crap has me very confused.

Any help is greatly appreciated.

Thanks,

Troy
 
S

S. Justin Gengo

Troy,

In your SQL statement add WHERE [FieldName] Is Not Null

Sincerely,

--
S. Justin Gengo, MCP
Web Developer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top