Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-07-07 Thread Tom Davies
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 leean...@gmail.com wrote:

From: leeand00 leean...@gmail.com
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=65832thanks=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?

2012-07-05 Thread leeand00
Okay for anyone who's interested I submitted the bug here:
http://bugs.mysql.com/bug.php?id=65832thanks=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



[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-07-05 Thread leeand00
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



Re: [libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-06-05 Thread Tom Davies
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 leean...@gmail.com wrote:

From: leeand00 leean...@gmail.com
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?

2012-06-03 Thread Alexander Thurgood
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



[libreoffice-users] Re: Invalid descriptor Index 07009 when using a query parameter?

2012-06-03 Thread Alexander Thurgood
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?

2012-06-01 Thread Alexander Thurgood
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