Domain = '#domains.id#' Should be:
Domain = #domain.id# No single quotes around integers. ~Todd At 06:46 PM 1/17/2003 +0000, you wrote: >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 ---------- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ ---------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
