Re: sessions problems

2001-05-30 Thread g_gosho
You can try this link: http://www.bonev.com/s there is PHP session handling librarary and documentation how to use it - Original Message - From: "Adrian D'Costa" <[EMAIL PROTECTED]> To: "php general list" <[EMAIL PROTECTED]> Cc: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday,

auto-increment and mysqldump

2001-05-30 Thread Matt Templeton
I've read the documentation but can't seem to find a clear answer to this... If I set up a table that has and auto-increment ID table and insert a number of records that are incremented in sequence. Then I delete, say the 5th and the 8th row and do a full (database creation and data) mysqldump.

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

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

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

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

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 alumn

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 them

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

User Sign-up/Log-in

2001-05-30 Thread Randall Fitzgerald
Hi, I am just wondering about the code to do a query for a string and then see if that string exists or not. like finding the string for $user in a DB when $user would be inserted into a table named users as username to see fi it is used or not.

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 dire

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

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 pro

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

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 Dennis Salguero
It depends on what you mean by "without using ODBC". You CAN connect to a MySQL database without a DSN name, you can just declare an IP address and a DB name, but I'm pretty sure that this method still uses the MySQL ODBC driver and it must be installed on the server. You CAN NOT, as far as I kn

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 l

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

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 sim

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

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 -

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 __ ___ __ __ / |/ /_

Re: ERROR 1114

2001-05-30 Thread Jorge del Conde
Hi, This is covered in the manual in section "Table is full". http://www.mysql.com/doc/F/u/Full_table.html Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.m

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 /var/li

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 restartin

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 orde

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 http://mail.yahoo.i

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 t

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

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 why

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 :

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 log

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.

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, badgests.co

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 r

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

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 every

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

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

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 E

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

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: Log HELP!

2001-05-30 Thread Ravi Raman
hi. if you're not on a windows box, try something like: mysql -uroot -p &1 | 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, May 30, 200

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

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

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 on

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;

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 comp

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 lu

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 PROTECTE

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 t

Corrupting Indexes! Why?

2001-05-30 Thread Basil Hussain
Hi all, I have recently upgraded my MySQL server to the latest version, 3.23.38 and, whether this is related or just a coincidence, a lot of heavily-used tables (mainly INSERT queries and a few SELECT queries via a containing MERGE table) in one of my databases have had their indexes corrupted.

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

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 followi

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,

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 log it Just send

selecting records where max value

2001-05-30 Thread La Rocca Network, Inc.
Hi ! is there any way to do this ? SELECT T2.monedaID, T2.fecha, T1.descripcion, T2.compra, T2.venta FROM UYMonedasBCU T1, UYMonedasCotizaInter T2 WHERE (T2.fecha = (SELECT DISTINCT MAX (T3.fecha )FROM uymonedascotizainter T3 )) AND (T1.forma = 'Billete') AND (T2.monedaID = T1.id ) The matt

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

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 esca

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

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

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 f

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

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

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

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

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]> Se

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; ++ | datet

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

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 log it Just send errors and logs to STDERR. Thanks you for your help

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

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 yo

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

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

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: http://null.magelan.ru/null.

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] Subjec

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:- /usr/ccs

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 = stmt.executeQue

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

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

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: > > >== > >Warn

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

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 __ _ _ __

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 MySQ

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 hour

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

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 tulip.math.ualberta.ca

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 ___

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 Sa

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

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 mys

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

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 kaou

MySQL Server hosting: Linux or Win2K?

2001-05-30 Thread alec . cawley
I am still in the early stages of developing my first SQL application, and I have chosen MySQL because I only need very straightforward facilities, but I really want reliability, including particularly Replication. I am currently doing all my development using Windows hosts because that is what I

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 artic

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

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

Re: Problem in compiling Mysql source 3.23.38

2001-05-30 Thread Rafal Jank
> make[2]: Entre dans le répertoire > `/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 > ../li