replace(string, " ", "", "ALL") > -----Original Message----- > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 10:54 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] removing spaces > > > now _that's_ a good idea ;-) > > still doesn't tell me how to remove spaces, though... > > Ian W > > > ----- Original Message ----- > From: "Paul Johnston" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, September 17, 2003 10:58 AM > Subject: RE: [ cf-dev ] removing spaces > > > Why duplicate the data? > > Why not just put a Foreign Key to the Directory table in the > login table and > when doing the login check whether there is a fullname that > when lower-cased > and with spaces removed is the same (and then use the > password)...? That > way, if the user changes their "fullname" then you won't have > to mess around > with updating a second table with the data (unless that is > the Primary Key > in the Directory table and therefore the Foreign Key in the > login table). > > Paul > > > -----Original Message----- > > From: Ian Westbrook [mailto:[EMAIL PROTECTED] > > Sent: 17 September 2003 10:44 > > To: cfug dev list > > Subject: [ cf-dev ] removing spaces > > > > > > Hi > > I've got a table, Directory, with a field 'fullname', > > containing strings like 'Harlequin Theatre and Cinema' > > > > I want to copy all the fullnames to a seperate table, login, > > to allow organisations to log into the CMS and modify their > > records. For an organisations's username I want to lower-case > > all the fullnames and remove spaces, such that > > > > Harlequin Theatre and Cinema > > > > becomes > > > > harlequintheatreandcinema > > > > Then I'll generate a password for each using the script > > someone kindly supplied a while back (alphanumeric string, > > upper- and-lower case) > > > > I can lower-case no trouble using Lcase, but I'm stumped as > > to how to remove the spaces. > > > > can anyone give me a clue? > > > > ta > > > > Ian W > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] >
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
