Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Hi :) Nicely done :) The subsequent link you gave was a link to the LO form to fill-in rather than to the specific bug-report you created. Ideally it would be great to have a link to the specific bug report in the one posted to the other project, eg In the MySql report a link given to the report submitted to LO & In the LO report a link given to the MySql one. It helps if the devs can get their heads together more easily rather than just blaming the other project ;) I'm not sure devs do that but most people would in similar circumstances. Regards from Tom :) --- On Fri, 6/7/12, leeand00 wrote: From: leeand00 Subject: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter? To: users@global.libreoffice.org Date: Friday, 6 July, 2012, 2:41 Okay for anyone who's interested I submitted the bug here: http://bugs.mysql.com/bug.php?id=65832&thanks=sub Enjoy! -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
I also posted it here: https://www.libreoffice.org/get-help/bug/ -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993952.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Okay for anyone who's interested I submitted the bug here: http://bugs.mysql.com/bug.php?id=65832&thanks=sub Enjoy! -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3993950.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Hi :) There are 2 good links to help people post bug-reports http://wiki.documentfoundation.org/BugReport https://www.libreoffice.org/get-help/bug/ I think you will find the first one, the wiki one, is more useful to you for reporting this Good luck and regards from Tom :) --- On Fri, 1/6/12, leeand00 wrote: From: leeand00 Subject: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter? To: users@global.libreoffice.org Date: Friday, 1 June, 2012, 16:18 Is there a place I can submit the bug? -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3987415.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Le 01/06/12 16:31, leeand00 a écrit : Hi, > Is the LO-MySQL specific connector the same as the MySQL ODBC driver? Or > would it be something I could use in place of it? They are different, and you can use it in place of the ODBC driver. However, I note that you mention parameter substitution - I have not been able to get this to work with my queries (which require direct SQL execution, rather than parsing via LO's parser) and the native mysql connector. Perhaps I'm just doing something wrong, but it has simply never worked for me with the native mysql connector - I seem to recall that it did with the ODBC driver though. Alex -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Le 01/06/12 17:18, leeand00 a écrit : Hi, > Is there a place I can submit the bug? I would try here : http://bugs.mysql.com/ Alex -- 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
Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
On 06/01/2012 10:31 AM, leeand00 wrote: > Jay, > > thank you for your reply, > > Is the LO-MySQL specific connector the same as the MySQL ODBC driver? Or > would it be something I could use in place of it? The Ubuntu repository list a specific libreoffice-mysql-connector. I assume it is different than the standard MySQL ODBC driver which I understand is for use with ODBC complaint front-end. > > I have relatively the same setup on a Windows machine that I have, and it's > ODBC seems to be able to handle parameters in MySQL. > > Thanks again, >Andrew J. Leer > > -- > View this message in context: > http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3987387.html > Sent from the Users mailing list archive at Nabble.com. > -- Jay Lozier jsloz...@gmail.com -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Is there a place I can submit the bug? -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3987415.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Le 01/06/12 15:19, leeand00 a écrit : Hi, > - You tried to set a parameter at position '1' but there is/are only '0' > parameter(s) allowed. One reason may be that the property > "ParameterNameSubstitution" is not set to TRUE in the data source. > > I found a thread on google concerning this same error in which someone said > checking off all of the Edit->Database->Advanced Settings options would > cause it to work, but I tried that, and even restarted Base, with out any > success, leading to the same error. Yes, that should've done the trick, but recent versions of the 3.51.x ODBC driver supplied by MySQL/Oracle are unfortunately somewhat buggy, and from experience such bugs can go unfixed for rather long periods of time. Nothing to do with LibreOffice either, generally. Alex -- 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
[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?
Jay, thank you for your reply, Is the LO-MySQL specific connector the same as the MySQL ODBC driver? Or would it be something I could use in place of it? I have relatively the same setup on a Windows machine that I have, and it's ODBC seems to be able to handle parameters in MySQL. Thanks again, Andrew J. Leer -- View this message in context: http://nabble.documentfoundation.org/Invalid-descriptor-Index-07009-when-using-a-query-parameter-tp3987364p3987387.html Sent from the Users mailing list archive at Nabble.com. -- 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