Re: Location of header files - RPM

2002-05-23 Thread Jim Philips
The quick way to answer this question is to go to the directory where you have the rpm (if you still have it) and run the following command: rpm -qpi -l MySQL-3.23.49a-1.i386.rpm This will give ytou the details on where everything has been installed. On Thursday 23 May 2002 11:46 am, Carl

Re: client server

2002-05-22 Thread Jim Philips
On Wednesday 22 May 2002 07:27 am, Jacob Friis Larsen wrote: If I install MySQL on the same server as Apache Php and only use MySQL in Php, do I then have to install the MySQL client? Technically, you don't need it. But when I am debugging PHP, I often turn to mysql client just for a sanity

Re: Inserting images and other blobs

2002-05-21 Thread Jim Philips
On Tuesday 21 May 2002 10:54 am, Info_Best-IT wrote: Any suggestions on how to load images from a web site into a MySQL db? I would like to set up a page that allows you to select an image from the local machine and load it to my MySQL DB on my web server. I'm not sure if it would just be a

Re: MySQL to Excel ?

2002-05-01 Thread Jim Philips
It's been awhile since I've done this, but couldn't you build a pivot table in Excel that would bring the data through ODBC? I did this before for a report I needed. You can get very granular about what data goes where in Excel and avoid the need for a bloated macro. Once the data sources and

Re: mysqlimpor and fixed length files.

2002-05-01 Thread Jim Philips
You need awk. It is tailor-made for this kind of task. There is a Windows version if that's what you're running. It can easily go through the records and insert a delimiter at a certain character position. It shouldn't take more than one line of code to accomplish the task. On Wednesday 01

Re: Results relevance

2002-04-29 Thread Jim Philips
If the final goal of this is a visual display, maybe it would make more sense to display relevance as a horizontal bar graph that is longer or shorter based on the relevance number. There is no reason to get hung up on percentages. On Monday 29 April 2002 02:21 pm, Paul DuBois wrote: At

Re: How get the columns that are between an interval?

2002-04-28 Thread Jim Philips
Should we assume that your tables have an existing column of type timestamp or date? On Sunday 28 April 2002 11:47 am, Dra. Silvia Andreasi wrote: Hi, How can I get the columns between a given time interval? Something like: The patients admitted between january 25, 2000 and january 30,

Re: how to get support help?

2002-04-25 Thread Jim Philips
Thanks for inspiring me to create a new mail filter! On Thursday 25 April 2002 01:50 pm, Clay Loveless wrote: Erik, et. al.-- Thanks for all the helpful advice. I'll make a note that the MySQL mailing list welcomes messages from people shrieking HELP!!! even though they clearly haven't

Re: uppercase for first letter

2002-04-24 Thread Jim Philips
If you can't do it within MySQL (I don't know the answer to that one) you might be able to dump the information to a text file and process it using awk and then reload it. Awk is perfect for this kind of thing. There is a Windows version, if that is your OS. On Wednesday 24 April 2002 08:49

insert for datatype of set

2002-04-23 Thread Jim Philips
I couldn't find this in the documentation. What is the propoer sql to insert into a field with a data type of set? My field has the following set of acceptable values: GA, TN, SC, NC, AL Assume I am inserting multiple values, such GA, TN, SC. If I separate them with commas, mysql will assume

Re: insert for datatype of set

2002-04-23 Thread Jim Philips
Yes. I found that page earlier. I still don't see how it answers my question. What is the proper syntax for an insert statement? On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote: http://www.mysql.com/doc/S/E/SET.html On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote: I

Re: insert for datatype of set

2002-04-23 Thread Jim Philips
2002 04:31 pm, Gerald Clark wrote: insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 'TN,NC,AL') ; Jim Philips wrote: Yes. I found that page earlier. I still don't see how it answers my question. What is the proper syntax for an insert statement? On Tuesday 23 April 2002 03:54

Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP)

2002-04-18 Thread Jim Philips
It isn't generally a good idea to install one piece by rpm and another by compiling and installing. A straight compile and install will put things in different directories from an rpm install. You will have a hard time making it all work. You can go with rpm or compiling from source, but be

Re: uninstallin Linux

2002-04-16 Thread Jim Philips
How you uninstall depends on how you installed. Did you install the binary? an rpm? or compile the source and then install? If you installed by rpm, then all you need to do is: rpm -e mysql If you used some other method to install, then you can just delete all od the directories. But you

load file from remote host

