I see your problem: You are not setting your cfqueryparam to a field: ,<cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.root#">, etc...
Should be like the others: , root = <cfqueryparam cfsqltype="cf_sql_varchar" value="#FORM.root#">, See it? You're missing the "something=" in front of the cfqueryparam HTH, Ryan Kime -----Original Message----- From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 12:46 PM To: CF-Talk Subject: Last one, I think... Ok, I've got a handle on this, and got rid of all but one error... Thanks for all the help guys.. <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> And I'm getting this error.... Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax near ''c:\\webserver\\rthosting.net\\www\\boo', domain = '1' WHERE ID = 5' at line 1 I think the problem is the id = bit but I tried using tinyint etc and it wont work, anyone else shed any light? Ryan � ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
