Re: Problem with mysql++, Aborted (core dumped)

2001-04-15 Thread Mr.Y.SHIVAKANT
-Original Message- From: Luis E. Cruz Campos <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Monday, April 16, 2001 9:37 AM Subject: Problem with mysql++, Aborted (core dumped) >I am trying to prove a small program of test, but

Re: Problem with mysql++, Aborted (core dumped)

2001-04-15 Thread Andrei Cojocaru
I suggest you try the mySQL C API and see if that works first. -Andrei Cojocaru >From: Luis E. Cruz Campos <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Problem with mysql++, Aborted (core dumped) >Date: Mon, 16 Apr 2001 12:17:40 -0400 >MIME

Problem with mysql++, Aborted (core dumped)

2001-04-15 Thread Luis E . Cruz Campos
I am trying to prove a small program of test, but when trying to execute it this always it throws "Aborted (core dumped)", this happens at the time of making the connection: It is the program: #include #include #include "sqlplus.hh" cchar *user="sqluser"; cchar *pass="sqluser"; cchar *host=

RE: Does MySQL support sub queries ?

2001-04-15 Thread Yen
Thank you Jeremy, these really help!! I can't find the manual :D -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 4:00 PM To: Yen Cc: [EMAIL PROTECTED] Subject: Re: Does MySQL support sub queries ? On Fri, Apr 13, 2001 at 04:02:31PM +0800,

Query failing

2001-04-15 Thread List Box
MySQL is not giving expected results in queries: The table has a decimal field, 'tolong', with a 13 char size and 8 decimal places. I know from browsing that the table contains many records with 'tolong' values less than -120, as low as -124. The query select * from Tiger_main where tolong <

Re: default password?

2001-04-15 Thread Rolf Hopkins
As mentioned, if this is a new installation, drop the -p ./mysqladmin -u root password 'new-password' If this doesn't work, look up the manual about skip grants and then try changing the password. - Original Message - From: "David Loszewski" <[EMAIL PROTECTED]> To: "Cal Evans" <[EMAIL P

Re: www.kwwda.org

2001-04-15 Thread Andrei Cojocaru
I suggest PHP it's the easiest to learn. >From: "Rolf Hopkins" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: www.kwwda.org >Date: Mon, 16 Apr 2001 09:57:15 +0800 >MIME-Version: 1.0 >Received: from [192.58.197.162] by hotmail.com (3.2) with ESMTP id >MHotMailBCA3

Re: www.kwwda.org

2001-04-15 Thread Rolf Hopkins
Your first step is that you are going to have to decide what language you want to use: PHP, Perl, C, Java, ASP, etc.. The next step is to read the appropriate manual/s for that language together with the webserver's documentation. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAI

Problem - Possible Bug?

2001-04-15 Thread Andrei Cojocaru
Every few mins (2-15min) mysqld crashes with a signal 11 (SEGV). I am running FreeBSD 4.2 with mysql 3.23.36, I used to have 3.23.32 it had the same problem, I upgraded to 3.23.36 today and it had the same problem. I have recompiled mysql in full debug and done a stack trace and it keeps on cr

Re: Need feedback

2001-04-15 Thread mysql
Hi all, Thanks for the feedback and based on what I read, I will be keeping the sites up for at least a few more months. I would like to see decent use of the site so tell people about them. That will be my determinining factor when I rethink the sites in June or July. They are free and do

Re: Redirecting Outfile

2001-04-15 Thread Tonu Samuel
On 14 Apr 2001 16:55:51 -0300, Brian Cassidy wrote: > Redirecting file output (for user bpc) with a command such as > select * into outfile 'home/bpc/test.txt' from table > gives the error ERROR 1: Can't create/write to file > "/home/bpc/test.txt" (Errcode: 13). The documentation > recommends sett

Re: Too many sleepers?

2001-04-15 Thread Tonu Samuel
On 14 Apr 2001 23:30:51 -0400, Gary Huntress wrote: > I've noticed, by doing "show processlist", that a few users end up with > dozens (sometimes 50) sleeping processessome are 4 hours old. What is > this typically caused by? I believe that most of my users connect using > php, and I belie

compiler problem with C++ API

2001-04-15 Thread mysqlweenie
Hello, When using Visual C++ or Delorie DJGPP (under windows 2000) compilers and compiling the following example: #include #include #include #include #include int main() { Connection con("stw"); return 0; } I always get the following errors related to the mysql_com.h he

Re: Can't build mysqlgui-1.7.5

