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]
