Re: Need help with oracledump (contributed program)

2003-09-02 Thread Doug Poland
to make of it other than the variables $nls_date_format, $nls_time_format, $nls_timestamp_format have data at run-time. Thanks again for your help so far... -- Regards, Doug Marty Gainty - Original Message - From: Doug Poland [EMAIL PROTECTED] To: Jim Smith [EMAIL PROTECTED] Cc

Re: Need help with oracledump (contributed program)

2003-09-02 Thread Doug Poland
On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote: A TNSNAMES file isn't going to help unless you have the Oracle client software installed. If you had the software, you would already have a tnsnames file. Thanks all for your help. I've found a free java-based application

Need help with oracledump (contributed program)

2003-09-01 Thread Doug Poland
Hello, I'm trying to figure out how to use the contributed program oracledump in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle dump command seems to be looking for a SID in a file called

Re: Need help with oracledump (contributed program)

2003-09-01 Thread Doug Poland
On Mon, Sep 01, 2003 at 01:03:48PM +0100, Jim Smith wrote: I'm trying to figure out how to use the contributed program oracledump in an environment where I don't have a login to the *nix host running Oracle. All my connectivity to the Oracle host is via port 1521 and JDBC. The oracle

Re: MySQL Book

2002-01-07 Thread Doug Poland
D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1 -- Regards, Doug - Before posting, please check:

Re: importing from text base file with | delimiters

2001-12-14 Thread Doug Poland
On Fri, Dec 14, 2001 at 03:16:56PM -0800, Phillip B. Bruce wrote: Hi, How can I import a text file database in which delimiters are | character field separated into mysql database? Crack open the manual and look for the section on *load data*. The answer is there... -- Regards, Doug

Re: ERD

2001-11-30 Thread Doug Poland
On Fri, Nov 30, 2001 at 12:15:26PM -0500, Won Lee wrote: Anyone know a good ERD program that will also interact with MySQL to write the CREATE scripts? As usual open source would be nice, also running on a win2k workstation. I used to use PowerDesigner. Nice software but too expensive.

Re: Client-side developing

2001-09-25 Thread Doug Poland
On Tue, Sep 25, 2001 at 02:50:09PM -0700, Rodney Broom wrote: From: Walter Omar Autalán [EMAIL PROTECTED] I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in

Re: Mysql Fulltextsearch

2001-09-13 Thread Doug Poland
On Thu, Sep 13, 2001 at 02:17:51PM +0200, Sergei Golubchik wrote: On Sep 07, Doug Poland wrote: On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables

Re: Mysql Fulltextsearch

2001-09-07 Thread Doug Poland
On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote: Lorang Jacques ([EMAIL PROTECTED]) writes: Now I was wondering if it would get faster by using FULLTEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster

Re: Mysql Fulltextsearch

2001-09-07 Thread Doug Poland
On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote: Do the current limitations of 500 characters per index and limited (?) number of columns per index pose problems? I want to use fulltext on a database with 7 varchar(255) columns and several smaller varchar columns but can't build

RE: Does anybody know the formula to convert difference of time in decimal

2001-04-06 Thread doug . poland
I like to work with times as follows: if 1 second = 1 / 86400 or 0.12 then 12 hours = 0.5 24 hours = 1.0 36 hours = 1.5 48 hours and 1 second = 2.12 and so on. Regards, Doug -Original Message- From: lkeeton [mailto:[EMAIL

Re: newbie mysqldump problem, SOLVED!

2001-03-09 Thread Doug Poland
Doug Poland wrote: Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument The problem was the ~/.my.cnf file. I took

newbie mysqldump problem

2001-03-08 Thread Doug Poland
Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument I've perused the list archives and looked at the manual. It should work but doesn't. What am I doing

Re: newbie mysqldump problem

2001-03-08 Thread Doug Poland
and I have the same result :( However, on my local box, it works just fine. Anyone know what's going on? -- Regards, Doug Doug Poland wrote: On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote: mysqldump --databases db1 db2 db3 ... Note, these are complete

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
On Wed, Feb 21, 2001 at 01:26:56PM -0500, Michael Bacarella wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride.

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
Gorjan Todorovski ([EMAIL PROTECTED]) writes: Is there support for XML in mySQL? This is a reasonable inquiry. MS-SQLSever 2k and Oracle are both implementing a lot of XML functionality in their RDBMS's. Oracle is ahead of SQLServer, I believe. Like it or not, these two RDBMS's are

Re: XML support under mySQL

2001-02-21 Thread Doug Poland
On Wed, Feb 21, 2001 at 05:22:31PM -0500, Michael Bacarella wrote: XML will become a common and powerful way to express/exchange data on the web. I hope MySQL decides to go along for the ride. This is all fine and good, but why does MySQL itself have to do this? We don't