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]
