Query database table & ZIP results to download

HiI'm just wondering if it's possible to run a query on the table from within a PHP script, and then zip the results and then start to download the zip file.example...select * from table_name where userID = 'joe blogs' AND date = '11/10/2006'The user is selecting the date of the data they want to do ...

Backup database to zip file?

Please help me how to make a zip file from a folder, for instance i want to make folder named db1 become db1.zip????Please....thanx all! ...

zip codes for database?

generating a review database that is dependent on the closest city and I want to set it up based on zip codes rather then trusting the users to spell/enter the city correctly.anyone have an idea on how to obtain/generate a database of zip codes/cities for the US OR, how to query another site (www.us ...

MySQL How to export file to .zip format

How to export the database to zip format.I have written for .csv and .Xls formats.I want to give .zip option.How I have to write this. Query for various formats: SELECT * FROM export INTO OUTFILE 'D:/export.csv' fields terminated by ','; SELECT * FROM export INTO OUTFILE 'D:/export.xls' fields termi ...

MySQL Zip Code Radius Search

I am working on a ZIP Code Radius search engine and I need to know if I have the syntax correct: (Lines 21-22) <?php // at first the mysql connection $connect=@mysql_connect("localhost", "zip_codedb", "Zip_Codedb") or die("Cant connect to Database"); @mysql ...

Inserting Zip Codes that start with 0

This question has probably been asked several times before, but here it goes again:I'm trying to get my program to enter a zip code starting with a 0 (zero) into the database, but MySQL refuses to include it in the database. The zip code ends up being just four numbers without the zero in front. How ...

ZIP+4 zipcodes

Does anyone know a free usps database of zip+4 zipcode/address matching. Ruy ...

Zip Code approximation

Does anyone have any idea how to do something like thisI have an application where a user can search for people that live near them with a drop down box<select><option value="1">whithin 10 miles</option><option value="2">whithin 10-50 miles</option> ...

Zip Code Script with Longitude and Latitude

I have converted an Access Database Of Zip Codes, City, County, State Name, Longitude, Latitude, Time Zone, Area Code and so on... to a MySQL database.Now the tough part, applying it to my site. One part of the site I am working on is a classifieds listing application. ------------------Problem :--- ...

phpMyadmin restore database error

i just have this error when i import my backup database :You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.one week later i export my database as zip file by phpMyadmin but when i restore it error hap ...

Validate Area Code is in Zip Code

I have been searching the net for anything pertaining to the following issue:When a user enters their zip code, I need to verify that the area code (that they enter when they enter their phone number) is in the range of the zip code. I know I can run into issues with cellphone numbers, but at this p ...

"Find a dealer near you..." or ZIP Code Patterns

I'm finishing up a site for a furniture warehouse. They will have a directory of dealer's available on their site, and would also like a "Find a Dealer Near You" function where users enter a ZIP code to have a list of dealers near them returned.I've contacted the United States Postal Servi ...

Creating a ZIP file from VB

I want to backup a database in .ZIP form from within a VB app. Does anyone know how? ...

How to restore an Oracle XE Database without online logs and SPFILE?

My laptop was crashed last week and I was able to get only current datafiles without two online logs files and SPFILEXE.ORA from my old hard drive. I've installed with the same version of Oracle Database 10g Express Edition Release 10.2.0.1.0 software on Windows XP Pro. I have DATAFILEs from my old ...

Oracle 9i downloaded but installing only client

So that we may better diagnose DOWNLOAD problems, please provide the following information.- Server name- Filename- Date/Time- Browser + Version- O/S + Version- Error Msg I 've downloaded 3 zip files for oracle 9i BUT while installing , it is installing only Oracle 9i Client NOT database.Seems zip f ...

ERROR XSDB4

We are using Derby in a standalone application integrated in a webserver environment (EmbeddedDriver). Since now we hardly had any trouble with Derby, in the last few days we got some clients with broken databases. Our logfile tells:ERROR XSDB4: Page Page(4,Container(0, 1040)) is at version 23, the ...

Script Help

I'm having some problems with this code. Logging in when already in the database results in my error message ( that you are not in the database or your are not validated yet (this is not so). Also, all the fields from the membership form do not go into the database: gender, zip code, and country are ...

Export Users and Passwords from 9i

I am trying to upgrade to 10g but the scripts are not working correctly, but thats a different issue!I have created a blank 10201 database and I want to import our application into that, which I can do fine.However, I need to export all the users and passowords as we have about 2000 users across 60 ...

java.lang.UnsatisfiedLinkError

I'm getting the following error-->java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.pathjava.sql.SQLException: No suitable driverWhen trying to connect to a database.db2java.zip is clearly in the CLASSPATh when I'm starting up Tomcat.I found an IBM article saying t ...

Multiple like results from query?

I am trying to query the database for zip codes and get multiple results even though the zip code is specific. I can get multiple results if I don't enter the full zip code but I need them to enter the full code.Example:I query the database for zip code 80537. When submitted I need it to show all zi ...

need help totaling 2 records????

Ok I am not the greatest w/ writing SQL statements for Access. I am using Dreamweaver and Access 2007 I have a DB that was written by a 3rd prty company that tracks race results. Here is a link http://www.bigfootdesigns.com/mrp2/database/db.zip to a dummy setup in that DB. The idea is that once the ...

decoding a url-encoded message

HiWe have a requirement to LOG non-xml(url-encoded) message to database.As MPGW request and response types are non-xml, requests and responses pass thro' DP are not seen in probe.For this purpose,we have written a decode XSL to decode request and log to databasePFA zip file with encoded.xml for samp ...

Oracle Downloading 10G

I dowlnoaded the Oracle database 10g twice now. Everytime I unzip the dowload file I receive an errormessage : D:\oracle\dowloads\10g\database\10g_win32_db.zip: The archive is corruptNot all files are corrupt.Is it possible that the zipfile on the Oraclesite is corrupt?Kind ...

MSSQL charindex HELP !

I am pretty new to MSSQL and have a problem. The solution is probably very simple but I cant find it I have a database field ZIP, I also have string with consists of a number of UK part postcodes eg 'S10 S11 S7 S17 S8 S3 S30'I want to perform a SELECT check if the database field ZIP is in the string ...

location based code...

I am curious how I would go about doing two things on a site I am thinking of creating...First, is to have some code that detects where a user is based on their IP - I know this is not infallible, for numerous reasons, but it would be nice to have a zip code or city/state auto selected for the visit ...

WinZip and Shell

I'm working on an Access 97 database project that may not have a network available when it's implemented. To handle updates, I've been looking into replication. What I would like to do is, without user intervention, close and zip the data database and Zip it. I've been trying the posted command line ...

Oracle Select statement with a list in the where clause

I need to know how to form a sql statement with a list of values as the where clause. Additionally, The values in the list will be slightly different from the values in the database and I can't figure that part out either. To be more specific:I am writing a VB executable where the user will click on ...

Ubuntu iptables & geoip

Ladies & Gents,I've hit a brick wall and would like some help please...Overview:I would like to set iptables to allow the geoip mode/method.EG. iptables -A INPUT -m geoip --src-cc XX -j DROPError Message:iptables v1.3.1: Couldn't load match `geoip':/lib/iptables/libipt_geoip.so: cannot open shar ...

Ubuntu Business Search

I am working on a research project that wants to find all of a specific kind of business and put it in a database with zip codes for the entire country. So for example say I wanted to find a list of all Beer Distributors in the United States, what could I use to find this? I was trying to find an AP ...

Basically Clueless?!?!?!?

I am attempting to install a counter to record the number of downloads for zip files on my site... example-- layout.zip, blue.zip, green.zipi have never used SQL before and hate to admit that i am totally clueless about how this works--i did manage to find the SQL on hosting site and have set up a d ...

Oracle cannot download 10201_database_linux32.zip file

I try to download 10201_database_linux32.zip, but download cannot start. I can download different file and documents. is there any problem this site: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201linuxsoft.html Best ...

Oracle Installing "10201_database_linux32.zip"

When I tried to install "10201_database_linux32.zip," errors just like below came out and Icould not install "Oracle Database 10g." Does someone know the solution?respects,MattException in thread "main" java.lang.UnsatisfiedLinkError: /tmp/OraInstall2005-10-12_06-01-37AM/jre/1.4.2/lib/i386/libawt.so ...

Oracle download 10201 Database_win32.zip 10.2.0.1.0 errors

File Database 10.2.0.1.0 unexpected end of archive ...

Oracle [help]2 files in my downloaded 10201_database_win32.zip pack is damaged

10201_database_win32.zip:database\stage\Components\oracle.javavm.containers\10.2.0.1.0\1\DataFiles\filegroup5.jar (Size:25m)10201_database_win32.zip: database\stage\Components\oracle.jdk\1.4.2.0.8\1\DataFiles\jre.1.1.jar (Size:20m)The above two files in my zip pack cannot be unpacked, who can send t ...

Oracle Unpacking 10201_database_win32.zip

During unpacking the 10201_database_win32.zip file (Oracle 10g Relase 2 for Windows), I get a problem with the following 4 files:database\stage\Components\oracle.bali.jewt\4.2.33.0.0\1\DataFiles\jewt.jardatabase\stage\Components\oracle.network.client\10.2.0.1.0\1\DataFiles\filegroup25.jardatabase\st ...

Oracle Release 10.2.0 (10201_database_win32.zip)

I was trying to download the Oracle 10g database for Release 10.2.0. I am able to download the file, but when I go to unzip the file I receive the following error message: Cannot open file: It does not appear to be a valid archive. If you downloaded this file, try downloading the file again.Can some ...

Oracle 10201_client_linux32.zip FAILS INSTALL ON REDHAT ES 4.0

I'm installing 10201_client_linux32.zip on a Red Hat Enterprise Linux ES release 4 (Nahant Update 4) server. The graphical tool says that all requirements are met. At end of install, the inventory log shows a failure ( included below).What will it take to get this 32 bit client package on this Red H ...

Oracle 10201_database_linux32 corrupted?

Another file:10201_database_linux32.ziphosed. same messages as others -- not zip or corrupted.rats ...

Can I install Oracle 10201_database_linux32 on Fedora Core 4?

Here are my system data (according to Oracle Quick Installation Guide):[root@localhost dan]# grep MemTotal /proc/meminfoMemTotal: 1555628 kB[root@localhost dan]# grep SwapTotal /proc/meminfoSwapTotal: 2031608 kB[root@localhost dan]# freetotal used free shared buffers cachedMem: 1555628 1515212 40416 ...

Oracle Why I cannot install 10201_database_win32-0.zip on window XP(32bit)???

I download 10201_database_win32-0.zip , but I cannot install it,My installation procedure as follows:1. unzip it to C:\DOCS\Database\Oracle-10g\database2. setup: C:\DOCS\Database\Oracle-10g\database\setup.exe3. Oracle Universal Installer window popup, 4. Oracle 10g GUI displays: ask for: Main Direct ...

Ubuntu Oracle linux.x64_11gR1_database_1013.zip installation problems

I want to install Oracle Database 11g Release 1 (11.1.0.6.0)for Linux x86-64 linux.x64_11gR1_database_1013.zip (1,913,850,002 bytes) (cksum - 2681017561).I am using Desktop ubuntu 8.10.Linux ubuntu 2.6.27-11-generic #1 SMP Wed Apr 1 20:53:41 UTC 2009 x86_64 GNU/Linux.But when I look here http://www. ...

Oracle unzip linux_database_file.zip

Greetings - I've downloaded the 11g database zip file and placed it on my server (Linux x86 64) and when Iattempt to unzip the file I get something like this...checkdir error: cannot create databaseunable to process database etc etc.This repeats about thirty times and stops.Any ideas ?BrianEdited by ...

Oracle How to use linux_11gR2_database_1of2.zip

I downloaded the 32 bit 11g files disk1 and disk2 but unzip says that linux_11gR2_database_1of2.zip is not a proper zip file. The FTP to the server was done as binary and I redownloaded disk1 to ensure that it was not corrupted in the download.How do you unzip these files properly? File 2 is recogni ...

Oracle Cannot unzip 10202_database_solx86.zip

Downloaded 10202_database_solx86.zip to Solaris 5.10 x86 server (32bit architecture).Tried unzip 10202_database_solx86.zipArchive: 10202_database_solx86.zipEnd-of-central-directory signature not found. Either this file is nota zipfile, or it constitutes one disk of a multi-part archive. In thelatter ...

Oracle linux.x64_11gR1_database_1013.zip installation on ubuntu-8.10

Has any body succeed the installation of linux.x64_11gR1_database_1013.zip on ubuntu 8.10 ?I need help for the installation. ...

Oracle 10201_database_win32 corrupted?

10201_database_win32.zip10.201 for windows appears to be corrupted. I've tried to download it (different networks) repeatedly. Each attempt at unzip produces message:"...either not in standard Zip file format or corrupted..."Any suggestions? ...

Oracle 10201_database_linux_x86_64 Redhat AS 4 update 4

I am having some problems installing Oracle 10 on Redhat AS 4.4 64 bitThe version of Oracle I am attempting to install is Oracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64I am getting the following error when installing. INFO: chmod 751 /home/oracle/oracle/product/10.2.0/db_1/bin/ctxlcINFO ...

Oracle DB (10201_database_linux_x86_64.cpio ) installation on RHEL 5 64 bit

I am installing 10201_database_linux_x86_64.cpio (64-bit) on RHEL 64 bit OS.Running runInstaller i am getting the below error.Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-27_06-18-35AM. Please wait ...[oracle@]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: ...

Oracle 10201_database_win32 Installation

I had download and installed the 10201_database_win32 from the Oracle homepage. All I got is everything in Japanese. Maybe because my OS is Japanese? How do I set it to install in English. I have tried to look for the langague settings but I find the navigation difficult because its in Japanese. Is ...

Oracle 10201_database_linux_x86_64 installation error on Fedora Core 5 (AMD 64)

I am new to FC 5. When Start runinstaller i am getting following error .I am using latest Fedora Core 5 (AMD 64) with 3GB RAM. Please help me.Exception java.lang.UnsatisfiedLinkError: /tmp1/OraInstall2006-07-24_06-50-48PM/ jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No ...