Not being mean, but how about doing yourself a favor and putting all the <cfqueryparam> in there? It'd save your time and ours. With cfsqltype="..whatever.." being declared there's no mistake.
~Todd At 07:09 PM 1/17/2003 +0000, you wrote: >Try this, same error different query... > > > <cfquery ...> > UPDATE PPD > SET username = '#FORM.username#', password = '#FORM.password#', domain = >'#domains.id#', <cfqueryparam cfsqltype="cf_sql_varchar" >value="#FORM.directory#"> > WHERE ID = #url.id# > </cfquery> > >Im only using the queryparam for the directory as it needs to have '\'s in >it, everything else works fine without them.... > >Username, password, domain, directory are all of type tinytext. >Id is of type tinyint(4). > >Ryan ---------- 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
