Accept that versions of CF prior to MX don't handle nulls, and so the values returned as null from SQL Server to CF become empty strings instead with no way to differentiate them from a column which has a valid empty-string value vs. a column which should contain data but does not.
> As I told Patti off-list, this could be done with a cursor. That said, I > hazard to guess that whatever database solution you find that does JUST > return the data she's looking for, it won't offer much (if any) > performance > advantage over parsing things out manually. > ~Simon > Simon Horwith > Macromedia Certified Instructor > Certified Advanced ColdFusion 5 Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
