Nope fraid not, the field is a text field intentionally :) Any other thoughts?
On 17/1/03 18:50, "Todd" <[EMAIL PROTECTED]> wrote: > 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 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
