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 (JOracle

Re: Need help with oracledump (contributed program)

2003-09-02 Thread Doug Poland
to 0 --complete-insert Includes list of column names in insert statements I'm not a perl guy and I'm not sure what 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... --

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. > > >

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 t

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: http://w

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, Dou

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

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 g

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

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 f

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 PROTECTE

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... > > > > > > >

Re: newbie mysqldump problem

2001-03-08 Thread Doug Poland
another ISP running MySQL 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

Re: newbie mysqldump problem

2001-03-08 Thread Doug Poland
software comes with ABSOLUTELY NO WARRANTY. This is free software, ... ... blah, blah, blah... ... > > > Doug Poland wrote: > > > > Hi, > > > > I'm having a dickens of a time getting mysqldump to > > work. No matter what I enter, mysqldump says...

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: 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? > > >

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

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