[windows2000] Re: OT: Programming question
- From: "Rick Fogarty" <rick@xxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Thu, 13 Nov 2003 13:22:02 -0500
Agreed. Working on that now... I suspect the accuracy is more important to
them - which means I'll have to do a short rewrite and search within the
whole name field....
-----Original Message-----
From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Costanzo, Ray
Sent: Thursday, November 13, 2003 11:07 AM
To: windows2000@xxxxxxxxxxxxx
Subject: [windows2000] Re: OT: Programming question
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
http://www.pearlsw.com
**********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
********************************************************
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
http://www.pearlsw.com
**********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.
http://thethin.net/win2000list.cfm
Other related posts:
