<p>Sounds like you are manually constructing your SQL instead of using a prepared statement with bound variables? That should take care of the problem.</p>
<p>--Greg</p>
<div class="gmail_quote">On Feb 14, 2011 7:32 AM, "Ben Morgan" <<a href="mailto:benpmorgan@gmail.com">benpmorgan@gmail.com</a>> wrote:<br type="attribution">> Vary the following:<br>> <a href="http://www.crosswire.org/pages/crossnewstest.jsp?project='&class=2&percat=3&maxRes=6">http://www.crosswire.org/pages/crossnewstest.jsp?project='&class=2&percat=3&maxRes=6</a><br>
> <br>> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL<br>> Error SQL error code = -104 Unexpected end of command - line 1, column 379<br>> <br>> Other than that (and a number of variations on it), it seems to work (i.e.<br>
> for validly constructed URLs it works).<br>> <br>> God Bless,<br>> Ben<br>> -------------------------------------------------------------------------------------------<br>> Multitudes, multitudes,<br>> in the valley of decision!<br>
> For the day of the LORD is near<br>> in the valley of decision.<br>> <br>> Giôên 3:14 (ESV)<br>> <br>> <br>> <br>> On Tue, Feb 15, 2011 at 12:23 AM, Peter von Kaehne <<a href="mailto:refdoc@gmx.net">refdoc@gmx.net</a>> wrote:<br>
> <br>>> I have now in a test file added the code to have a project parametre.<br>>><br>>> You can see it here in action:<br>>><br>>><br>>> <a href="http://www.crosswire.org/pages/crossnewstest.jsp?project=8&class=2&percat=3&maxRes=6">http://www.crosswire.org/pages/crossnewstest.jsp?project=8&class=2&percat=3&maxRes=6</a><br>
>><br>>> Please test it and if you manage to crash it, tell me what i did wrong. The<br>>> underlying sql statement is pasted to the bottom of the page underneath.<br>>><br>>> The idea is that you can combine news from your particular project and news<br>
>> from e.g the "module factory", which I guess is nice to advertise your<br>>> particular frontend and the modules you can display (which obviously won't<br>>> work if your frontend has display or logic deficiencies)<br>
>><br>>> There are a few half or totally abandoned projects strewn across the site<br>>> and i will add it there to show how it would look for them. Others can then<br>>> see if they want to make use of the facility.<br>
>><br>>> I will also in the next few days try and make the production of tailored<br>>> rss feeds similarly straight forward and then throw a bunch of such feeds in<br>>> a well accessible place - particularly also for externally hosted projects<br>
>> this might be of use.<br>>><br>>> Peter<br>>><br>>><br>>><br>>><br>>> --<br>>> GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit<br>>> gratis Handy-Flat! <a href="http://portal.gmx.net/de/go/dsl">http://portal.gmx.net/de/go/dsl</a><br>
>><br>>> _______________________________________________<br>>> sword-devel mailing list: <a href="mailto:sword-devel@crosswire.org">sword-devel@crosswire.org</a><br>>> <a href="http://www.crosswire.org/mailman/listinfo/sword-devel">http://www.crosswire.org/mailman/listinfo/sword-devel</a><br>
>> Instructions to unsubscribe/change your settings at above page<br>>><br></div>