On Wed, 2012-02-29 at 15:06 +0000, 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".
hmm, well one problem is that the correct syntax is :Issue_Num NOT ?Issue_Num Make that change and you should be good to go. //drew > > 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: [email protected] 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
