> I have a JSP application that I need to maintain and I was > wondering if there is a equivalent to CFQUERYPARAM in JAVA/JSP.
Yes, what you're looking for is a "prepared statement". JDBC supports prepared statements, so any Java programs that use JDBC can take advantage of this - that's all that CFQUERYPARAM does. Google "jsp prepared statement" for more info. Of course, in a properly-structured Java web application, I don't think you'd put SQL in your JSPs, but rather in other Java classes that would be used by your JSPs. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4