I think Sam found the problem. I agree with Sam and I highly encourage
people to format your SQL statement so you can see what you're missing. ;)
UPDATE FTP
SET domain = ..,
username = ..,
password = ..,
nocharge = ..,
..???... = ..,
WHERE id = ..
~Todd
At 08:33 PM 1/17/2003 +0100, you wrote:
>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
----------
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
