You can also this little gem (cfdbinfo) http://www.cfquickdocs.com/cf8/#cfdbinfo
-----Original Message----- From: David McGuigan [mailto:[email protected]] Sent: July-22-09 9:23 PM To: cf-talk Subject: Re: WildCard query You can grab a list of all of the columns of any table and loop through them pretty easily ( they syntax varies with your database vendor ). MySQL is just: describe tableName On Wed, Jul 22, 2009 at 9:10 PM, Tom Jones <[email protected]> wrote: > > Hello, > I'm migrating some pages from Lasso to Coldfusion and one of the > current pages in Lasso has a query to search any field/column for a > value. I have never done this with coldsuion before so I'm not sure > how to go about this. > > thanks, > tom > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
