> > This isn't really correct. The query isn't compiled in any case. >
Ok, so I found out I WAS correct. Either that or yet another article I found on prepared statements is wrong. Here's a quote from the article: "The PreparedStatement object contains not just an SQL statement, but an SQL statement that has been precompiled. This means that when the PreparedStatement is executed, the DBMS can just run the PreparedStatementSQL statement without having to compile it first." So according to this, the SQL statement IS precompiled, as I had asserted. Here's the article: http://download.oracle.com/javase/tutorial/jdbc/basics/prepared.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm