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 possible to do a mail merge in Microsoft Office

Re: Use MySQL with Microsoft Office

2005-03-08 Thread GH
, 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 PROTECTED] Sent: Tuesday, March 08, 2005 9:59 AM To: GH Cc: mysql@lists.mysql.com

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

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]

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: MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH

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 installing

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

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]

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 doesn't really matter but I'd suggest MySQL first as I

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?

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. list 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
: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 mentioned documents. Am Mo, den 15.11.2004

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

Re: [PHP-DB] Upgrading mySQL

2004-11-15 Thread GH
/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 mandrake 10 I am using the preinstalled versions of both mySQL and PHP (php4). I am a newbie to Linux and am

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

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
Greetings: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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 and

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 of

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

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 MATCH( type )

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

Re: Images

2004-09-28 Thread GH
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 a Mysql database was told it was possible. I have mysql 4.0.18 The general opinion

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

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

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

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

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

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

2004-09-12 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 Sep 2004 21:34

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