<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Parameter index out of range (1 > number of parameters, which is 0)." href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Parameter index out of range (1 > number of parameters, which is 0)." href="https://bugs.documentfoundation.org/show_bug.cgi?id=118112">bug 118112</a> from <a class="email" href="mailto:mcmurchy1917-bugzilla@yahoo.co.uk" title="Alex Kempshall <mcmurchy1917-bugzilla@yahoo.co.uk>"> Alex Kempshall</a> <pre>The commit that caused this regression was to fix bug tdf#104986. In that bug report there's a discussion (In reply to Lionel Elie Mamane from <a href="show_bug.cgi?id=118112#c18">comment #18</a>) > There is probably a much more robust way to do it... One only has to grossly > lex the SQL, just keeping track of whether on is inside a '-delimited string > or a "-delimited identifier. And outside of that, replace any word that > starts with ":" with "?". In GDB of tdf#118112 I see this Thread 7 "UNO AffineBridg" hit Breakpoint 1, connectivity::java_sql_Connection::prepareStatement (this=0x35f5350, sql="SELECT * FROM `btuc`.`tblBTUC_details` WHERE ( `btuc`.`tblBTUC_details`.`Contact_ID` = :link_from_Contact_ID )") at /home/alex/master/connectivity/source/drivers/jdbc/JConnection.cxx:474 474 java_sql_PreparedStatement* pStatement = new java_sql_PreparedStatement( t.pEnv, *this, sql ); Does this mean that :link_from_Contact_ID is being changed to ? and causing the bug that I'm seeing.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>