On Tue, 3 Dec 2002 17:00:38 +0100, Jochem van Dieten wrote: > 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.
Even if the variable won't ever contain a "\" like the destination field? > > 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 Get the mailserver that powers this list at http://www.coolfusion.com