Yes, and that's what I'm doing now -- but it means the database has to
re-parse each query (because each one will be textually different) which
can be a significant performance hit. It also means you can't take
advantage of app server PreparedStatement caches, etc.
Also, if you're inserting string values, it requires you to encode the
strings using vendor-specific escaping rules to avoid syntax errors and
opens the door to code-insertion hacks.
Bind variables are far preferable in almost every situation.
-Steve
Tyler Pitchford wrote:
Couldn't you just do:
"mytable.id = othertable.mytableid " +
"AND othertable.recordtype = " +
parameter
I mean it's a string construction you're doing anyway, couldn't you
just append to the string with the parameter?
Cheers,
Tyler
P.S. Please not I haven't looked at the docs on what the joinOuter
method from RIFE specifically requires.
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
