Re: Use MySQL with Microsoft Office

2005-03-08 Thread GH
I think I got it working I am printing out the records that I need... a bit of a 2 stepper but nice since I can store the queriy since that can not be done just yet in MySql On Tue, 08 Mar 2005 23:47:09 +0100, dixie <[EMAIL PROTECTED]> wrote: > Il giorno mar, 08-03-2005 alle 13:46 +0100, Martijn

Re: Use MySQL with Microsoft Office

2005-03-08 Thread GH
ot more professional. > > As a side note, OpenOffice, as of 1.1.2, does not have a Publisher type > equivalent. It also does not > have an Access equivalent, hence MySQL interoperability. > > J.R. > > -Original Message- > From: Jigal van Hemert [mailto:[EMAIL PRO

Re: Use MySQL with Microsoft Office

2005-03-08 Thread GH
Does Open Office have a MSPublisher like program? On Tue, 8 Mar 2005 12:43:01 +0100, Jigal van Hemert <[EMAIL PROTECTED]> wrote: > From: "Tom Crimmins" > > On Monday, March 07, 2005 23:03, GH wrote: > > > > > Greetings, I would like to know if it is possib

Use MySQL with Microsoft Office

2005-03-07 Thread GH
Greetings, I would like to know if it is possible to do a mail merge in Microsoft Office with a mySql database as the source? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
://dev.mysql.com/doc/mysql/en/old-client.html>. > > Michael > > GH wrote: > > > I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP > > Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 > > > > I am receiving the enclosed

MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

Re: [PHP] phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8

2005-01-01 Thread GH
It would be nice if phpMyAdmin would kindly note that on their website... Also, when I run a phpInfo()... it says i have the 3.23.49 could this be a contributing factor? On Sat, 1 Jan 2005 15:55:27 +0700, Willy Sudiarto Raharjo <[EMAIL PROTECTED]> wrote: > > Has anyone had any problems installi

phpMyAdmin w/ winXP - IIS w/PHP 4.3 w/mysql 4.1.8

2004-12-31 Thread GH
Has anyone had any problems installing phpMyAdmin with the above configuration? I get an error about the mySql client and authentication methods? MySQL Error: 1251 : Client does not support authentication protocol requested by server Please assist Happy New Year Gary -- MySQL General Mailing Lis

Copying users?

2004-12-29 Thread GH
I would like to know if it is possible and how to copy my users (passwords & priviledges etc...) from my Mandrake 10.0 / MySql 4.0 machine to my Win XP Pro/MySql 4.1 machine? I would like to keep being able to develop the project that I am working on while I will be away from my main computer? -

Re: MySQL and PHP

2004-12-29 Thread GH
I am using IIS :( On Wed, 29 Dec 2004 10:03:11 -0600, Josh Trutwin <[EMAIL PROTECTED]> wrote: > On Wed, 29 Dec 2004 10:42:45 -0500 > GH <[EMAIL PROTECTED]> wrote: > > > On Windows... Which do i install first? PHP or MySQL? > > Apache. :) > > It does

MySQL and PHP

2004-12-29 Thread GH
On Windows... Which do i install first? PHP or MySQL? Thanks Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Iteration Possible? 4.0.18

2004-12-13 Thread GH
Hi. Is there a way to in the mysql client (4.0.18) to for a list of "IDs" execute 2 queries with each ID... I.e. : I have a list of IDs 1,2,3,24,19,4,5 ... and would like to "loop" through them to execute 2 queries for each one so that I can pull the proper records out and print out the results..

Re: Update Query with special conditions.

2004-11-24 Thread GH
I am curious about doing something simular to this... does anyone have an idea On Wed, 24 Nov 2004 00:43:32 -0500, list 123. wrote: > Using mySQL 4.0, I would like to know how I can code a query that will change > the value of Participants.Active from Y to N is for three or more CONSECUTIVE >

Re: [PHP-DB] Upgrading mySQL

2004-11-22 Thread GH
22 Nov 2004 15:55:25 +0100, Ingo Strüwing <[EMAIL PROTECTED]> wrote: > Hi GH, > > apart of the contents of the mentioned documents and hints, there is > nothing else. Just start the new server in place of the old server with > the same options unless told otherwise in the

Optimize Query Output

2004-11-19 Thread GH
I have the following query: SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present` FROM `Attendance` A, Sessions S, Participants P WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant` GROUP BY P.LastName, P.FirstName, A.Present, A.AttID I would like to have the outpu

Re: [PHP-DB] Upgrading mySQL

2004-11-15 Thread GH
ng from Version 4.0 to 4.1 > - http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html > > > > > On Sun, 14 Nov 2004 09:30:49 -0500, GH <[EMAIL PROTECTED]> wrote: > > I would like to know how to upgrade mySql from 4.0 to 4.1? > > > > I am running mandrak

Upgrading mySQL

2004-11-14 Thread GH
I would like to know how to upgrade mySql from 4.0 to 4.1? I am running mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am a bit nervous. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

Concatinating Two Columns

2004-11-13 Thread GH
I would like to know how I can make two columns out put as one? For Example I have +---+-+--+---+-+ | AttID | SessionDate | LastName | FirstName | Present | +---+-+--+---+-+ | 2 | 2004-10-30 | Smith | Dale

Problem with an insert query

2004-11-12 Thread GH
In my database I have the following tables: +-+ | Tables_in_AHRC | +-+ | Attendance | | Participants| | ProgressNotes | | Sessions| | Staff | | StaffAttendance | +-+ I am trying to insert data in the ProgressNotes Table

Diffrences in table types

2004-10-09 Thread GH
(SORRY FOR THE BLANK MESSAGE WRONG BUTTON PUSHED) Greetings: I am trying to create referential intergrity... I was reading that mySql does not support that on the Database Level and that you have to do it manually. However i am now seeing some posts that talk about it... i.e. Foreign Key

Diffrences in Table Types

2004-10-09 Thread GH
Greetings: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How would you make a smarter Search?

2004-10-08 Thread GH
I am interested in this too... Dan if you figure out a way I would be most interested... On Fri, 8 Oct 2004 14:50:49 -0400 (EDT), Dan Venturini <[EMAIL PROTECTED]> wrote: > Hello all Here is my problem. > I am searching titles in an article database. > I have two titles: > > mouse cleaning > a

Re: Telephone number column not working

2004-10-02 Thread GH
One issue could be that an int column unsigned can only hold up to 4294967295 a ten digit number. Plus if you put it in a context of a phone number... only area codes 428 or lower will have ALL THE EXCHANGES and ALL THE UNIQUE NUMBERS in the range... with part of area code 429 A bigint will hold t

Re: Meaning of 1:1, 1:1 generalization, 1:n, 1:n non identifying, n:m

2004-10-02 Thread GH
weird... about 1:! generalization and 1:m non identifying... I think that these examples can make it better to understand some of those terms... I am quoting from Database Systems -- Design, Implementation & Management fouth edition by Rob & Coronel (page 23) Conceptual Modules use three types o

Re: Using Visio to diagram MySQL db, export SQL

2004-10-01 Thread GH
Is there a version or a product available for LINUX? On Tue, 28 Sep 2004 13:55:19 -0500, Tim Hayes <[EMAIL PROTECTED]> wrote: > ari > > MYdbAL which you can download at www.it-map.com is completely FREE and > includes data modeling, DDL generation or whatever you need to create your > MYSQL data

Re: full text search question

2004-10-01 Thread GH
Laura did this work... inquiring minds want to know :) On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele <[EMAIL PROTECTED]> wrote: > Laura: > > Perhaps the "-" is acting like a Boolean operator. What if you put > double quotes around your search phrase: > > SELECT * FROM metadata WHERE MATC

Re: Multiple Insert Statement?

2004-09-28 Thread GH
I know that this is off topic and such... but can you explain the Match / Against that you used in your query? i have never seen syntax like that in SQL On Tue, 28 Sep 2004 14:16:56 -0400, Eve Atley <[EMAIL PROTECTED]> wrote: > > My query: > SELECT * FROM wow.resume r INNER JOIN wow.candidate c

Re: Images

2004-09-28 Thread GH
Ed brings up a great point... i would rather not have anyone 'searching' for images in directories and such... On Tue, 28 Sep 2004 10:53:01 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > Ok... I have some more test results. After optimizing as much as I can > think of, without using caching, I'v

Re: Images

2004-09-28 Thread GH
I thank you all for this discussion... and for the great information that everyone has provideded. Next question (which is part of my original) how do I actually get the images into the Blobs... Additionally, the what are the names and capacities of the datatypes that I could use? I have been he

Re: Images

2004-09-28 Thread GH
ast/reliable.. easy to > replicate, stream, etc.. > > > > > On Tue, 28 Sep 2004 08:42:13 +0200, Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > From: "GH" <[EMAIL PROTECTED]> > > > > > I was wondering how to get images into and out of

Images

2004-09-27 Thread GH
I was wondering how to get images into and out of a Mysql database was told it was possible. I have mysql 4.0.18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AutoResponders (was: Unable to download MySQL (fwd))

2004-09-14 Thread GH
If you are going to be out of the office... suspend you subscription to the mailing list... so that everyone does not recieve these notices please On Tue, 14 Sep 2004 19:43:29 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > > Does the message below, mean that everyone who posts a message to

Re: Unable to download MySQL

2004-09-14 Thread GH
I would right click on the link and choose to save target... do not left click such that it would try to open it. as rpm could also be used by RealPlayer/RealOne for their media files. On Wed, 15 Sep 2004 01:21:55 +0800, Bret Busby <[EMAIL PROTECTED]> wrote: > > In trying to download the mysql L

Fwd: Best way to get Access DB structures into MySQL ??

2004-09-11 Thread GH
-- Forwarded message -- From: GH <[EMAIL PROTECTED]> Date: Sun, 12 Sep 2004 02:49:02 -0400 Subject: Re: Best way to get Access DB structures into MySQL ?? To: Chris Martin <[EMAIL PROTECTED]> Does this also allow for the importation of the data as well? On Sat, 11

Please Disregard This Message

2004-09-11 Thread GH
Please disregard. Attempting to verify that I can send and receive messages -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Upgrading mySQL 3.23 to 4.0

2004-08-03 Thread GH - CF
Can you give me a bit more detailed instructions on what i am uninstalling and what I should back up? Thanks Wolfgang Riedel wrote: [EMAIL PROTECTED] schrieb: I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have "mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-