I've been having a slight issue when using ColdFusion to save to a MS SQL db.
If I use the SQL statement method to save, it ends up working fine. But if I use the CF code version to save, it does not work. The processing page does not even load, which typically tells me there's an issue with a field or data type. I know all the field are correct, but the data type should be correct too. At first I thought it was a problem with the field size, but that was before I tried the SQL statement method to save and found that it worked.
Has anyone else had this issue?
Thanks!
Lance
If I use the SQL statement method to save, it ends up working fine. But if I use the CF code version to save, it does not work. The processing page does not even load, which typically tells me there's an issue with a field or data type. I know all the field are correct, but the data type should be correct too. At first I thought it was a problem with the field size, but that was before I tried the SQL statement method to save and found that it worked.
Has anyone else had this issue?
Thanks!
Lance