Talk:Change twp

From TNG_Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

TO BE READ FROM BOTTOM EMAIL UP ...

From: Joyaa Antares Sent: Saturday, June 18, 2011 8:09 PM To: Henny Savenije Subject: Re: [tngusers2] Using MySQL to globally edit a "place"


Hi Henny,

I think that I understand what you are saying on the wiki. How about this:

Some people like to write twp where there is a township mentioned. This query changes that to Township. This query is intended if you already have everything set to Township but you import a gedcom where there are still twp's. If you want to change the whole database you will have to replace the DELETE statement with UPDATE tng_places REPLACE(place, 'Twp.','Township') in the first set of queries and with UPDATE tng_places REPLACE(place, 'Twp','Township') in the second set.

It’s partly only cosmetic grammatical change but I have also

  • moved a “;”
  • changed the final ‘Twp.’ to ‘Twp’
  • and, following your tip, removed the space after the word REPLACE.

Warm regards, Joyaa

From: Henny Savenije Sent: Saturday, June 18, 2011 6:58 PM To: Joyaa Antares Subject: Re: [tngusers2] Using MySQL to globally edit a "place"

At 03:55 PM 6/18/2011, you wrote: Hello Henny,

Thanks for this. Re. that link, please can you explain to me “In case you want to change the whole database you will have to replace the DELETE statement with UPDATE tng_places REPLACE (place, 'Twp.','Township'); in the first set of queries and to UPDATE tng_places REPLACE (place, 'Twp.','Township');” There seems to be some words missing in the last phrase.

Cheers, Joyaa