If always storing first and last name in seperate columns is something you need to maintain for other purposes, I would create an SQL view that combines both the first and last name into the 'fullname' column that Imail expects to see.
You could get unexpected results if they try to change it via web messaging, though. I store it in just one column in our db. - Tony >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of Mertens Erwin >Sent: Tuesday, June 11, 2002 12:04 PM >To: [EMAIL PROTECTED] >Subject: [IMail Forum] external DB and first & last name > > >Hi, > >I'm using an external SQL-database as userDB > >When a student is registred in our school, his account is >automatically stored in the Imail-database. > >Is there someone who knows how to enter teh first and last name >of the person in the database. It can only find (and use) the >"FULLNAME" field. > >thanx, >kind regards, > >Erwin Mertens >Webmaster >EHSAL-Dienst Informatica >Stormstraat 2, 1000 Brussels, Belgium >tel. 02-210 13 27, fax. 02-210 13 27 >e-mail: [EMAIL PROTECTED] >URL: http://www.ehsal.be > >Please visit http://www.ipswitch.com/support/mailing-lists.html >to be removed from this list. > >An Archive of this list is available at: >http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > >Please visit the Knowledge Base for answers to frequently asked >questions: http://www.ipswitch.com/support/IMail/ >--- >[This E-mail was scanned for viruses by http://www.intouchmi.com] > > --- [This E-mail was scanned for viruses by http://www.intouchmi.com] Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