2002-04-12 Thread Jim Philips
keywords: sql, query Is it possible to load a file from a remote host as data type blob? This needs to be done from within the C API. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Do any of your applications work?

2002-04-06 Thread Jim Philips
Ditto here. If you have a support contract, then this is not the channel for seeking support, since it's a free mailing list. And anybody would need more information than you provided to solve the problem. Did you try to install a binary version? Did you try to build from source? MySQL is

Re: Help with syntax error

2002-04-02 Thread Jim Philips
There is no support for sub-queroes in MySQL, so your second select is getting kicked out. You probably want a left join for this. On Tue, 2002-04-02 at 06:54, jim and lois flaherty wrote: I have a table that recieves raw data form results for an online quiz. The boss wants to analyse the

Re: GUI

2002-03-29 Thread Jim Philips
There is also PHP-GTK, which uses PHP to implement bindings to GTK. So, within PHP you could build a GUI that could be used for accessing a MySQL database. But I am wondering why some of the existing GUI tools for MySQL won't do the trick. On Fri, 2002-03-29 at 06:24, DL Neil wrote: Anoop,

Re: Can not open file (errorno 144)

2002-03-23 Thread Jim Philips
I'm assuming you're on a UNIX box? If so, you might first check to see if the data files exist and then look at the permissions on them. My data files are in: /usr/local/var/database name Let the list know what you find. On Sat, 2002-03-23 at 06:10, Andy wrote: When trying to execute a

RE: mysql/php on linux

2002-03-23 Thread Jim Philips
phpinfo(); ? and not result of the phpinfo() function. When I run php phpinfo() at the shell command, it out puts the html result. What is problem, my Apache not understand the php script? Thanks From: Jim Philips [EMAIL PROTECTED] To: Andy Cheng [EMAIL PROTECTED] Subject: RE: mysql/php

Re: http auth in phpmyadmin help!

2002-03-21 Thread Jim Philips
What kind of box are you on? UNIX? Windows? What happens when you try to access the page? Provide some details. On Thu, 2002-03-21 at 08:52, Mike Yrabedra wrote: I am having a heck of a time trying to get phpMyAdmin to work with 'http or cookie' authentication. I have created the

Re: mysql/php on linux

2002-03-18 Thread Jim Philips
There is a tool that will automate the installation process, if you like. It can be found at: http://www.apachetoolbox.com/ You tell it what you want and with what features. Then it proceeds to download the files, configure, make and install them. It works quite well in my experience. On Mon,

Re: Compiling problem 3.23.49 under linux (mysql.cc)

2002-03-14 Thread Jim Philips
It looks like you hit some C++ code on the first line. There are still major problems in using gcc 3.x for compiling C++ on Linux. On my own box, I had to downgrade to gcc 2.9.6. MySQL compiles flawlessly now. On Thu, 2002-03-14 at 01:19, MWP wrote: Hi all... I get: c++-303

Re: Please help! - About doing a delete.

2002-03-14 Thread Jim Philips
To select the rows you are looking for, you can use: select * from messages left join topics on topics.topic_id=messages.topic_id where topics.topic_id is null; This works fine for selecting. But for some reason the corresponding SQL for a delete fails: mysql delete from messages - left

Re: Problem in instalation

2002-03-13 Thread Jim Philips
You could probably save yourself some trouble by installing binaries. But what version of Linux? And what version of gcc? There are many problems associated with using gcc 3.x that I won't get into here. But it helps to pass along these details. On Wed, 2002-03-13 at 11:04, Roberto C. Salazar

Re: Problem in instalation

2002-03-13 Thread Jim Philips
. wrote: I work with Linux Cobalt (like to RedHat) My gcc version is gcc-2.7.2 - Original Message - From: Jim Philips To: Roberto C. Salazar M. Cc: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 11:18 AM Subject: Re: Problem in instalation You could probably save

Re: Multiple languages (was Re: Cyrillic characters)

2002-03-12 Thread Jim Philips
On Mon, 2002-03-11 at 23:39, Joel Rees wrote: Sort of off topic, but here goes: Jim Philips wrote: I am trying to understand how to store both Latin and Cyrillc characters in a database. I built in support for koi-8 and win1251, but I don't seem to be getting real support for Cyrillic

Cyrillic characters

2002-03-11 Thread Jim Philips
I am trying to understand how to store both Latin and Cyrillc characters in a database. I built in support for koi-8 and win1251, but I don't seem to be getting real support for Cyrillic. Cyrillic characters are stored as ASCII and are echoed back on the Web page that way. Will MySQL support