Re: can create, cannot drop...?

2001-02-26 Thread Geoff Coffey
on 2/26/01 2:59 PM, G. Adam Stanislav at [EMAIL PROTECTED] wrote: At 09:11 26-02-2001 -0700, Geoff Coffey wrote: Errno 21 on my system is EISDIR -- 'is a directory', which doesn't seem to be an error at all... It is an error (that is why it starts with an 'E'). Appendix C of POSIX

Re: mysql Digest 26 Feb 2001 14:06:36 -0000 Issue 1161

2001-02-26 Thread bill
Hi... Is there a front-end available for Mysql. I am currently using Mascon as an administrative front-end, which is very good. However I need a front-end with less administrative features, something where-by users can create/edit/drop tables - therefore it has to be very easy to use. Try

problems with insert

2001-02-26 Thread jarle rudihagen
I got a mysql table with to collumns: imageID(integer) and imageData(blob). I'm using the mysql++ API. I can't seem to insert both the imageID and imageData into the table. When I'm just inserting the imageData(the blob field) it works out fine. But as soon as I try to pass both fields,

Re: XML interface to MySQL

2001-02-26 Thread bill
does anyone know of an XML interface to MySQL which would enable me to import or export data using the XML language definition? Try http://www.xml.com/pub/a/2000/12/13/perlxmldb.html (note that I have slept and done other things a few times since reading the above, but I think it discusses

mod_auth_mysql

2001-02-26 Thread Peter R. Wood - Mailing Lists
Hi all, Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? I have searched the list archives here and indeed turned up 254 instances of people having problems with mod_auth_mysql. From the sounds of it, it doesn't

Need help with select statement.

2001-02-26 Thread David Jacobowitz
Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;

Redhat 7.0 w BDB3 Compilation Error

2001-02-26 Thread Carl Petersen
Description: Compilation fails; probably due to a missing library. Alas, I'm unsure which one I would need. It's not one of the documented missing link libraries from the manual. Nor could I find it using the search engine on the mySQL site. The reason I'm attempting to build from the

Temporary tables, BDB tables, and Innobase questions

2001-02-26 Thread Stephen Faustino
1. Can temporary tables be of type BDB? Now before the question is asked as to why I need transactional support on a temporary table, let me first say that I really don't need it; this is just something we stumbled across during development. If we create a temporary table of type BDB and

mysql.user puzzler

2001-02-26 Thread pollyp
Hi, I'm deploying a solution that uses Mysql to a number of machines. Because I don't want to set passwords and shutdown access to anonymous users by hand on each machine, and because I don't want the security problems associated with having scripts with passwords in plaintext lying around

HELPPpp!!!please! Can't uninstall...

2001-02-26 Thread Michael Nathanson
I installed mySQL on windows 2000 pro. I am interested in using it for one of my sites. It has been causing some problems since I put it on my computer, and Every time I try to uninstall it, it wont let me – I get an error message. Please help me get it off my computer. Thank You.

Re: Temporary tables, BDB tables, and Innobase questions

2001-02-26 Thread Jeremy D. Zawodny
On Mon, Feb 26, 2001 at 05:52:09PM -0600, Stephen Faustino wrote: 3. I've read several posts regarding the Innobase tables. Where can I download the source from to start trying to use Innobase rather than BDB tables? They'll be in 3.23.24 when it is released. Or you can pull them from the

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Sun, Feb 25, 2001 at 10:37:10AM -0600, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data

MySqwl does not start (server)

2001-02-26 Thread Find4u
this is what happens [root@find4uls1 bin]# Starting mysqld daemon with databases from /var/lib/mysql 010226 13:12:22 mysqld ended [1]+ Done./safe_mysqld --user=mysql [root@find4uls1 bin]# ./safe_mysqld -user=mysql [1] 20057 [root@find4uls1 bin]# Starting mysqld daemon

Re: mod_auth_mysql

2001-02-26 Thread Jeremy D. Zawodny
On Mon, Feb 26, 2001 at 06:23:29PM -0500, Peter R. Wood - Mailing Lists wrote: Hi all, Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? Which one? There appear to be two. Go here and search for "mysql"

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player FirstNameJoe/FirstName LastNameMontana/LastName Average Team="49ers"not bad at all/Average /Player If you got to

Re: create table

2001-02-26 Thread Florian G. Pflug
On Sun, Feb 25, 2001 at 10:07:41PM -0800, Jeremy D. Zawodny wrote: On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING£¨Íõ¸Ö£© wrote: Anyone can give me an example of create a transactional table in V3.22.23? Thanks. 3.22(!!!).23??? This has IMHO no BDB-Table support. You need 3.23.xx -

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-26 Thread Florian G. Pflug
On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote: On Wed, 21 Feb 2001, Hagen Hoepfner wrote: I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Failed: Can't

