Was struggling with Coldfusion 2018 and Access and then I found UCanAccess. I was very excited to finally see my database connecting. Then it fell apart...
This issue I am seeing is that a CF Insert returns an error message.
Error Executing Database Query.
UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast
In troubleshooting, I reduced the number of items, in my query, to insert down to one, just to see if I had a field type mismatch, but still errors out. The item being inserted is the number 1 and the field type in the database for that column is "Yes/No"
Error Executing Database Query.
UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast
The error occurred in C:/inetpub/wwwroot/employee/emp_add_action.cfm: line 3
1 : <cfquery name="insertrecord" datasource="employees">
2 : INSERT INTO emp (NewHire)
3 : VALUES ('#form.NewHire#')
4 : </cfquery>
The database was a .mdb file, have since changed it to a .accdb file to no avail.
I have been slamming my head against my desk for weeks now, any help would be greatly appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Was struggling with Coldfusion 2018 and Access and then I found UCanAccess. I was very excited to finally see my database connecting. Then it fell apart...
This issue I am seeing is that a CF Insert returns an error message.
Error Executing Database Query.
UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast
In troubleshooting, I reduced the number of items, in my query, to insert down to one, just to see if I had a field type mismatch, but still errors out. The item being inserted is the number 1 and the field type in the database for that column is "Yes/No"
Error Executing Database Query.
UCAExc:::5.0.0-SNAPSHOT data exception: invalid character value for cast
The error occurred in C:/inetpub/wwwroot/employee/emp_add_action.cfm: line 3
1 : <cfquery name="insertrecord" datasource="employees">
2 : INSERT INTO emp (NewHire)
3 : VALUES ('#form.NewHire#')
4 : </cfquery>
The database was a .mdb file, have since changed it to a .accdb file to no avail.
I have been slamming my head against my desk for weeks now, any help would be greatly appreciated.