On Mon, Dec 20, 2010 at 8:59 PM, Rob Voyle <[email protected]> wrote: > Yes Why? the quotes > I have other query's where it works fine without quotes.
If you have a numeric column then #var# will work. If you have a varchar column, you need '#var#' because the SQL syntax requires a 'string'. But I'd recommend you learn to use <cfqueryparam> because then you won't have this problem - and you will also be protected from SQL injection attacks, as well as possibly getting better performance out of your code. where programCode1 = <cfqueryparam cfsqltype="cf_sql_varchar" value="#program#"> You don't need to worry about the format of your values with <cfqueryparam> -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:340184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
