RE: Binary

2001-05-30 Thread David Lidström
Let's say it's an image, zip archive or a PDF-file!? I am creating a GUI-client, so it's when a table is listed, and the field is containing a file I'd like to know this somehow... If possible!! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: den 30 maj 2001

Re: Binary

2001-05-30 Thread Colin Faber
You could always look into hacking the code that drives the `file' application, to a point it can determine the binary data type. David Lidström wrote: Let's say it's an image, zip archive or a PDF-file!? I am creating a GUI-client, so it's when a table is listed, and the field is

Re: Problem in compiling Mysql source 3.23.38

2001-05-30 Thread Rafal Jank
make[2]: Entre dans le rpertoire `/installation/install/MySql/Tarball/source/mysql-3.23.38/client' /bin/sh ../libtool --mode=link c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -ltermcap

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-30 Thread Mohammad Shoja
Thank you for all your suggestions, I got it. the problem was in our web server because of security $ENV{HOME} doesnt point to my home directory so my .my.cnf file was unreachable. That's it. may be It can be helpful for other people as well. my %attr = ( PrintError =0,

HELP! Uninstall mySQL (Mac OS X (UNIX))

2001-05-30 Thread Victor Spång Arthursson
How do I do that? My installation of mySQL doesn't work, so I have to do it... Sincerely Victor Spång Arthursson [EMAIL PROTECTED] | V i c t o r | +45 35358799 / +46(0)733 204002 - Before posting, please check:

how to setup a Newsletter?

2001-05-30 Thread kaab kaoutar
Hi! I'working with php/mysql and id like to set a news letter! can u guide me through how to trigger sending an email once an article is inserted to my table in the database? i mean i want emails to be sent to all subscribers (stored in subscribers table) once an article is inserted in the

RE: how to setup a Newsletter?

2001-05-30 Thread Jon Haworth
You could do this with PHP. insert story into database; do { get subscriber email address; send email with link to story; } until no more subscribers If you have a lot of subscribers you'd be better off with a proper list manager, though. HTH Jon -Original Message- From: kaab

Hi!

2001-05-30 Thread Morgan Sagmo
I dont understand this. I am trying to make a database...Have not done it before, and I have red about MySQL. I have downloaded mysql-3.23.38, mysqlgui-1.7.5 and fltk. I am not good at this database thing... must say...but what do I do now? I cant find any .exe files? How can I use MySQL?

RE: Hi!

2001-05-30 Thread Simon Green
What OS are you using? Simon -Original Message- From: Morgan Sagmo [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 11:19 To: '[EMAIL PROTECTED]' Subject: Hi! I dont understand this. I am trying to make a database...Have not done it before, and I have red about MySQL. I have downloaded

Re: Can't change password in MySQL Windows version

2001-05-30 Thread Ardianto Rustandi
Still couldn't do it... :( Might this be a bug in MySQL Windows (or the particular version I'm using-- 3.23.28-gamma)? Ardianto R. Try C:\mysqladmin -u [EMAIL PROTECTED] -p password newpassword or even C:\mysqladmin -u myaccount -h 127.0.0.1 -p password newpassword - Original

Re: Hi!

2001-05-30 Thread Rolf Hopkins
Well, if you're looking for an exe file, I would say you have downloaded the wrong version. You will need to download the correct version for Windows and read the manual on how to install. If you have other problems, you'll need to be more specific. - Original Message - From: Morgan

MySQL RPM file: message suggestion

2001-05-30 Thread Neil Zanella
Hello, I just reinstalled Red Hat 6.2 and reinstalled MySQL 3.23.38 and got the following message as usual: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h

inserting a colum into a existing table

2001-05-30 Thread Marco Kammerer
Hello I am writing a programm in java that is checking my mysql db if everything is correct, so that I can you that db later in my java programm to write datas into it! I am fresh to mysql, but I got everything so fare, that the prog is able to make a no root user with the appr. rights,

Re: Aborted connections

2001-05-30 Thread Sinisa Milivojevic
Ken Menzel writes: Hi, I have also noticed these aborted connections, unfortunately my time is too divided to give this 100%. I have just created a test situation with 3 server and a large application that inserts about 300,000 large rows. This application aborts after several hours

