Hi I have a search box that currently contains only one field. I normally have one input for first name, one for lat name and so on, which makes the task of searching somewhat easier. However, in this scenario that is not the case. So, what I want to do is split the search term entered into distinct variables. An example - let's say someone enters "joe blogs" in the search field (without quotes). I then want to be able to parse it so that I have one variable for "joe" and another for "blogs", which I can then search on since the database is organised into first_name, last_name, maiden_name, email, etc. The criteria for this will be the space between the names. This looks like a case for regular expressions. I know how to use REFind to check for the space, but that's all so far (I've spent some time on this, and even read the docs!). Can someone help me here please? TIA
Regards Mark Henderson Web Designer mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 205 Main Street PO Box 143, Gore Southland 9700 Phone: (03) 203 9999 Fax: (03) 203 9900 <http://www.cwc.co.nz> <http://www.ispnz.co.nz> <http://www.nzfarming.co.nz> http://www.cwc.co.nz <http://www.cwc.co.nz> http://www.ispnz.co.nz <http://www.ispnz.co.nz> http://www.nzfarming.co.nz <http://www.nzfarming.co.nz> Notice of Confidential Information: The information contained in this electronic mail is CONFIDENTIAL INFORMATION and may be LEGALLY PRIVILEGED, intended only for the individual or entity named above. If you are not the intended recipient, you are hereby notified that the use, dissemination, distribution, or copying of this document is strictly prohibited. If you have received this electronic message in error, please immediately notify us by return or telephone (0064 3 203 9999) and destroy the original message. Thank you. -- This message has been scanned for viruses and dangerous content by ISPNZ's automated virus detection system, and is believed to be clean. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
