On 29/02/2012 16:06, Mark Stanton wrote:
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?
a typo in ?Isssue_Num (3s) ? greetz Fernand
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+h...@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
