I've been looking for a database that tells you what state and county a zip code is in. I saw one that was free a long time ago, but I don't remember where it is. Anyone know where I can find one?
Is it me or is the logging for the -zo option more cryptic than in previous versions of Sybase? We have the option turned on for a client running the 9.0.2 version and it has timestamps and seems much more readable. Am I missing something?...
Hi everybody. I have a simple problem (I hope). I would like to activate a script as soon as I change the record USING THE WHEEL in a mouse. For me it is essential to use the mouse (wheel) to go from one record to another one very quickly. When I change the record, the layaout contains a table with...
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...
That zipinfo.com is for "paying customers". I don't know if that meanssubscriptions or what.I found a great website for inexpensive developer and marketing listsfor zip codes.http://www.listfactor.comThey have lists for united states zip codes, cities, and counties. Ineeded the counties and...
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...
I am using VB6 accessing as SQL Server 2000 Database.In my VB app I convert my dates to longs and store themin the SQL Server DB.I thas now come to attention that the zero date in VB6 is 30/12/1899, but in SQL Server 2000 it is 01/01/1900.Is there a way to set the zero date in VB6 so that it mat...
I am checking out the zen-cart.In zen-cart, I can set up it with English, German, and French etc.But the countries table is in English only.So if I am in French interface, the drop down menu for the countries is still in English.I am not intending to use zen-cart in my project, but I would like...
Hello everyone,I have a cups problem (S Suse SLES9 SP3). When printing labels (we usethe application SAP and the application sends the labels one by one) ona zebra labelprinter (Z4Mplus), the printer stops after every print,"resets" itself and starts printing the next label.Especially when users...