I agree with Dave... Perhaps you need a different sort of join (a left join perhaps) ... That would return blank column values if no row existed for the join.
-Mark -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, January 04, 2008 10:48 AM To: CF-Talk Subject: RE: sql clear data > If I delete the row then I break the joins in the database. > So I want to blank the data out rather then remove the entire row. > > Thanks for the code. I forgot about the columnlist attribute on the > query. > > There is probably a better way of setting up the database so don't > have to worry about this, but im not the guy that made the database. There's not much point in having a join to a row that contains no values. What exactly are you trying to accomplish? There might be a better way to get where you're trying to go. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
