Thanks Adrian, I try that and let you know what I find. Looks like a good start.
Thanks, Mark On 2/23/07, Adrian Lynch <[EMAIL PROTECTED]> wrote: > > Two ways might work, search on both columns by concatenating the columns > with a space > > WHERE FirstName + ' ' + LastName = 'FORM.searchText' > > or > > Split them with a list function > > WHERE FirstName = 'ListFirst(FORM.searchText, " ")' > AND LastName = 'ListLast(FORM.searchText, " ")' > > Not bullet proof, but a start. > > Adrian > > -----Original Message----- > From: Mark Brown [mailto:[EMAIL PROTECTED] > Sent: 22 February 2007 23:10 > To: CF-Newbie > Subject: Search Question > > > Hello, > I've got a form with two field, on is a drop down box that allows the > user > to select the search parameters, the other field is to input what the user > would like to search on. The drop down box has items like First Name, > Last > name, or First and Last Name. > If the user selects "First and Last Name", the type the full First and > last > name in the second field, I'm trying to figure out if there is a way to > the > that one field and split it into two variables to search on, First_Name > and > Last_name. My database has First Name and Last Name in seperate columns. > > Does that make sense? Any help you could lend would be greatly > appriciated. > > Thanks, > mtbiker > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2592 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
