Re: [farcry-dev] ERROR with SQLWHERE clauses

2010-12-07 Thread Blair McKenzie
I think Railo has an option to always preserve single quotes, how is your server set up? Blair On Wed, Dec 8, 2010 at 8:54 AM, Matthew Williams < webmas...@geodesicgrafx.com> wrote: > Further, execute templates with this: WHERE status IN > ('#ListChangeDelims(request.mode.lValidStatus,"','",",")

Re: [farcry-dev] ERROR with SQLWHERE clauses

2010-12-07 Thread Matthew Williams
Further, execute templates with this: WHERE status IN ('#ListChangeDelims(request.mode.lValidStatus,"','",",")#') are not working when in draft, pending, etc. I had to change it to WHERE status IN ("#ListChangeDelims(request.mode.lValidStatus,'","',",")#"). Matthew Williams Geodesic GraFX ww

[farcry-dev] ERROR with SQLWHERE clauses

2010-12-07 Thread Matthew Williams
All, I'm seeing problems where there are any custom SQL calls in customlist objects in the latest round of RCs for Railo. I cannot explain why, because the query runs correctly, but it then goes on to through an error about "blah blah ' '' ' has an error near SQL statement blah. It's doubling up