If it's a 1 time request, I'd say just write the sql. If it's something that's going to be done regularly, I'd look into oracle's full text searches. (You're using oracle, right?)
If you want to learn something new, you could probably write some pl/sql to look up the column names from the data dictionary and do a loop through those. If you want to be lazy I'd do select * from mytable in a cfquery, then dump myquery.columnlist, loop through that and and build your like statements, then use that to do the real query. On 7/5/05, daniel kessler <[EMAIL PROTECTED]> wrote: > >If you really have to do this, I would say that the database was very poorly > >designed > >at the first place. > > The database was not poorly designed or rather it may be but this request > does not show it. > This is a one-time request to see if any bad data was entered during the > updating process. > > >However, you could try an SQL expression that would concatenate > >all 50 columns in one string, then look if this string is LIKE whatever. > >I hope the table is not too large however! > > ok, great, thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211162 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
