Return-Path: Delivered-To: apmail-jakarta-taglibs-dev-archive@apache.org Received: (qmail 30753 invoked from network); 25 May 2002 15:28:22 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 25 May 2002 15:28:22 -0000 Received: (qmail 5800 invoked by uid 97); 25 May 2002 15:28:23 -0000 Delivered-To: qmlist-jakarta-archive-taglibs-dev@jakarta.apache.org Received: (qmail 5752 invoked by uid 97); 25 May 2002 15:28:22 -0000 Mailing-List: contact taglibs-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tag Libraries Developers List" Reply-To: "Tag Libraries Developers List" Delivered-To: mailing list taglibs-dev@jakarta.apache.org Received: (qmail 5736 invoked by uid 98); 25 May 2002 15:28:21 -0000 X-Antivirus: nagoya (v4198 created Apr 24 2002) Date: Sat, 25 May 2002 11:28:16 -0400 (EDT) From: Shawn Bayern X-Sender: bayern@precision To: Tag Libraries Developers List , steve.olson@ait-inc.com Subject: RE: Startard Taglib- SQL bind variables In-Reply-To: <005c01c202ad$0f64feb0$6e00a8c0@epic.aitinc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N On Thu, 23 May 2002, Steve A. Olson wrote: > Right, to avoid that danger the SQL statement must be pre-processed to > substitute any scripting variables into actual SQL bind variables > using a preparedStatement. This avoids the SQL syntax errors when > variables are null or have no value. Perhaps using :variables would > avoid the EL parsing. Hi Steve -- Thanks for the suggestion, but it's too late to change how JSTL 1.0 will work. I personally once considered a variation on this model, using inline in a query instead of relying on PreparedStatement-syle placeholders, as: UPDATE tablename SET foo = WHERE foo = Ultimately, relying on the JDBC-standard mechanism should take better advantage of existing mindshare and might even interoperate better. (I know of environments where ?-escaped queries are stored in property sheets, for instance.) But still, it's not a bad thought. I suggest mailing jsr-52-comments@jcp.org to make sure it's on a list for items to consider after JSTL 1.0. Thanks again for the suggestion! -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming in July 2002 from Manning Publications) -- To unsubscribe, e-mail: For additional commands, e-mail: