I am developing an app that gets a zipcode from a user and then uses that zipcode to find the nearest store locations in miles based on the stores zipcode. I have a database that has all the zipcodes with there corresponding latitudes and longitudes. I also have a calculation that computes dista...
I'm building a store locator type of application and need to find a database which contains all zipcodes in the US along with the associated longitude and latitude information (needed to calculate distances). Does anyone know where I might be able to purchase the data that can then be co...
Hello,I downloaded the sqlitedll-3_2_7.zip file the other dayto do some initial experiments with SQLite, but it turnsout that this zip-file only contains the DLL itself andthe definitions file.If I understand it correctly, it is possible to linkagainst the DLL using that definition file, but it...
Database & Application Miscellaneous New questions
whenenver I try 2 zip up my db(.mdf) file , it givz an error. I can't even copy it to another folder.Do I uncheck the archive in the file properties ?...
What could cause an mdb to have 0% compression when zipped. I import all the tables into a new mdb and get 90% compression when zipped. THe following thread might describe better:http://www.vbforums.com/showthread.php?s=&threadid=195699THanks for any help!...
Does anyone have an Access table with City, State and Zip Codes that I could bum off ya? Need one to include in my donor mailing list program for my church.Thanks,Rev. Michael L. Burns...
I want to create a database of office locations that can be searched based on zip codes. Does anyone know where I can get zip code and/or longitude/latitude data, and how to process it....
Where can I obtain, a listing of city/town, state and Zip codes for the US?Is it available for download and in an excel format or a dbase format?Thank youLeonard...
what does the function ZEROFILL do?I got a int(10) field that is unsigned in a mysql table... when i make the field zerofill - it adds 0... eg. 1 becomes 0000000001Is that the only function it has?Thanks!...
Hi,When I use the statistics collector to see the number of I, I always getzero in almost all of columns. I really want to know the reason for that.The result of statistics view:# select * from pg_statio_user_tables; relid | schemaname | relname | heap_blks_read | heap_blks_hit |idx_blks_read |...
We need the output of EXPLAIN ANALYZE, from both versions if possible.Also, pgsql-performance would be a better list for this Tue, 25, 2005 at 05:31:22PM -0600, Sidar L?pez Cruz wrote:what happend with postgresql 8.1b4 performance on query?look at this:select count(*) from fotos where archivo no...
Can any one tell me how to save 'Nothing' to a Date field in a recordset.Senario;A date has been saved to a Date Field, thus changing the field from Null. The date is then not needed and deleted from the corresponding textbox object bound to the field. If I leave the textbox empty I ge...
Database & Application Miscellaneous Related Categories