Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by julietsstars
-
Locator - zip working, state and city are not
Thats fine! You've been a wonderful help. One last question, does it "look" like it should be working properly? I will go through the link you sent and talk to IT again. But again, I do appreciate your help.- julietsstars
- Post #14
- Forum: Perl
-
Locator - zip working, state and city are not
Here is the Controller calling up Zips: package WeilMclain::Controller::ContractorLocator; use strict; use warnings; use base 'Catalyst::Controller'; =head1 NAME WeilMclain::Controller::ContractorLocator - Catalyst Controller =head1 DESCRIPTION Catalyst Controller. =head1 METHODS =cut...- julietsstars
- Post #12
- Forum: Perl
-
-
Locator - zip working, state and city are not
Oh yes. those are the "zips_backup". I forgot they were referenced in the above "add columns" The complete list is: zip_code zip_type city_name city_type state_name state_abbr latitude longitude- julietsstars
- Post #9
- Forum: Perl
-
Locator - zip working, state and city are not
Oh really? I thought that was the only bit correct. The columns in the "zips_backup" table are: zip_code city_name state_name state_abbr latitude longitude- julietsstars
- Post #7
- Forum: Perl
-
Locator - zip working, state and city are not
Thanks Steve! Here is the bit of code I think is incorrect sub get_zip { my ($self, $city, $state) = @_; #return undef unless ($city && $state =~ /^(\d*)$/); if (my $zip = $self->single({city_name => uc($city),state_abbr=>uc($state)},{columns => [qw/zip_code/]})) { return...- julietsstars
- Post #5
- Forum: Perl
-
Locator - zip working, state and city are not
No, I wrote it correctly. It reads: "zips" became corrupt so I changed the perl script to pull from "zips_backup". We had a backup table of "zips" called "zips_backup" in case we ever lost our zip code information. Now, my saying corrupt was the wrong term to use. When numeric was changed to...- julietsstars
- Post #3
- Forum: Perl
-
Locator - zip working, state and city are not
Hope someone is familiar with this. Server: Apache Database: Postgre SQL Issue with zips. In my postgresql I had two tables one titled "zips" and the other "zips_backup". "zips" became corrupt so I changed the perl script to pull from "zips_backup". The locator works great when searching by...- julietsstars
- Thread
- Replies: 14
- Forum: Perl
