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
