Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


On 09/28/2012 08:43 AM, Mark Stanton wrote:
Ok, a little more information, because I've now fixed the problem and
have a bit more idea of the scope of the mess, which is huge, I'd
say.

This mailmerge is linked to a query in a MySQL database.

My query couldn't use the query wizard (Andreas won't be surprised).
In coding the query I wrote the field names in camelcase (eg
"Address1", "PersonName"), the actual database fields are all in
lowercase.  Changing this made the mailmerge show data.
However, the query worked prior to that, and in fact the hidden
paragraph conditions worked correctly, even though they were also in
camelcase.

Interestingly, calculated fields given camelcase names with "AS"
work!  Uncalculated fields given names (eg `Address1` AS `Address1`)
don't.

Interestingly, again, it seems that some conditional statements don't
work the way they used to, either.

Am I talking complete rubbish here, or are others finding similar
things?

Regards
Mark Stanton
One small step for mankind...
A few questions: If you are using the Fedora repo, might the problem be with the that (probably not)? Have you tried using a View instead of a Query? Could you provide us with the SQL statement used to create the query? This would make creating a database to test the problem much easier for us. I don't know if this has anything to do with anything: from the definition I found on camelcase, /person name/ is written personName. (The first word is NOT capitalized.) What about using single quotes vs double quotes when giving fields an alias? I thought that double quotes should be used in such cases. Don't single quotes and double quotes have different purposes when used in a SQL statement?

--Dan

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.