Thanks Jeff, Did that early this morning. Works well. Is there any benifit to using a _ instead of a space? The space will certainly look and present better.
Thanks, Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fleitz Sent: Saturday, July 30, 2005 8:41 AM To: [email protected] Subject: Re: [plum] Different Alt. Key for PlumUser Hi Mark, You are inserting literals in there. This is not Access, and you don't concatenate strings that way in CF Try changing the value attribute to value="#Form.LastName# #Form.FirstName# #Form.Phone#" Notice there is a space between each of the values; that's all you need. Jeff Mark Fuqua wrote: > Well, I tried it and it worked...sort of. I am obviously a little green. > This is the insert line > > <cf_PassColumnToAction column="UserName" type="varchar(100)" > value="#Form.LastName# + '_' + #Form.FirstName# + '_' + #Form.Phone#" > valueIfEmpty="NULL"> > > And here is what appears in the database and hence the <cf_filteredSelect>: > > Fuqua + '_' + Mark + '_' + 410-343-1960 > > When you experienced CFer's stop giggling, could you tell me how to change > the <cf_PassColumnToAction> value attribute to get what I want: > > Fuqua_Mark_410-343-1960 or if it is not a no no in an alternate key: Fuqua > Mark 410-343-1960 > > My wife is bugging me to stop "playing on the computer". I'll check > tomorrow. > > Thanks, > > Mark Fuqua > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark > Fuqua > Sent: Friday, July 29, 2005 8:13 PM > To: [email protected] > Subject: [plum] Different Alt. Key for PlumUser > > > > Just Wondering, > > Email addresses offer the benefit of being unique values for sure. However, > they are not very helpful when you have a large amount of users to choose > from. Especially if you use the "built-in" filter method. If you append > the first and last name to the email address as described here, > http://www.productivityenhancement.com/support/DisplayKBArticle.cfm?id=49A17 > CE5-F08F-4278-490A-E85EEACBF753&Page=1 it is a lot more recognizable, but > not really since the built in filter of the <cf_DisplayFilteredSelect> > filters on the first letters of the email address not the first few letters > of LastName. > > Plum doesn't work with compound keys and lastname is just too easy for > repeats. > > My application, as I assume many others is a business application, where > registered users are employees, subcontractors or established customers. As > such, almost all fields are required, except address 2 and a few others. > So, what if when you created a new user one of the fields (in the database > not the form...submitted as a variable called UserName). It would basically > be a combination of values entered on the add form for the plumUsers table, > as such: "#Form.LastName# + '_' + #Form.FirstName + '_' + #Form.Phone#". > > Something like: > > <cf_PassColumnToAction column="UserName" type="integer" > value="#Form.LastName# + '_' + #Form.FirstName + '_' + #Form.Phone#" > valueIfEmpty="NULL"> > > Forgive me if that is the wrong syntax. I actually stole that from an email > sent to me by Jeff, for another issue, and I don't know if it would actually > work that way. > > > This would, for all intents and purposes, produce unique value for that > field and be more searchable [is that a word?] and user friendly. It would > really be cool if you could put spaces in instead of '_' but I'm guessing > that would be a no no. > > Has anyone tried this and did it work? > > Mark Fuqua > > > > ********************************************************************** > 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 **********************************************************************
