Hi to all oracle, coldfusion gurus
Using coldfusion, i can succesfully retrieve records. However, when i update, i get the ora-01747 message.
The cold fusion script is below
<cfquery datasource="#this.psdatasource#" name="Update_Personal">
ADDRESS1=<cfqueryparam value="#qrData.HomeAddress1#" cfsqltype="cf_sql_varchar" >,
EMPLID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#qruserData.emplid#">
<cfoutput>"Database Personal_data error has occured"</cfoutput>
The error message is below
"Database Personal_data error has occured" HY000,Error Executing Database Query.,[Macromedia][Oracle JDBC Driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification
However all the tables, user and columns exist as proven by the select table.
A value I was passing to a query, had a #NumberFormat(query.value)# formatting on it. It was passing 1,500 vs. 1500.
The error occured because the datatype in the database was number(11),
and the comma (1,500) from the NumberFormat() formatting was throwing it off.
I took off the NumberFormat() and just passed #query.value# and the problem went away.