> It's not a great idea because SQL 7 is not very efficient at > searching null fields. It's better that it have some value. > If a form field is not filled in just put it in anyway as a > blank (the field must be varchar or nvarchar - > char fields will fill the entire field length with blanks and > searching for a single blank '' will fail): Actually, I'd dispute this SQL Server 7 is very quick in doing; WHERE field is NULL WHERE field is not NULL If you're using isNULL and NULLif, then they are slower Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
