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 ('') S

RE: Year - Field type

Australia invent ------- -Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 February 2007 9:59 AM To: 'Mike Blezien

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: Sent: Monday, February 19, 2007 11:45 AM Subject: Year - Field type > Hi > > Using mysql4 >

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

Year - Field type

John Berman

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

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 appro

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

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

RE: Hebrew

emain unchanged, 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

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

RE: Hebrew

Hello. > 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]>

Hebrew

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

RE: Remove spaces

m Crimmins [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- > F

RE: Remove spaces

paces 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. > &

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 f

Hebrew Characters

display purposes (don’t 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&

Epoch seconds

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

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 Gener

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 Maili

Count even when empty

) Pointers appreciated Regards John Berman [EMAIL PROTECTED]

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 L

Connectiing

xx;" 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 Joh

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 unsubscri

Is there an update limit

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

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 0

RE: Query Help

lists_.Name_ WHERE (members_.EmailAddr_ = ('"& 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 [m

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_

RE: Query Help

I feed in John B -Original Message- From: Paul DuBois [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 >

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

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

RE: AND + OR Logic

EMAIL 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 ('"&

AND + OR Logic

#x27;) or bride_surname like ('"& globsurname & "') and community like ('"& community & "') Its like the AND is being ignored when I add the OR I my basic logic flawed? Regards John Berman [EMAIL PROTECTED]

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 fo

A challenge I think

ould change 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 20

It may be a bit off topic

ISP's 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

) and on the first pass return how many searched names it found per set. The user will then be able to focus on a set if required. 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: multiple values in one column

gle 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

RE: multiple values in one column

urname = '"& globsurname & "' or bridesurname = '"& globsurname & "'group by uniqueref" This gave me 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 wa

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]

Index Question

I have say: Surname: smith jones It does not seem to work 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

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

Index - Soundex Question

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

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

Soundex Speed Up ?

correct help on how to do this would be appreciated ? Another question In my select statement use * or actually name the fields required. Regards John Berman - Before posting, please check: htt

RE: Why Is my dbase slow

Part of the time that is calculated 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] Subje

Why Is my dbase slow

s would 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 P

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

Searching should be easy ?

(SURNAME, GROOMSURNAME, BRIDESURNAME) Like (' "& globsurname & "% ') " 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 ---

More on Index's

- how can that be, other names work fine My index is fulltext 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 -

Full Text Search - Exact Matches Only ?

quot; Problem now 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

Search All Fields ?

arch & "%' 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 an

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 occ

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 w

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

I want to add up in a select Statement

and if I do this and say testvalue is 66 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 thin

Searching

ike '%"term&"%'" SQL = SQL & " Or Forenames Like '%"&term&"%'" etc this if fine for single words like smith, jone etc but how do I search using say berman and Devon Pointer appreciated Regards John Berman [EMAIL PROTECTED] --

Security

Hi Still fairly new to this and I'm using mysql-front for administration which makes life really easy. Anyway as I'm now adding tables etc should I be creating a new user to access them, I'm thinking of the web users, or can I use the default user set-up by my ISP Regards Joh

New to MySQL

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