Ryan Mitchell wrote: > <cfquery ....> > UPDATE FTP > SET domain = '#domains.id#', username = '#FORM.username#', password = > '#FORM.password#', <cfqueryparam cfsqltype="cf_sql_varchar" > value="#FORM.root#">, nocharge = '#FORM.nocharge#', anonymous = > #FORM.anonymous# > WHERE id = #url.id# > </cfquery>
Domain is a reserverd word in SQL. And use cfqueryparam. 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
