Client does not support authentication protocol requested by server

Hi We have php 4.3.4 and mysql 5 My test script produces this Client does not support authentication protocol requested by server http://www.jewishgen.org/cemetery/connect-test.php Research suggests that I can upgrade php or SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('')

RE: Year - Field type

--- -Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 February 2007 9:59 AM To: 'Mike Blezien'; mysql@lists.mysql.com Subject: RE: Year - Field type Mickalo I gave that a go now

Year - Field type

John Berman

Year - Field type

Hi Using mysql4 Sure this is an easy one a field in my dbase is year of birth, its always a 4 digit number, for some reason Im failing to sort by the field in my results, it was originally a varchar field so I updated it to int but still no luck. Pointers appreciated. Regards John Berman

RE: Year - Field type

Subject: Re: Year - Field type have you try using the datatype YEAR for you table field/column ? Mickalo - Original Message - From: John Berman [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, February 19, 2007 11:45 AM Subject: Year - Field type Hi Using mysql4 Sure

RE: Saving Image in Database [again]

Chris I'm sure that many of the experienced list members may well correct me however I started saving images in my databases and found it much simpler to simply store the image name and the path if required. Regards John Berman -Original Message- From: Chris McKeever [mailto:[EMAIL

RE: Struggling with the logic

Thanks to all for the responses, as always problem now solved and I learnt a few things. Regards John Berman -Original Message- From: Chris Sansom [mailto:[EMAIL PROTECTED] Sent: 23 July 2006 16:02 To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Struggling with the logic

Struggling with the logic

Hi I'm struggling with some logic I have a table called: submissions and each record has an approvedate field which stores the date mm/dd/ I want to display all records for 7 days only from their approved date so I guess something like Select * from submissions were

RE: Global Replace

Sound advice, I have no done as suggested and my application handles the Nulls's Thanks John B -Original Message- From: Sujay Koduri [mailto:[EMAIL PROTECTED] Sent: 30 September 2005 14:26 To: Scott Noyes; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Global Replace Yes,

Global Replace

UPDATE mc_centralgirls SET mc_centralgirls.notes = No Data WHERE (((mc_centralgirls.notes) Is Null)); but it's a big job. Can I do this at table level across all fields, or ideally at database level ? Regards John Berman -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: Hebrew

, but to be sure you may execute set NAMES latin1 before quering tables with English data. John Berman [EMAIL PROTECTED] wrote: Thanks will do this. In the same dBase there a lots of tables were the data is in English - I assume they will be ok ? John B -Original Message- From

RE: Hebrew

character_set_xxx variables to hebrew. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html John Berman [EMAIL PROTECTED] wrote: How's this +--+---+ | Variable_name| Value

RE: Hebrew

. Pointers were I went wrong would be appreciated What's the default character set for your server? Please, send us an output of the following statement: show variables like '%char%'; Please, use mysql command line client. John Berman [EMAIL PROTECTED] wrote: Using 4.1 Though I had it cracked

Hebrew

the newly created table using MSAccess or phpMyAdmin the Hebrew is represented with question marks. Pointers were I went wrong would be appreciated Regards John Berman -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03

Remove spaces

Hi I have a table with a number of fields The table is already populated, however some entries have got spaces both before and after the data. Future imports into the table will have the spaces removed, however im still stuck with my extra spaces. I have checked the Mysql manual but could not

RE: Remove spaces

update your_table set your_field = trim(your_field) --- John Berman [EMAIL PROTECTED] wrote: Hi I have a table with a number of fields The table is already populated, however some entries have got spaces both before and after the data. Future imports into the table will have

RE: Remove spaces

[mailto:[EMAIL PROTECTED] Sent: 11 February 2005 22:16 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Remove spaces Please post the error because this looks correct. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: John Berman

Hebrew Characters

for display purposes (dont think we need to search it etc) within the data set. Thoughts appreciated. Regards John Berman [EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 27/01/2005

RE: Epoch seconds

Thanks for the responses Regards John Berman -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: 14 December 2004 14:43 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Epoch seconds Here's a SQL statement that converts dates to epoch time in Oracle. I'm too

Epoch seconds

go via a query Help appreciated. Regards John Berman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Test post to test new client

Hope it works John B -Original Message- From: Robb Kerr [mailto:[EMAIL PROTECTED] Sent: 14 November 2004 17:35 To: [EMAIL PROTECTED] Subject: Test post to test new client I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb -- MySQL General

RE: Test post to test new client

Really hope it works John B -Original Message- From: Robb Kerr [mailto:[EMAIL PROTECTED] Sent: 14 November 2004 17:35 To: [EMAIL PROTECTED] Subject: Test post to test new client I'm posting to test a new newsgroup client. Please post several replies. Thanx, Robb -- MySQL

Count of two fields

Wonder if you can help I have a table with a number of fields but the List Name Member Info Ever member in the table has a list and some members have something in the info field, Im after a count by list name So for instance the result im after would be something like

Count even when empty

) Pointers appreciated Regards John Berman [EMAIL PROTECTED]

Connectiing

; This has worked fine for months but for some reason we I use the ASP pages we now get Cannot Find Server I can access the Data Source using MySQL Control Center I have replaced the url parameter with the ip address but still no joy Any pointers really appreciated. Regards John Berman [EMAIL

where its not a letter

Hi Sure this is easy Im trying to create a simple select query but I want to return records unless a field contains a C or c so would it be something like where field 'c' or 'C' Regards John B -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Is there an update limit

Is it something obvious that I'm missing? Regards John Berman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Query Help

Paul Sorry to be a pain. I'm not sure that I understand Select an extra column in each SELECT. SELECT member, ... UNION SELECT non-member, ... Regards John Berman -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 03:11 To: [EMAIL PROTECTED] Cc

RE: Query Help - Thanks

Rhino This is great it works a treat Thanks Regards John Berman -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 13:40 To: [EMAIL PROTECTED]; 'Paul DuBois' Cc: [EMAIL PROTECTED] Subject: Re: Query Help I hope you don't mind me butting in but your note

Query Help

- Not a Member List3 - Member I can do a query that show the lists some is a member or a separate query to show which they are not a member of but not a query to bring the whole thing together Pointers Appreciated. Regards John Berman -- MySQL General Mailing List For list archives: http

CR LF

Hi Using MySql 4.x Simple one this (I think) What do I actually need to use to add a CR and LF with some data that gets imported into my dbase Regards John B -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Query Help

[mailto:[EMAIL PROTECTED] Sent: 29 February 2004 00:08 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Query Help At 23:09 + 2/28/04, John Berman wrote: Hi Using MySql 4.x and need some help with a query There are two tables Lists Which holds list name +other stuff Members Which holds

RE: Query Help

+ 2/29/04, John Berman wrote: Paul Err no, new area for me this My two queries independently look like this This give me all the lists some one is not a member of SELECT lists_.Name FROM lists_ WHERE (((lists_.Name_) Not In (select members_.List_ from members_ where members_.EmailAddr_

RE: Query Help

= (' em ')) My only problem being it now lists the lists Im not a member of and the ones I am a member of - how on earth do I show on screen which is which ? Regards John Berman -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 00:47 To: [EMAIL

AND + OR Logic

logic flawed? Regards John Berman [EMAIL PROTECTED]

RE: AND + OR Logic

PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: AND + OR Logic On Thu, 12 Feb 2004, John Berman wrote: Try adding some ()s: SELECT * FROM marriage WHERE (groom_surname like (' globsurname ') or bride_surname like (' globsurname ')) and community like (' community ') -- -- MySQL

RE: A challenge I think

Thanks to all, it works fine. Regards John Berman -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 22:18 To: [EMAIL PROTECTED] Subject: Re: A challenge I think Hi, Using MySQL 4x I have two tables Lists and members Now for every list

A challenge I think

the way the system works but that is not an option Regards John Berman

RE: Converting an Access Table to MySQL

I have ported several table from access to MySQL with good results. Within Access right click on the table you are interested in and export, then select odbc data sources and off you go Regards John B -Original Message- From: Nitin Mehta [mailto:[EMAIL PROTECTED] Sent: 09 January

It may be a bit off topic

who host 4.x in the UK Regards John Berman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query +multiple tables group by

. Regards John Berman [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

multiple values in one column

Hi Using MySql 3.23 Can I have multiple values in one column and then index the column, I have used different delimiters but the index only seems find the whole contents of the column no matter what I separate the data with Regards John Berman [EMAIL PROTECTED]

RE: multiple values in one column

2 problems, It really slowed down the search and if a result was found I could not detrmine which field it was found in so drilling down was a problem. Any help would be appreciated. Regards John Berman -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: 13

RE: multiple values in one column

. Regards John Berman -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 21:32 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: multiple values in one column On Thursday, Nov 13, 2003, at 12:03 US/Eastern, John Berman wrote: I have a single

Index Question

for me, maybe I need a particular separator ? I want to go this way as each record my have several names that I want to be able to search on. Thanks in advance Regards John Berman

Index - Soundex Question

on the surname column will be updated But I have been dropping the SURNAME_SDX field and then recreating it, populating it and indexing it. Am I doing this correctly or is there a quicker way. Thanks in advance. Regards John Berman -- MySQL General Mailing List For list archives: http

Nuke_

This may be another silly question Looking at our dbase I noticed that a number of tables have been added The all start nuke_ I have no idea who added them, I can only assume my ISP added them, do they have a purpose, can I remove them etc Regards John Berman -- MySQL General Mailing

RE: Count (*) function results needed in echo statement

Renne I did a similar thing with asp, my query was like SELECT COUNT(*) AS countresult, uniqueref FROM global WHERE PROPOSEDRELEASE = 2002 and SURNAME = ' globsurname ' group by uniqueref Im my asp code I referenced countresult Hope this helps John B -Original Message- From:

Soundex Speed Up ?

? Another question In my select statement use * or actually name the fields required. Regards John Berman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Why Is my dbase slow

be appreciated. Regards John Berman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

RE: Why Is my dbase slow

is the transmission time over the network. Try running the query locally (if you can) and see if your results improve. -Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 3:06 PM To: [EMAIL PROTECTED] Subject: Why Is my dbase slow Hi Im fairly new

Full Text Restrictions

the benefit of the Boolean mode, is there any alternative? Regards John Berman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Searching should be easy ?

% ') So it will pick all those rows starting with say A or B, I have spent hours playing with the syntax so I hope its possible ? Regards John Berman - Before posting, please check: http://www.mysql.com/manual.php

Full Text Search - Exact Matches Only ?

is the against term as it only brings back exact matches so the above will only return the gold names I have tried adding a wildcard after gold ie: gold* so it would bring back everything starting with gold but to no avail. I'm sure its syntax related but I'm stuck at the moment. Regards John Berman

More on Index's

is this the right type of index for an exact match on a name , when I try to create a normal or unique Index I get the error message specified key is to long: Max key length is 500 Regards John Berman - Before posting

Search All Fields ?

%' OR b_search = b_search [POSITION] LIKE '% pSearch %' OR to build the search but I get a Query is to Complex error returned. Am I going the right way about this ? I think I can possibly index the fields and then maybe query the index ? Any pointers would be appreciated Regards John Berman

RE: MYSQL + ASP Getting Started

Hi I have on line access databases and I query them using ASP - I often create the initial in the access dbase and then use asp on the query and again this method works well. I have recently upgrade the database format to mysql but am still using ASP which I assume is ok ? Can I create queries

Field \ Table Types - Beginner

Hi Well I searched the web for answers first but there is so much its hard to know were to start I'm creating a Genealogical Database and want to start right and ensure my basic table and fields are correct (I see that I can a large variety of table types) My data is made of Names, Dates and

Operations in a select statement

statement to work if project balance it at least or greater than 90% of the Projectprice - Im sure this must be possible sqlst = select * FROM sfProducts WHERE the calculation Regards John Berman [EMAIL PROTECTED

I want to add up in a select Statement

sqlst = update sfproducts set projectdonations = projectdonations + testvalue WHERE prodID = ' sProdID ' projectdonations then = 566 so its appending rather than adding. Im sure its just a syntax thing but for the life of me I can work it out pointers appreciated. Regards John Berman

Searching

Pointer appreciated Regards John Berman [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

New to MySQL

that I install mysql on my own PC create the database structure etc and simply upload to my ISP after which I can get data into the structure via ASP \ Access \ Excel. Am I on the right lines ? Regards John Berman [EMAIL PROTECTED