mysql php connection errors

2001-05-30 Thread Steve Sapsford
hi ppl, i am a newbie running apache, php mysql on a redhat 7 server... i am getting the following error when i browse to my php file which access my database called steve: == Warning: MySQL Connection Failed: Can't connect to local

Re: Does a mysql preprocessor exist for SQL embedded in C/C++ code?

2001-05-30 Thread Sinisa Milivojevic
Spikol, Robert writes: Or is anyone working on this? Also, how about stored procedures? Does mysql support stored procedures? Thanks. Hi! Our C++ API, MYSQL++, has template queries which are a fine replacement for embedded SQL. Regards, Sinisa __ _ _ ___

FW: Can't connect mysql in Turbolinux workstation.Err 1130.

2001-05-30 Thread Thompson, Mike
I have forwarded this to list. For some reason 'zhenlei' sent it directly to me. -Original Message- From: zhenlei [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 9:51 PM To: [EMAIL PROTECTED] Subject: Can't connect mysql in Turbolinux workstation.Err 1130. Hi,I meet a

Re: mysql php connection errors

2001-05-30 Thread B. van Ouwerkerk
At 22:00 30-5-01 +1000, Steve Sapsford wrote: hi ppl, i am a newbie running apache, php mysql on a redhat 7 server... i am getting the following error when i browse to my php file which access my database called steve: == Warning: MySQL

Re: inserting a colum into a existing table

2001-05-30 Thread Gerald Jensen
Marco: You want to use the ALTER TABLE command (http://www.mysql.com/doc/A/L/ALTER_TABLE.html) G Jensen - Original Message - From: Marco Kammerer [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 6:34 AM Subject: inserting a colum into a existing table

Microsoft Access - MySQL Data Conversions

2001-05-30 Thread David Ayliffe
1) Whats the easiest way to convert data from Microsoft Access TO MySQL? (i'm thinking export a table using VB (with recordsets,) format into MySQL format and then mysql msaccess.dump into MySQL via a C++ proggie) 2) And the easiest way to convert data from MySQL TO MS Access? (Using C++

Servlet SELECT Query syntax error

2001-05-30 Thread Lucy
Hi Error message You have error in your SQL syntax ... Using Apache Tomcat - MySQL in Win 2000. Scenario: Servlet collects form data value, sends query to MySQL, returns search. The problem is getting the value of the inputted parameter named, title_name. Problem coding: rs =

Problem compiling FastBase TCL/MySQL interface

2001-05-30 Thread Adrian . Davis
I'm trying to compile the FastBase TCL/MySQL interface under Solaris 7 using GCC, and I'm get the following problem:- ld doesn't like the -B and -x parameters set in the makefile line... LDFLAGS = -Bshareable -lz -x $(MYSQLLIBDIR)/libmysqlclient.a ...it gives the this error:-

RE: Servlet SELECT Query syntax error

2001-05-30 Thread David Lidström
hi try to use ' around the new value. I.E. rs = stmt.executeQuery(SELECT * FROM MyTable WHERE title_name=' + request.getParameter(title_name) ) + '; /david -Original Message- From: Lucy [mailto:[EMAIL PROTECTED]] Sent: den 30 maj 2001 15:09 To: [EMAIL PROTECTED] Subject:

Mysql hosting (quotas)

2001-05-30 Thread Dennis S.Davidoff
Hi. Anyone realized subj? I have quotas on /home. And I want to let my users using mysql... but what about quotas? :( Mysql works under mysql and all tables creates under owner *mysql* :-\ Any tips? P.s. uname -a: OpenBSD ns 2.9 NS#2 i386 -- %whois -R NULL-RIPN PGP:

Re: Microsoft Access - MySQL Data Conversions

2001-05-30 Thread Jacob Martin
I found that it's much easier to write a program that connects to both databases and copies by inserting. That way you don't have to fool with files at all. However, I don't know if there are drawbacks to this or not. Anyone know if there any character set conversion issues or otherwise?

Re: zip code locator

2001-05-30 Thread Christopher R. Jones
Seems to me like it would be simpler to do two select statements, storing the lat and long of each site, then use a PHP function and built in PHP math operators to do the calculations. Note, your forumula assumes that a traveller would travel a Great Circle route to get from point A to B.

My sql and BINARY column?

2001-05-30 Thread VVM Ravikumar Sarma Chengalvala
Hi, I wonder to know whether declaring a column as BINARY will take the characters like \,' etc into binary form and stores it in the database? Then we may not need to specify the escape sequences.. Regards, Ravi Do You Yahoo!? Get

Fw: Microsoft Access - MySQL Data Conversions

2001-05-30 Thread g_gosho
- Original Message - From: g_gosho [EMAIL PROTECTED] To: David Ayliffe [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 4:54 PM Subject: Re: Microsoft Access - MySQL Data Conversions Hi, you can use this links: http://www.mysql.com/downloads/api-myodbc.html

Log

2001-05-30 Thread Mohammad Shoja
Hello everybody. would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it Just send errors and logs to STDERR. Thanks you for

Re: Error 1030: got error 28 from table handler

2001-05-30 Thread Benjamin Pflugmann
Hello. shell perror 28 Error code 28: No space left on device in other words: to process the query, MySQL creates a temporary table on disk and you are running out of disk space. You may want to consider to change the location of the directory used for temporary files. Bye,

problems with concat, group by on doubles

2001-05-30 Thread John Cartwright
I'm noticing some puzzling behavior involving the concat function and group by operation when used on a double type column in Mysql. Either one by themselves is fine, but together... mysql select datetime_1965_secs from sample where datetime_1965_secs 1009843300; ++ |

Re: Microsoft Access - MySQL Data Conversions

2001-05-30 Thread Jesús Gómez
You can use MyODBC to get data from Acces and insert it into mysql with VisualBasic,C++,etc. Also you can import mysql tables into acces with myodbc. - Original Message - From: Jacob Martin [EMAIL PROTECTED] To: David Ayliffe [EMAIL PROTECTED]; Mysql Lserv [EMAIL PROTECTED] Sent:

SELECT question.

2001-05-30 Thread Richard Reina
I am stuck on a select query and was wondering if someone could help. I have I've written a database app. that helps me run my business (trucking). I need however to write a query that shows me all of the loads that are delivered but not billed (invoiced). Which means that I have to select the

GROUPING

2001-05-30 Thread Rodrigo Gonzalez
Hi, I have to do a query but i don't know how to do this... I have this table id int start time stop time ... There are 2 to 4 rows for each id I have to select one row for each id where start is the max value between all rows with this id If you have an idea please let me know Thanks

HELP!!! Problem with checksetup.pl

2001-05-30 Thread Nadine Macklin
Hi, I have been trying to get 'checksetup.pl' to run for me for the second time, after tweaking the localconfig file. However, I am getting the following message: (Errcode:28) at ./checksetup.pl line 1618 Could not create the table 'longdescs'. Please check your 'mysql' access.

Re: SELECT question.

2001-05-30 Thread Rafal Jank
Richard Reina wrote: I am stuck on a select query and was wondering if someone could help. I have I've written a database app. that helps me run my business (trucking). I need however to write a query that shows me all of the loads that are delivered but not billed (invoiced). Which

RE: SELECT question.

2001-05-30 Thread Ravi Raman
hi. left join the two tables then check for NOT NULL in one of the fields from invoiced that will be empty if they haven't been invoiced: SELECT l.load_no l.date FROM loads l LEFT JOIN invoiced i on l.load_no = i.load_no where i.invoiced_on_this_date IS NULL obviously, substitute a real column

Install MySQL ODBC For Windows 98 problem.

2001-05-30 Thread Shahrizal
Hi there, I need help how to install MySQL ODBC driver for Windows 98. When I clink setup.exe half way give problem with the following message; An error occurred while copying c:\windows\system\ctl3d32.dll. Restart Windows and try installing again (before running any applications which use

Re: SELECT question.

2001-05-30 Thread Mohammad Shoja
I am stuck on a select query and was wondering if someone could help. I have I've written a database app. that helps me run my business (trucking). I need however to write a query that shows me all of the loads that are delivered but not billed (invoiced). Which means that I have to

Re: My sql and BINARY column?

2001-05-30 Thread Paul DuBois
At 3:13 PM +0100 5/30/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, I wonder to know whether declaring a column as BINARY will take the characters like \,' etc into binary form and stores it in the database? Then we may not need to specify the escape sequences.. You need to properly escape

Re: SELECT question.

2001-05-30 Thread Paul DuBois
At 9:41 AM -0700 5/30/01, Richard Reina wrote: I am stuck on a select query and was wondering if someone could help. I have I've written a database app. that helps me run my business (trucking). I need however to write a query that shows me all of the loads that are delivered but not billed

Log HELP!

2001-05-30 Thread Mohammad Shoja
Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it

RE: SELECT question.

2001-05-30 Thread Johnson, Gregert
SELECT l.load_no, l.date FROM loads l LEFT OUTER JOIN invoiced i ON l.load_no = i.load_no WHERE l.dlvr_date 0 AND i.load_no IS NULL; -- Greg Johnson -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

mysqld: fatal: relocation error: symbol not found: fopen64:

2001-05-30 Thread Rob Sedman
I am trying to install mySQL on my Solaris 2.5.1 system. I have downloaded the latest binary and followed the instructions as best I understand them (not being very familiar with UNIX systems). I have not used the default directory (/usr/local/mysql). I have not found a solution for the

RE: Binary

2001-05-30 Thread Paul DuBois
At 8:57 AM +0200 5/30/01, David Lidström wrote: Let's say it's an image, zip archive or a PDF-file!? How do *you* know this? If you just know it, based on some knowledge that only you possess, then there's no way for MySQL to guess. If you know it based on some objective criterion, then

RE: GROUPING

2001-05-30 Thread Ravi Raman
hi. select id, max(start) from your_table group by id; HTH. -ravi. -Original Message- From: Rodrigo Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 10:57 AM To: [EMAIL PROTECTED] Subject: GROUPING Hi, I have to do a query but i don't know how to do this... I have

Re: GROUPING

2001-05-30 Thread Rodrigo Gonzalez
I did this, but there is a problem I have to select all fields from the record returned, not just id and start, i need the other fields from the record with max start do you understand? - Original Message - From: Ravi Raman [EMAIL PROTECTED] To: Rodrigo Gonzalez [EMAIL PROTECTED];

RE: GROUPING

2001-05-30 Thread Ravi Raman
hi. okay...that's a different story. in oracle that could be done with a corellated subquery...in mysql there really is no easy way to do something like this. you could theoretically copy your information to a temporary table, and then select it out, but other than that, it seems you're out of

Restore Table

2001-05-30 Thread Simon Shearer
Hello, I am trying to restore tables with data and keep getting an error message error copping table.frm. I have unzipped the files as they were sent to me via the internet and the directory has the .frm file. If you knoe what I am doing wrong please help. I have win98, win2000 and linux

RE: GROUPING

2001-05-30 Thread Olivier Georg
Hola Rodrigo, I suggest that you use a temporary table: CREATE tmp ( INT id, TIME max); INSERT INTO tmp SELECT mytable.id, MAX(mytable.start) FROM mytable GROUP BY mytable.id; and then join it to your original table: SELECT M.* FROM mytable M, tmp T WHERE M.id=T.id AND M.start=T.max;

MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
MySQL won't seem to stop or start on 3 servers I've tried. I believe it begins after an ungraceful shutdown ('mysqladmin shutdown' or 'mysql.server stop' doesn't run). I am running RedHat 7.0 and using MySQL-3.23.37-1 and MySQL-client-3.23.37-1 from mysql.com (also tried the 3.23.38 RPMs). I'm

Re: Log HELP!

2001-05-30 Thread Gerald Clark
Mohammad Shoja wrote: Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root

is PHP list dead?

2001-05-30 Thread Joe Sheble \(Wizaerd\)
I know this is not a mySQL question, but I've not received any PHP List emails in two to three days... I'm willing to bet that somebody here is also on that list as well... is it dead? Joseph E. Sheble a.k.a. Wizaerd Wizaerd's Realm Canvas, 3D, Graphics, PHP/mySQL ColdFusion/MSSQL

RE: Log HELP!

2001-05-30 Thread Ravi Raman
hi. if you're not on a windows box, try something like: mysql -uroot -p test.sql 21 | tee output.log the mysql client also has a --tee option, as well as a tee(\T) command that could be of use. -ravi. -Original Message- From: Mohammad Shoja [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

database password question

2001-05-30 Thread Rez
I have a mysql database running with php server. How can the database be passworded so that a mysql client cannot connect to it freely ? Thanks Rez

Re: SELECT question.

2001-05-30 Thread Richard Reina
Thank you to all who responded. A left join was definately the answer. Richard Roger Karnouk wrote: Try this SELECT l.load_no l.date FROM loads l left join invoice i on (l.load_no = i.load_no) where i.load_no is null AND l.dlvr_date 0; -Original Message- From: Richard

RE: is PHP list dead?

2001-05-30 Thread SED
If you check out the www.php.net you will find out it temporally out of order. I sure hope it will be up soon :) Regards, Sumarlidi Einar Dadason SED - Graphic Design -- Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503

Query help...

2001-05-30 Thread Nathanial Hendler
Hello, I have a query that I can't figure out how to do. I would be really happy if some SQL experts could give me a little advice on how to do this I have two tables. I believe that the tables can be described as having a one to many relationship. Below are the columns in each table,

Re: Having problems with a query..

2001-05-30 Thread Kent Hoover
LEFT JOIN should do the trick for you... SELECT players.PLAYERID, players.FIRSTNAME, players.LASTNAME, COUNT(goals.SCORER) FROM players LEFT JOIN goals ON goals.SCORER = players.PLAYERID WHEREplayers.TEAMID = '$TEAMID' GROUP BY PLAYERID ORDER BY player.LASTNAME; Cheers,

MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
Also wanted to point out that 'netstat' returns the following line: STREAM CONNECTING0 /var/lib/mysql/mysql.sock Never actually reads CONNECTED, even after hours. I suspect this has something to do with the problem. Permissions are currently wide open as follows (though I've tried

RE: Help! How to use dBase with mySQL?

2001-05-30 Thread Brooklyn Linux Solutions
Export the database and then autoload it into MYSQL On 2001.05.28 21:00:46 -0400 Cal Evans wrote: No, MySQL will not read dBase files. I can think of 3 ways to do it off the top of my head. 1: Use Visual FoxPro. It will read dBase files and you can use the DBC to open a connection to a

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Mike Trotzke wrote: Never actually reads CONNECTED, even after hours. I suspect this has something to do with the problem. Permissions are currently wide open as follows (though I've tried everything): /var/ drwxr-xr-x root root

Another Index problem

2001-05-30 Thread Mike Baranski
Thanks for the advice last time folks, I think that one's working. Here's a tougher query, any ideas on how to speed this one up: SELECT DISTINCT badge.last_name AS last_name, badge.first_name AS first_name, badge.bid AS bid, badge.employee AS employee, badge_type.description AS type,

FULLTEXT

2001-05-30 Thread Jacob Friis Larsen
We have a database where users search for text very often, which give us the problem that the tables are locked for some seconds. Is it possible to take a copy of the FULLTEXT index, and search in that so the table we search in does not get locked ? Or do you have any other ideas to solve this.

RE: Log

2001-05-30 Thread Don Read
On 30-May-01 Mohammad Shoja wrote: Hello everybody. would you please tell me how can I log execution of a DDL? Whats a DDL ? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
copying one of the my.cnf sample files from the support(?) directory to /etc/my.cnf actually solved it. Unfortunately didn't solve it for me. :( I tried copying /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting... same behavior. Damn, I was looking forward to going out celebrating

Strange ORDER results

2001-05-30 Thread Olexandr Vynnychenko
Hello everyone, I tried 2 queries: 1) SELECT id, CONCAT(title, ' [', id, ']') as name FROM rubrics ORDER BY name 2) SELECT id, CONCAT(title, ' [', id, ']') FROM rubrics ORDER BY title, id The 2nd returns results in alphabetical order but the 1st is a little bit strange... Does anybody knows

ERROR 1114

2001-05-30 Thread Tomas Carmen
Hi: Someone knows why I am getting this error after some left joins between 3 tables or more tables. ERROR 1114 at line 292: The table 'SQL202_0' is full It's only whith more than 8000 rows moreless. I'm working with mysql 3.22.27 (server an client) on RH 7.1 Can you help me, please?

Strange problem with Count(*)

2001-05-30 Thread pliebrand
I am not sure if I am doing something wrong in mySQL, but I have tested the following in Microsoft SQL, Access and Oracle it works fine in those environments, but unfortunately, it does not work in mySQL. I have a simple query, such as: select name, count(*) from tbl_users group by name; In

ASP and my sql??

2001-05-30 Thread VVM Ravikumar Sarma Chengalvala
Hi, I wonder to know of any other ways to connect to mySQL from ASP without using ODBC Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at

Re: Strange ORDER results

2001-05-30 Thread Paul DuBois
At 10:32 PM +0300 5/30/01, Olexandr Vynnychenko wrote: Hello everyone, I tried 2 queries: 1) SELECT id, CONCAT(title, ' [', id, ']') as name FROM rubrics ORDER BY name 2) SELECT id, CONCAT(title, ' [', id, ']') FROM rubrics ORDER BY title, id The 2nd returns results in alphabetical order but

Re: MySQL Hang and Freeze

2001-05-30 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 02:46:24PM -0500, Mike Trotzke wrote: copying one of the my.cnf sample files from the support(?) directory to /etc/my.cnf actually solved it. Unfortunately didn't solve it for me. :( I tried copying /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting...

Re: MySQL Hang and Freeze

2001-05-30 Thread jaab
On Wed, 30 May 2001, Jeremy Zawodny wrote: Unfortunately didn't solve it for me. :( I tried copying /usr/share/mysql/my-medium.cnf to /etc/my.cnf and restarting... same behavior. Damn, I was looking forward to going out celebrating :-). *dang*. Ok. You did do a myisamchk -eoB

Re: ASP and my sql??

2001-05-30 Thread Jorge del Conde
Hi, There is a company called Scibit that develops a commercial AcitveX (COM) object called MySQLX that can be used to access directly MySQL from ASP or any other COM supporting language. the url is www.scibit.com Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_

Looking for MySQL/PHP developer in Porltand, OR....

2001-05-30 Thread Nicholas A. Zukin
We're considering hiring a PHP/MySQL web developer. You must live in the Portland, OR, metro area. Please respond off-list to me with a resume/portfolio if interested. Thank you. Nick -- Nicholas A. Zukin Web/Database Developer ODI Technolgies

indexing files

2001-05-30 Thread kaab kaoutar
Hi I have many articles whose paths and categories are stored in a mysql table ! I'd like to index these files so as to be used in my search engine! I used to work with NT index server who automatically indexes files and put them in an sql dbs! but now i use php/mysql Thanks

MySQL on RAQ4

2001-05-30 Thread Randy Davis
Hi Folks, I recently had to upgrade MySQL on my Cobalt RAQ4 to support some complicated Joins. Unfortunately this has disabled my ODBC connection for the Chilisoft ASP. Has anybody gone this can give me a hand? Thanks! Ciao Randy

Re: Strange problem with Count(*)

2001-05-30 Thread Jeremy Zawodny
On Wed, May 30, 2001 at 07:55:28PM +, [EMAIL PROTECTED] wrote: I am not sure if I am doing something wrong in mySQL, but I have tested the following in Microsoft SQL, Access and Oracle it works fine in those environments, but unfortunately, it does not work in mySQL. I have a simple

Re: MySQL on RAQ4

2001-05-30 Thread Shawn Hogan
Randy Davis wrote: I recently had to upgrade MySQL on my Cobalt RAQ4 to support some complicated Joins. Unfortunately this has disabled my ODBC connection for the Chilisoft ASP. Has anybody gone this can give me a hand? Thanks! http://pkg.nl.cobalt.com/ has a RaQ4 .pkg for MySQL 3.23.37

Coverting seconds on-the-fly to date?

2001-05-30 Thread Michael Bellears
Hi, Our Radius server reports a users usage as the following - ACCTSTATUSTYPE TIME_STAMP 1 991200195 2 991200243 Where ACCTSTATUSTYPE == 1 is starttime and ACCTSTATUSTYPE == 2 is the stop time Which with perl, I can use the

Re: Coverting seconds on-the-fly to date?

2001-05-30 Thread Jeremy Zawodny
On Thu, May 31, 2001 at 09:27:56AM +1000, Michael Bellears wrote: Hi, Our Radius server reports a users usage as the following - ACCTSTATUSTYPETIME_STAMP 1 991200195 2 991200243 Where ACCTSTATUSTYPE == 1 is

Re: ASP and my sql??

2001-05-30 Thread Ben Gollmer
If you are good with C++, you can probably write an ActiveX wrapper for MySQL++ yourself. MS Visual C++ has some wizards that will help you with ActiveX controls. My company considered doing this for a project until we decided to make the app web-based. Ben On Wednesday, May 30, 2001, at

mysqld not running

2001-05-30 Thread Jessica Grayless
I have a binary distribution of MySQL installed on a Red Hat Linux system. When I try to run mysqld or safe_mysqld, it gives me a 'cannot connect to server 'localhost'.' The error file tells me bind on TCP/IP port 3306, make sure address is not in use. However, I used 'ps' and no mysqld

Re: ASP and my sql??

2001-05-30 Thread Jorge del Conde
Hi Dennis, You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. This is not entirely correct. ODBC is merely just one more way to connect to MySQL. MySQL just like many

Java Applet for Mysql

2001-05-30 Thread David Tan Teck Siang
Can anyone here recommend a link to the FREE and the most simple Java source code for MYSQL query without using Java runtime?? Thanks tanpy :)

Re: mysqld not running

2001-05-30 Thread Kevin Whitney
At the command line, type: /etc/rc.d/init.d/mysqld start You can tell if it starts. If that works, and you want mysql start automatically, use control-panel to cause mysqld to start at init level 3. If you don't know what this is, email me

myisamchk --sort-records extremely slow

2001-05-30 Thread Michael Villalba
I have a rather large MyISAM table (~230 million rows) running under MySQL 3.23.30. It has 10 columns and 3 indices. The data and index files each occupy about 10GB. My problem is that sorting the rows using myisamchk --sort-records takes an extremely long time. The last sort took 95 hours

update query produces warnings?

2001-05-30 Thread Tyler Longren
Hello everyone, I have a database of alumni at school. Each alumnus that registers gets assigned their own id. Id's are made with mysql's auto_increment. Everything worked fine until a few days ago when everybody that signed up got the id of 127 assigned to them. MySQL will NOT assign

Re: update query produces warnings?(fixed)

2001-05-30 Thread Tyler Longren
This post can be ignored now. Turned out the datatype for the id field was set to tinyint, changed it to int and everything worked great. Tyler On Thu, 31 May 2001 00:26:12 -0500 Tyler Longren [EMAIL PROTECTED] wrote: Hello everyone, I have a database of alumni at school. Each alumnus

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
Have you tried putting the file in some other location (/tmp?) just to see if it has any effect? I'm not exactly sure what file you mean. But based on your comments, I tried puting the my.conf file in /tmp and resterting---nothing changed. Were you refering to the mysql.sock file? Thanks,

RE: update query produces warnings?

2001-05-30 Thread Chris Bolt
Change the id column to something larger than a TINYINT (like MEDIUMINT or INT). You should also make ID the primary key. Hello everyone, I have a database of alumni at school. Each alumnus that registers gets assigned their own id. Id's are made with mysql's auto_increment. Everything

Re: MySQL Hang and Freeze

2001-05-30 Thread Mike Trotzke
You did do a myisamchk -eoB /var/lib/mysql/*/*.ISM ? I did do a myisamchk on all my tables, but not exactly with the -eoB option. I am, however, sure that the table files themselves are fine. As a temporary solution I have rebuilt our development server from scratch (fresh RedHat install) and

sessions problems

2001-05-30 Thread Adrian D'Costa
Hi, I am trying to use session instead of cookies as my targeted customers are either behind a firewall or disable cookies. My system php 4.0.1pl2 rh 7.0 What would be the best way to use a session. I a database to store the session id and then delete it on exit or expiry. I hope someone can