[sword-devel] Per Project news: - was Re: CrossWire news

[Greg Hellings]

Sounds like you are manually constructing your SQL instead of using a
prepared statement with bound variables? That should take care of the
problem.

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