Sorry, I thin I might not explained my self very well. Al though the "cfdbinfo" looks really cool and I think I can use it in a report generator tool I want to do, so thanks.
So what I want is a single form field that will search the entire table without having to specify which column. Thanks, tom On Jul 23, 2009, at 9:24 AM, cftalk wrote: > > You can also this little gem (cfdbinfo) > http://www.cfquickdocs.com/cf8/#cfdbinfo > > > -----Original Message----- > From: David McGuigan [mailto:davidmcgui...@gmail.com] > 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 <tjo...@acworld.com> 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:324913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4