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
On 17/1/03 19:01, "Todd" <[EMAIL PROTECTED]> wrote:
> anonymous = #FORM.anonymous# ..?
>
> anonymous = '#FORM.anonymous#' ?
>
> Without seeing the data types of the column I can sit and guess all
> day. Why are you mixing / matching CFQUERYPARAMs? Why do you have one
> there, but you don't have the others in there?
>
> ~Todd
>
> At 06:56 PM 1/17/2003 +0000, you wrote:
>> 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
>
>
>
> ----------
> 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