Re: MySqwl does not start (server)

2001-02-26 Thread Atle Veka
it would be helpful to see the last lines of your error logs.. from this it's impossible to tell what's wrong ;) Atle On Tue, 27 Feb 2001, Find4u wrote: this is what happens [root@find4uls1 bin]# Starting mysqld daemon with databases from /var/lib/mysql 010226 13:12:22 mysqld

RH 6.1 problems with mysqld mysql_install_db

2001-02-26 Thread Jonathan Steinhart
Description: Unf... this all started on the weekend when *nothing* had ostensibly changed with my client's system, running vanilla RedHat 6.1. All of a sudden, all client connections (e.g. $mysql -p test) would simply hang forever on the password prompt. NOTHING. Tried mysqladmin, same thing. rc

RE: XML support under mySQL

2001-02-26 Thread Cal Evans
How is this superior to SQL? Why replace a great, stable and mature language for querying databases with a verbose one? Also, a database IS a huge archive of structured data. :) salutations, Cal http://www.calevans.com -Original Message- From: Florian G. Pflug [mailto:[EMAIL

Re: XML support under mySQL

2001-02-26 Thread Florian G. Pflug
On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: How is this superior to SQL? Why replace a great, stable and mature language for querying databases with a verbose one? Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. By

Re: please urgent

2001-02-26 Thread Rolf Hopkins
- Original Message - From: "webmaster" [EMAIL PROTECTED] To: "Joel Gwynn" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 6:13 Subject: please urgent I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 4.0, acording to the info for this

Re: HELPPpp!!!please! Can't uninstall...

2001-02-26 Thread Miguel Angel Solórzano
At 15:58 26/02/2001 -0800, Michael Nathanson wrote: Hi! If your uninstall problem is the MySQL service (the only one that I guessed). Please, do: Install again the MySQL stuff. Go at \mysql\bin and type the command line: mysqld-nt --remove Go to Control Panel and using the add/remove program

Re: MySqwl does not start (server)

2001-02-26 Thread Rolf Hopkins
It is most likely already running. Use ps -ef to find out. - Original Message - From: "Atle Veka" [EMAIL PROTECTED] To: "Find4u" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 8:43 Subject: Re: MySqwl does not start (server) it would be helpful to see the

RE: XML support under mySQL

2001-02-26 Thread Peter Skipworth
How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I had to say it =) And no, I'm not at all the cynical type...not I! P Why

Re: Need help with select statement.

2001-02-26 Thread David Jacobowitz
Thanks Rolf From: "Rolf Hopkins" [EMAIL PROTECTED] To: "David Jacobowitz" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Need help with select statement. Date: Tue, 27 Feb 2001 09:21:57 +0800 No it's not possible but you can just read in all tables anyway and ignore the columns you don't

Re: HELPPpp!!!please! Can't uninstall...

2001-02-26 Thread Rolf Hopkins
You haven't really provided us with enough information to help you. One suggestion though. You did stop the server before trying to uninstall, didn't you? - Original Message - From: "Michael Nathanson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 7:58

Re: GUI

2001-02-26 Thread Rolf Hopkins
Look up the manual on skip grants. - Original Message - From: "Dr J. Froggatt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 1:53 Subject: GUI Hi from the UK, Firstly just let me say how cool and NON microsoft MySQL is. It is a BRILLIANT PIECE OF

Having trouble to use array in SELECT statement.

2001-02-26 Thread David Jacobowitz
Hello, I have constructed an array using my table field names and trying to pass that array in the select statement. @inc_re = ( Hotels, Asian_Real_Estate, Smart_Buildings, Real_Estate, Senior_Living_Homes ); $quary = "SELECT @inc_re FROM incu_real_estate LIMIT 1"; But I am getting

Re: XML support under mySQL

2001-02-26 Thread Colin Faber
Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the greatest thing to come along since sliced bread. You folks need to keep in mind that with the microsoft system the XML layer IS NOT part of the database it self but an additional application which talks to the database via

Too many Aborted Connects

2001-02-26 Thread Chris Parker
Hi, We are getting too many Aborted_connects using mySQL version 3.22.32 on SunOS 5.8. Users connect to our site via an Apache/1.3.12 server to a PHP Verion 4.0.4pl1 website which connects to the mySQL database (which is on the same machine) via the PHP mysql_pconnect() command.

