Thanks Mark, the article worked for me. I just wanted to have both a first name and a last name in the select.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Fuqua Sent: Wednesday, September 21, 2005 11:35 AM To: [email protected] Subject: RE: [plum] Concatenate in DisplayFilteredSelect Hey Dan, I am sure Jeff's answer will help you out as needed. I did just what the example shows, but found the whole idea of the email not very helpful for my purposes. Most people's email address just doesn't offer very many clues as to who they are. If it [EMAIL PROTECTED] or [EMAIL PROTECTED], the addresses are downright cryptic. So what I did was create a new field in plumUser called UserName. When a new user is added, the lastName, FirstName and Phone fields are combined to make the UserName field (My Plum project is an application and all those fields are required). When I read the above paragraph it sounds as clear as mud, and I wrote it. The code will be more clear. I added this to the action page: <cf_PassColumnToAction column="UserName" type="varchar(100)" value="#Form.LastName# #Form.FirstName# #Form.Phone#" valueIfEmpty="NULL"> This results in a unique value and a filtered select ordered by last name. Much better for my uses. However, I guess this would not be practical for most Plum projects, those where users can sign up with just an email address. Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fleitz Sent: Wednesday, September 21, 2005 7:53 AM To: [email protected] Subject: Re: [plum] Concatenate in DisplayFilteredSelect Hi Dan, There is a KB article in the Plum Support area on the Productivity Enhancement website. Here is the link (watch the wrap). http://www.productivityenhancement.com/support/DisplayKBArticle.cfm?id=49A17 CE5-F08F-4278-490A-E85EEACBF753&Page=1 Respectfully, _______________________________ Jeffrey Fleitz President Tekquest, Ltd Integrated Digital Solutions http://www.tekquest.com [EMAIL PROTECTED] 301.994.1468 866.315.8440 (toll free) _______________________________ Dan O'Keefe wrote: > I think this has been hashed over before but I am not finding the answer. Is > there any way to concatenate in a DisplayFilteredSelect? > > Common use would be in a name select combining first name and last name. If > not, is the only way to hand create the syntax to combine them in the query > and pass it to DB? > > Dan > --------------------- > Dan O'Keefe > TriPoint Technologies > 561-703-8976 > > > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
