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

  • Thread starter Thread starter Troy
  • Start date Start date
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
 
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
 
Back
Top