Talk:Change twp

From TNG_Wiki
Revision as of 17:01, 18 June 2011 by Joyaa (talk | contribs) (Changes to Henny's twp page)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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