Re: [libreoffice-users] Re: Mailmerge from query broken in 3.4.6?

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