cfquery multiple column search

2014-02-10 Thread fun and learning
All - I am working on a search functionality for multiple columns of data. I using 'OR' condition for searching on a single search input. For example on front end i have a search input box, and I can enter either numeric or alphabets or alphanumeric characters. How can I handle this using

RE: cfquery multiple column search

2014-02-10 Thread David Phelan
10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.com www.emerginghealthit.com www.montefiore.org -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Monday, February 10, 2014 10:04 AM To: cf-talk Subject: cfquery multiple column search

RE: Multiple Column Search

2000-04-27 Thread Lon Lentz
From: Lee Surma [mailto:[EMAIL PROTECTED]] I have a user that has requested the ability to search a flat file, across 8 different columns in any combination. My first thought is that it would require a nightmarish amount of conditional logic. They currently have a form page that allows them

Multiple Column Search

2000-04-26 Thread Lee Surma
I have a user that has requested the ability to search a flat file, across 8 different columns in any combination. My first thought is that it would require a nightmarish amount of conditional logic. They currently have a form page that allows them to enter search criteria on any ONE of the 8

Re: Multiple Column Search

2000-04-26 Thread Sharon DiOrio
Verity. Sharon (OK, I'm resisting the temptation to leave you with that one word answer. Basically you can create a collection in verity with any combination of columns and the user can perform a text search to retrieve any record with that text. You'll need to play around with it, but it