Re: problems with insert

2001-02-26 Thread Rolf Hopkins
I don't the language your using but it looks like you may have left out a comma. I find it difficult to know what is going on with your code without knowing the content of your variables. Could you provide us with the contents of strbuf, before it is passed to mysql!? - Original Message

Compile Mysql

2001-02-26 Thread WANG_KING
Hi, When I downloaded the source distribution of Mysql3.23.33. And I want to compile it. But in the first step I got an error: " checking whether make sets ${MAKE}... ./configure: syntax error at line 1: '(' unexpected" who can tell me why?

configure

2001-02-26 Thread WANG_KING
Hi, I want to compile mysql to make it support transaction bur when I exec . /configure, I got an error: "checking whether make sets ${MAKE}... ./configure: syntax error at line 1: '(' unexpected" who can help me?Thanks a lot!

Re: Having trouble to use array in SELECT statement.

2001-02-26 Thread Rolf Hopkins
A suggestion. I don't know what language you're using but try printing $quary to the screen before it is passed to mysql. If @inc_re is an array, as you say, then in a lot of other languages, you're next line would be an illegal statement. Even the first statement looks incorrect but I don't

array awry

2001-02-26 Thread Keith Spiller
This associative array embedded within a function and declared as a global at the start of the function, is meant to be a multidimensional array, but with every loop of the while ($myrow = mysql_fetch_row($result)) statement, it's previous values are replaced by the new ones. Any ideas on how

Re: Newbie DATESTAMP problem

2001-02-26 Thread Rolf Hopkins
Hi Ken, Welcome to the list. You'll get great help here, best support I've ever come across but you do need to do your own research first. Try reading the relevant sections of the manual again but a little more thoroughly this time. To get you started, you're mixing C code with SQL code. You

How to get MAX of each group after GROUP BY ?

2001-02-26 Thread S A
How do I do a single query to group a table by one column then get the row of say the highest of each group ? Data is like so : Album, City, Plays, Date Britney, NYC, 103, 1-10 Britney, SF, 101, 1-10 Eminem, NYC, 100, 1-11 Eminem, SF, 102, 1-11 So I want to GROUP BY Album, then get

Re: array awry

2001-02-26 Thread Rolf Hopkins
This is a PHP question and should really be asked on the PHP list. But a suggestion. Tried using field names instead of number? ie. $myrow["catid"]; I'd have to read up the PHP manual to find out for sure but I'm sure you can do that just as well as I can. - Original Message - From:

compile

2001-02-26 Thread WANG_KING
Hi, How to use gcc when compileing mysql3.23.33?I am using SCO openserver. And what to set to the $MAKE varibles when exec configure. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Configure error

2001-02-26 Thread RUMADI HARTAWAN
Hi Gurus, I've tried to configure mysql source distribution, but I've got following error message. My machine is Sun Ultra-2 running SPARC Solaris 2.6. What should I do to fix this problem? Thank you very much in advance. Yours sincerely, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

ask mysql.jdbc ?

2001-02-26 Thread Thuan Tran
is mysql.jdbc-1.2 the latest? which version of JDBC API included in mysql.jdbc-1.2 ? does mysql.jdbc-1.2 driver support with XA Datasource? I want to know to configure it in J2EE. thanks in advances - Before posting, please

Error: Out of virtual memory

2001-02-26 Thread Narvaez, Teresa
Hello, Sorry for the previous posting, please disregard. I just installed mysql 3.22.30 on Digital Unix system 4.0D; it works fine but when I exit out of "mysql" I get the error "xmalloc: out of virtual memory " . Is this an error to be concerned about? The

make

2001-02-26 Thread WANG_KING
Hi, I want to compile a mysql3.23.33 to support transaction. I passed the first step :./configure. But when I exec "make" to make file,it shows the follow message: (mysql323@pdsvr3):/usr/mysql323/mysqlsrc/mysql-3.23.33make No suffix list. cd include; link_sources sh:

RE: Having trouble to use array in SELECT statement.

2001-02-26 Thread Barry Radloff
Yes Rolf is correct I think this is actually a perl Q... because I assume that is perl you are using so you should declare the array as: @array = qw(bla bla bla bla lba); Secondly using the array in the select will not give the desired results because it will print out something like select bla

Question

2001-02-26 Thread
I am developing the Japanese web site with java(jsp) and mysql. I know that mysql supports the Japanese language. But I think that mysql doesn’t support some character of Japanese language. This is the part of the data that becomes the issue. Whenever I commit the above command,

<    1   2