[windows2000] Re: OT: Programming question

  • From: "Costanzo, Ray" <rcostanzo@xxxxxxxxxxx>
  • To: <windows2000@xxxxxxxxxxxxx>
  • Date: Thu, 13 Nov 2003 11:07:25 -0500

Yes, to me, what it sounds like is you will have to decide which is more
important, data accuracy, or user friendliness.  Having the first name
and last name split into separate columns will make for a more user
friendly application, but it will not be 100% accurate.  I'd go for the
accuracy, probably.  And if someone wants to search by last name, you
can do %searchText, as you suggested.

I recently had to do something similar.  Our current helpdesk
application, www.helpstar.com, is such that all of our users are in the
DB.  But, there is simple a "name" column in the DB.  There is no first
name, last name, etc.  We're moving to an AS/400 based application, and
that needed first name and last name.  So, I generated a file that was
90% accurate, and those that are wrong will have to be manually updated
as they are discovered.  That was good enough for me.  :]

Ray at work

> -----Original Message-----
> From: Rick Fogarty [mailto:rick@xxxxxxxxxxxxx] 
> Sent: Thursday, November 13, 2003 10:17 AM
> To: windows2000@xxxxxxxxxxxxx
> Subject: [windows2000] Re: OT: Programming question
> Yeah, it's unfortunate...  However, this will be the data for 
> our students
> transcripts.  We're switching to a new system shortly - we 
> want to have
> something on DVD for backup.  This will allow our admissions 
> department to
> reach back and get things as they were prior to our migration.
> The likeliness of requiring this is slim but nonetheless, I'd 
> like to ensure
> it works.
> As for the name field being all one... I thought of that, in 
> fact, I set it
> up that way the first time... What happens when they want to 
> search?  I'm
> sure I can set things up so they can do a search for the 
> whole field and do
> like statements... Then they'll see all students with De Los% 
> or something
> like that...
> That sounds reasonable, no?

The information contained in this e-mail message is intended only for the 
personal and confidential use
of the recipient(s) named above.  Distribution, publication, or retransmission 
of this message is strictly 
prohibited.  This message may be a bank to client communication and as such is 
priviliged and confidential.  
If the reader of this message is not the intended recipient or an agent 
responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any 
review, dissemination, distribution, or copying of this message is strictly 
prohibited.  If you have received 
this communication in error, please notify us immediately by e-mail, and delete 
the original message.

The sender of this e-mail specifically "opts-out" of the Electronic Signatures 
and Global and National 
Commerce Act (E-Sign) and any and all similar state and federal acts.  
Accordingly, but without limitation, 
any and all documents, contracts, and ageements must contain a handwritten 
signature of the sender to
be legal, valid, and enforceable.

This Weeks Sponsor Pearl Software
Internet Monitoring, Filtering, and Control Solutions
Enabling User & Group Level Oversight & Access Policies
Fully Functional in a Thick or Thin Client Environment
To Unsubscribe, set digest or vacation
mode or view archives use the below link.


Other related posts: