Domain = '#domains.id#'
Should be:
Domain = #domain.id#
No single quotes around integers.
~Todd
At 06:46 PM 1/17/2003 +, 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 =
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 +, you wrote:
Ok, I've got a
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 +, you
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
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 +, you wrote:
Try this, same error different query...
cfquery
There's an error in the directory field. The very last set clause, with
the query param, has a parameter but no field. Reformatted this is easy to
see:
UPDATE PPD
SET
username = '#FORM.username#',
password = '#FORM.password#',
domain = '#domains.id#',
I see your problem:
You are not setting your cfqueryparam to a field:
,cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.root#, etc...
Should be like the others:
, root = cfqueryparam cfsqltype=cf_sql_varchar value=#FORM.root#,
See it? You're missing the something= in front of the cfqueryparam
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
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
9 matches
Mail list logo