LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

yunfengwu@yahoo.com — 2005-03-23T09:08:01

It did happen on some my servers, all the "CFUPDATE" got the same error "[Macromedia][Oracle JDBC Driver]Invalid parameter binding(s).", and this "CFUPDATE" can work on other servers.

coldfusion/6.1/htmldocs/tags-c19.htm

2004-12-13T10:30:55

This is just FYI. You might get an error code that looks like this

[Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).

I got this error code on the cfupdate tag with a listed formfield. The error has an error, if you can imagine.

on the debug info I noticed that it was trying to find a column named TYPETITLEABSTRACT.= (param 4) Im my table those are 3 columns. The actual problem is that I have a column (none of the 3) specified in the form fields that is not in the table. However the error does not tell you that. You might be wasting your time trying to find out why CF is trying to combine those fields. It as simple as making sure the fields are available.

coldfusion/6.1/htmldocs/tags-c19.htm

wlee — 2004-03-24T07:30:55

We are working to improve the examples in the ColdFusion reference pages. We propose to replace the current example on this page with the the following example. If you have any comments on this example, add them to this page.

tablename="Employees">

select * from employees

#firstName#

#lastName#

#phone#

Edit

select * from employees where emp_id=#url.id#

coldfusion/6.1/htmldocs/tags-c19.htm

halL — 2004-03-02T06:46:15

In response to Malvina: The word lies should be keys.

In response to MarkZet: If you specify only the primary key, you are asking the database to update no fields in the table. ColdFusion generates an invalid SQL expression as a result (an empty set clause). We have submitted a bug (54462) against the fact that ColdFusion does not catch and report the invalid formfields value before generating the SQL and sending it to the data source.

coldfusion/6.1/htmldocs/tags-c19.htm

MarkZet — 2004-03-02T04:01:00

I've found that if ONLY the primary key is passed in the fieldlist, an error occurs ("You have an error in your SQL syntax").

coldfusion/6.1/htmldocs/tags-c19.htm

Malvina — 2004-02-11T12:37:52

I do not understand this sentence:

"The formFields lies must include the database table primary key field, which must be present in the form. It can be hidden. "

comment
My experience with cfupdate is:
In cf 5 it was not necessary to include the formfields. In MX 6.1 it is required, otherwise I get an error of a missing key field.

coldfusion/6.1/htmldocs/tags-c19.htm

halL — 2003-09-17T14:30:31

There are several problems with this example.

First, the cfsnippets Access database Courses table uses Name as a field name.
This is an Access reserved word and causes errors in cfupdate.

Second, the example code inconsistently uses Name and Course_Name for the field name.

Third, the example code attempts to include an mm_browsersniff.cfm file that is not likely to exist.

ColdFusion bugs 53454 and 53455 have been logged against these issues.

The following example code will work IF you rename the Number field to Course_Number in the snippets database.
It must be saved as index.cfm to work.

tablename="Courses"
formfields="Course_ID,Course_Number,Descript">

SELECT Course_Number, Course_ID, Descript
FROM Courses

WHERE Course_ID = #Trim(url.Course_ID)#

ORDER by Course_Number

CFUPDATE Example

CFUPDATE Example

width=10 header="Edit
this Entry">

coldfusion/6.1/htmldocs/tags-c19.htm

Pat Lib — 2003-09-17T08:39:18

Following your example exactly, I made a live database test. All seems fine, except that the did not do ANYTHING.
No data change happend.
I am not sure if this is a problem on or on the sample codes in this doc.
If you would like to follow up, I will be more than happy to provide you my test codes and db results.

Thanks!

LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

coldfusion/6.1/htmldocs/tags-c19.htm

CFUPDATE Example

You can alter the contents of this record, and then click "Update" to use CFUPDATE and alter the database

coldfusion/6.1/htmldocs/tags-c19.htm

You can alter the contents of this record, and then click "Update"
to use CFUPDATE and alter the database