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 ?
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...
Hello!I have a project where I need to create a dentist search by zip code in our city. The search menu just has all the zip codes and when you select your area, all the dentists that are registered with the site (that are in that zip code) show up. I would like to kill two birds with one ston...
I got a free zip code file from the US gov. It is from the 1990 cencus. I want to offer a search on my site quite abit wider than most zipcodes, say 30 miles from the zip. All the searches would be in the US, and the file has the longitude and latitude for each zipcode. This looks like it sh...
Database & Application Miscellaneous New questions
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....
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!...
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 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...
In Access, when you use SQL to modify a table, it throws:"You are about to append # row(s)" Is there a way to grab that? Will standard error handling do it or some way to put the SQL into a "quiet" mode or something......
I'm using CompactDatabase method in unload event of MDI form in my project. It's time consuming operation, and I'd like to show something to the user (animation, progress bar...) during this process. Is there any way to yield Compacting somehow to perform some other tasks?Thank yo...
Will anyone ever get tired of tracking down the proper form the date portion of an SQL string should take. Well I've got one now that is part of the Insert and don't have a whole lot to go on. The File that is being written to is called xxxx.dbf. It will open in VisualFoxPro but I was...
Ok,I'm programming on a server where magic_quotes_gpc is on and there is nothing I can do about that.I've got pages add_news.php4, preview_news.php4 and news_to_db.php4 I know I could do it with less than three files but that's the way I like it.add_news.php <--> preview_new...
Database & Application Miscellaneous Related Categories