Page 1 of 1

Write From Database

Posted: Fri Sep 07, 2012 1:31 pm
by Nate
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!

Re: Write From Database

Posted: Tue Sep 11, 2012 5:53 am
by webmaster
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.