Write From Database

Questions and answers about anything related to Helium Scraper
Post Reply
Nate
Posts: 4
Joined: Tue May 22, 2012 6:30 pm

Write From Database

Post by Nate » Fri Sep 07, 2012 1:31 pm

I am using the premade "write from database" to grab some information relating to specific zipcodes. Unfortunately, helium scraper takes any zipcode that begins with a "0" (such as 08358- Cherry Hill) and drops any zero before the first significant number (08358 -> 8358, 00217 -> 217, etc.).

How can I force the database to always include the necessary digits when running a query?

Thanks!

webmaster
Site Admin
Posts: 521
Joined: Mon Dec 06, 2010 8:39 am
Contact:

Re: Write From Database

Post by webmaster » Tue Sep 11, 2012 5:53 am

Hi,

Did you set your zip code column data type to Integer or any other numeric type? Try recreating the table and setting it to Memo or Text instead.
Juan Soldi
The Helium Scraper Team

Post Reply