Re: [libreoffice-users] Parameterised query

Hi :)
It is great to see the Base section of the Faq getting worked on first.  Base needs a lot of love 
from a lot of people.  
https://wiki.documentfoundation.org/Faq#Base

Good work Markers :)
Regards from
Tom :)


--- On Wed, 29/2/12, Mark Stanton <mark@vowleyfarm.co.uk> wrote:

From: Mark Stanton <mark@vowleyfarm.co.uk>
Subject: [libreoffice-users] Parameterised query
To: users@global.libreoffice.org
Date: Wednesday, 29 February, 2012, 15:06

Hi,

Taking advice here and the French FAQ on the Wiki (now translated :-) 
), I see how to use parameters in a query.

I have a query in my database that's linked to a MySQL database and 
it just complains "The data content could not be loaded.  No value 
specified for parameter 1" with the query

SELECT      <Several fields>
FROM        <a table>
JOIN        <five other tables>
WHERE issues.Issue = ?Isssue_Num AND sent.sent = 1
    AND textvalues.Field = 'CBOSUBTYPE' 
ORDER BY    FirstName, Surname

I have tried the :Parameter form, which doesn't work either.
It works perfectly well if I give a value instead of "?Issue_Num".

Any suggestions why this doesn't work?
This is LO 3.4.5, whose Base component is presumably almost exactly 
the same as 3.5.

Mark Stanton
One small step for mankind...



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


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