Great!!!. I used IsNumeric(fieldname) but I seem this solution is more generic. Thanks people cheers Mariop --- Dave Watts <[EMAIL PROTECTED]> escribi�: > > > How to detect a null SQL field in colldfusion??? > > > Thanks in advance. > > > > <cfif len(trim(fieldname)) gt 0> > > the filed is not null > > <cfelse> > > the field is null > > </cfif> > > Uh, that tells you the length of the field. CF > doesn't recognize NULL > values, and it replaces them with zero-length > strings. I don't think that > you can determine from a CF recordset whether the > database contains NULL > values or empty strings. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > >
______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
