It does, but it still looks like it's a little more clunky (in my opinion at least :)) than the tag-based alternative. Bummer, since I much prefer the succinct style of CFSCRIPT for writing pretty much everything else in a component.
Thanks for your help everyone! >var q = new com.adobe.coldfusion.query(); >q.setDatasource("cfartgallery"); >var sql = "select mediatype from media"; >if(structKeyExists(arguments, "something")) { > sql &= " where media like :search"; > q.addParam(name="search",value="%#arguments.str#%",cfsqltype="cf_sql_varchar"); >} >q.setSQL(sql); >var results = q.execute().getResult(); > >Does that make sense? > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm