SQL Server 2000 v.8
> What is your underlying database? > > Joe D'Souza > Remedy Developer / Consultant, > Shyle Networks, > New Jersey. > > > > ----- Original Message ---- > From: Kelly Logan <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, November 9, 2006 3:55:42 PM > Subject: USA City, State lookup by zip code for Customer in Help Desk > > > Hello All, > > I've had a request to have the entirety of possible US (including Puerto > Rico) zip codes available for City, State lookup in the Customer form for > Help Desk. > > USPS has a ASCII file with all of them in readable format, but it looks > monstrous (an entire CD, zipped; better than a DVD, I guess). > > We do not have an available outfacing web server, so a web service lookup > is not viable. > > Has anyone tried this? If so, what size and type of system are you on and > did the amount of data cause any issues? > > Right now, if they decide they want to go forward with this, is to put the > data into a separate table and/or database and customize the Remedy code > to pull from it. Again, any experience and/or advice on this is welcome. > > Thanks in advance! > > Kelly Logan > Cybernetic Solutions, Inc. > [EMAIL PROTECTED] > > > > ____________________________________________________________________________________ > Want to start your own business? > Learn how on Yahoo! Small Business. > http://smallbusiness.yahoo.com/r-index > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
