Quoting FlashGuy <[EMAIL PROTECTED]>: > > I did and I still get "?" inserted in the database? > > <cfquery name="update_alias" DATASOURCE="Alias"> > UPDATE alias > SET > env_var = <cfqueryparam value="#FORM.env_var#" > cfsqltype="CF_SQL_LONGVARCHAR">, > destination = <cfqueryparam value="#FORM.destination#" > cfsqltype="CF_SQL_LONGVARCHAR"> > WHERE alias_ID = #FORM.alias_ID# > </cfquery>
Can you show us the query debug output? And you really should convert that last pass through variable into a cfqueryparam too. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