2001-04-15 Thread David Relson
At 11:42 AM 4/15/01, Sinisa Milivojevic wrote: >David Relson writes: > > Greetings, > > > > mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the > > output when I try to make it. > > > > [relson@osage mysqlgui-src-1.7.5]$ make > > make: *** No rule to make target `edfile.o', neede

Re: Auto_Increment

2001-04-15 Thread Roel Vanhout
On Sun, Apr 15, 2001 at 08:20:10PM +0100, Jamie S Buchanan wrote: > And what exactly are myISAM and ISAM tables? http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Table_types > (a quick web search gave me: -the Information centre for South African Music >

mysqlgui: help.

2001-04-15 Thread mario . lat
I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what passw

Re: Propagating a Table

2001-04-15 Thread Aigars Grins
> ... my problem is I want 3 images to appear in any one row in the table. > Subsequent images I want to start in the next row down, subject to a limit > of 3 and so forth. Some naive and simplistic 'pseudo' code: int current = 0, max = 3; print_table_row_start(); while (sql_row = get_sql_row

Auto_Increment

2001-04-15 Thread Jamie S Buchanan
Hello, I wonder if you can help me. For a university project I've got a database with several tables using columns set up with 'auto_increment'. I've discovered that the value that the system creates for a new record is one greater than the largest one which has existed even if the records wit

Re: how to get average value for top n records?

2001-04-15 Thread René Tegel
select sum(a)/3 from atable order by record_id desc limit 3; - Original Message - From: "Kevin Xin Lin" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Sunday, April 15, 2001 9:04 PM Subject: how to get average value for top n records? > Hi, if I have a table with only one fie

how to get average value for top n records?

2001-04-15 Thread Kevin Xin Lin
Hi, if I have a table with only one field A like this: record#1: 2 record#2: 3 record#3: 2 record#4: 4 record#5: 6 record#6: 8 How to write a sql statement to retrieve the average value of field A for the last 3 records? Did I make sense here? Thanks for help. -

Propagating a Table

2001-04-15 Thread Steve Lowe
Hi, I have MySQL 3.23.xx and PHP4 I am using a code to return images that puts them in a table. The search works fine. It selects an image and returns it fine. However, when more that one image is returned:. ... my problem is I want 3 images to appear in any one row in the table. Subsequ

Bug fix for FreeBSD and other non-Linux users of InnoDB (= Innobase)

2001-04-15 Thread Heikki Tuuri
Hi! The performance problems some users reported on FreeBSD for InnoDB may have been caused the signal 14 bug already known for the Solaris port. The fix and a patch file for 3.23.36 can be found at www.innobase.fi. This is fixed also in upcoming 3.23.37 which may be out on Tuesday. Happy East

problems with configure

2001-04-15 Thread André Estel
Hello, i mail you from germany, so please excuse my "special" english! I just want to compile mysql 3.23.36 under Debian Potato for use with PHP(classic LAMP). But get the following error: configure:8016: checking for tgetent in -lncurses configure:8035: gcc -o conftest -O6 -DDBUG_OFF -rdyna

Re: Outer and left join definition

2001-04-15 Thread Bob Hall
>bob... > >your example does not appear to work for me. maybe i'm missing >something? i created two tables simply as: > > create table test1 values (id int); > > create table test2 values (id int); > >and populated them with some matching and non-matching data. however, >when i run the

Re: Can't build mysqlgui-1.7.5

2001-04-15 Thread Sinisa Milivojevic
David Relson writes: > Greetings, > > mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the > output when I try to make it. > > [relson@osage mysqlgui-src-1.7.5]$ make > make: *** No rule to make target `edfile.o', needed by `mysqlgui'. > Stop. > > I've checked and there are so

Re: How to install mysql-3_23_36-win OR mysql-3_23_36-win-src?

2001-04-15 Thread Gerald R. Jensen
Rosy: The source code (src) is for those who wish to compile and install their own. Unless you know what you are doing (and have the compiler/development tools), forget the source. You want the binary version, which is mysql-3_23_36-win (about 9.6mb). Just unzip it, run the SETUP.EXE, and read t

Can't build mysqlgui-1.7.5

2001-04-15 Thread David Relson
Greetings, mysqlgui-1.7.5.tar.gz appears to be missing source files. Here's the output when I try to make it. [relson@osage mysqlgui-src-1.7.5]$ make make: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. I've checked and there are source files corresponding to each of the O

Re: Outer and left join definition

2001-04-15 Thread Kris Gonzalez
bob... your example does not appear to work for me. maybe i'm missing something? i created two tables simply as: create table test1 values (id int); create table test2 values (id int); and populated them with some matching and non-matching data. however, when i run the query: s

RE: Help!!

2001-04-15 Thread Don Read
On 15-Apr-01 ªüÂ× wrote: > $result=0; > $query="select * from users where user_id='$user_id'"; // why fetch all the fields to test an "exists" ? > $result=mysql_query($query,$link); // where's the test, in case it failed ? > if(mysql_fetch_row($result)) $result=1;

Re: www.kwwda.org

2001-04-15 Thread Yusuf Incekara
try http://www.avukatpro.com/mysql.html mysql & asp section. if you use asp - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 15, 2001 10:01 AM Subject: www.kwwda.org > DEAR sir, > I WANT TO connect mysql database to my web site www.kwwda.org.i