Re: Possible bug?

2002-05-22 Thread Robert Vetter
Hi Egor, Thanks for your reply. > What table was deleted? report_YYYMMDD? Yes. > RV> MySQL Log file says nothing. > > Nothing about table delete or nothing about error? Nope. Robert Vetter Internet Application Developer Kontor23 GmbH Ottenser Hauptstrasse 56-62 22765 Ha

Possible bug?

2002-05-22 Thread Robert Vetter
the table is deleted! MySQL Log file says nothing. Can somone tell me what's going on? MySQL Version is 3.23.49 and runs on a Linux system (compiled from sources). Thanks -- Robert Vetter Internet Application Developer Kontor23 GmbH Ottenser Hauptstrasse 56-62 22765 Hamburg Tel.: 040/3808

Re: Apache + php + MYSQL

2002-05-21 Thread Robert Vetter
On Tuesday 21 May 2002 09:51, Robert Vetter wrote: > On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: > in /var/www/html/rcmms/appl.php on line 5 > > Hello, > > 1. make shure the PHP module is compiled into Apache, or runs as CGI. rubbish, sorry. Make shure PHP is compiled

Re: Apache + php + MYSQL

2002-05-21 Thread Robert Vetter
s that mysql_connect > > Fatal error: Call to undefined function: mysql_connect() > in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module is compiled into Apache, or runs as CGI. 2. If you have more questions: Ple

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
. After that there is no connection and no new connection will be created. What the module do is to read data from HEAP tables from MySQL in a handler function. Maybe is using global MYSQL handle not a good solution? Thanks for help. Robert Vetter Internet Application Developer Kontor23 GmbH

Connecting to MySQL from an apache module using C API

2002-05-03 Thread Robert Vetter
. After that there is no connection and no new connection will be created. What the module do is to read data from HEAP tables from MySQL in a handler function. Maybe is using global MYSQL handle not a good solution? Thanks for help. Robert Vetter Internet Application Developer Kontor23 GmbH

Re: three tables and count() - Urgent i need it to my job !!

2001-07-05 Thread Robert Vetter
1.id > group by number order by number desc Hello, I don't know what exactly you want to count, but one thing seems to be obviously to me: You can't make a left join between t2 and t3 on t3.id_t1=t1.id (line 3 of the query). Pozdrowienia do Polski, Robert Vetter -

Re: MySQL++ for Visual Basic

2001-05-31 Thread Robert Vetter
D'Arcy Rittich wrote: > > > Actually you dont't need a ocx. You can call the MySQL API functions, > > which are in a dll file. > > > > Robert > > Do you have any examples of that with VB? No, I don't. But you can take a look at an example written in C. Robert ---

Re: MySQL++ for Visual Basic

2001-05-29 Thread Robert Vetter
Cyber Monkey wrote: > > Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases? > Actually you dont't need a ocx. You can call the MySQL API functions, which are in a dll file. Robert - Before post

Re: Help in mySql with Java Applet

2001-05-21 Thread Robert Vetter
Fayed Design wrote: > > - Original Message - > From: Fayed Design > To: [EMAIL PROTECTED] > Sent: Friday, May 18, 2001 1:14 PM > > Hello to all of you, > does anybody know how to connect an Java Applet with mySql.I am trying already since >weeks,no success. > > It always response no

Insallation Problem

2001-05-09 Thread robert . vetter
install as usual. Now when I try to run mysql_install_db I get this error: "Didn't find /usr/local/libexec/mysqld. You shold do a make install...". How can I configure my system, so that mysql knows mysqld is in /usr/local/mysql/libexec/ now? I use Linux Debian. Thanks

Re: MySQL Manual

2001-04-27 Thread Robert Vetter
Jeremy Zawodny wrote: > > On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote: > > > > Is there a place to purchase the MySQL manual? > > The folks at NuSphere will sell you one for $79 or so. You'll get a > CD, printed manual, and support for the software. What? I hope you don't

Re: wildcard in tablesearch

2001-04-23 Thread Robert Vetter
Sven Heising wrote: > > Hi list, > > I'am new in this php and mysql-stuff so i need al lil bit support... > > this is my problem: > $result = mysql_query("select * from $dbtable where $wonach like > '%$first_name%' "); > > $wonach is a var which is set in a html form if i want to search

Re: Mysql commands from Linux shell

2001-04-20 Thread Robert Vetter
Fabio Galarraga wrote: > > Hi to all: > I have a linux script and I need it can execute some mysql commands. > Is it possible? If possible, how? Simply put the SQL commands in a text file. To execute them in the bash script you use the mysql client program: mysql -u user -p password the_datab

Re: Complex mysql query

2001-03-29 Thread Robert Vetter
> Yann Larrivée wrote: > > Thanks for the answer but it is a bit more complexe, i actually > creates these sample table for the example. Here is an attachement of > the structure dump. > > Hummm you got me to think more about my database structure withc is > really good. The idea you bourght u

A little bug?

2001-03-15 Thread Robert Vetter
Hello, I have just had a little problem with a SELECT query like this: SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable; this query returns an SQL error: ERROR 1064: You have an error in your SQL syntax near '* from TheTable' at line 1 BUT: SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS ft

Re: insert + AUTO_INCREMENT

2001-03-05 Thread Robert Vetter
Joris Kluivers wrote: > > hi, > > i have a problem > i have a database table created with the statement: > CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, >message text, username varchar(100), UNIQUE id (id); > > I insert records with: > INSERT INTO chatmessages

Re: Antwort: boolean type

2001-03-02 Thread Robert Vetter
"Thalis A. Kalfigopoulos" wrote: > > > > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is > > > closest to the boolean type > > > > ShortInt: 0 == FALSE, <> 0 == TRUE > > That's how I do it anyway. > > > > Or maybe combine multiple bool fields to one and use binary l

Re: Antwort: Re: boolean type

2001-03-01 Thread Robert Vetter
[EMAIL PROTECTED] wrote: > > On 01.03.2001 13:51:58 Robert Vetter wrote: > > > ENUM("no","yes") > > I always wondered: How much space does this take? 1 or 2 bytes, depending on the number of enumeration values (65535 values maximum).

Re: boolean type

2001-03-01 Thread Robert Vetter
Blaz Grapar wrote: > > Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest >to the boolean type ENUM("no","yes") - Before posting, please check: http://www.mysql.com/manual.php (the manu

Re: Quick C API question

2001-02-27 Thread Robert Vetter
Evan James Dembskey wrote: > > Hi, > > I have this statement: > > res = mysql_query(&my_connection, "SELECT * FROM student WHERE studnum = > 31665222"); > for example something like this: char query[96]="SELECT * FROM student WHERE studnum="; int studnum; studnum=get_studnum(); s