Answered
cfselect bind stopped working
Hi Gang-
I have a relatively simple cfselect chain where the 2nd select is populated based on the selected value from the first.
select 1: <cfselect name="customerid" required="yes" query="allCompanies" value="id" display="name" />
select 2: <cfselect name="contactid" bind="cfc:Controller.Controller.getCustomerContact({customerid})" bindonload="yes" />
It works on my dev system, WAS working just fine on my client's production box but now throws the following error when the page gets requested:
"Error invoking CFC /controller/Controller.cfc : Internal Server Error. Add cfdebug to your url for more info."
What I know and have tried so far:
-As far as I know nothing was changed on the client's production box.
-I added cfdebug to the URL and all I get is "Internal Server Error", referencing the method in the cfc with the first value from select field 1. I'm unable to learn anymore about what exactly the "Internal Server Error" is; I've tried cftry/cfcatch, I've also tried cflog and cannot, for the life of me, pin down what the CF server means by "Internal Server Error".
-In my process of debugging I think: What is different from my system and the client's system? And/or, what could have changed causing it to break?
-The data from the database, which I scrubbed and replaced any potentially troubling characters (ampersands, single quotes, etc. - even though CF has handled them just fine in the past).
-The browsers, the exact versions of ColdFusion and the database drivers all appear to be exactly the same on both systems.
Anyone have any experience with the cfselect bind suddenly failing? How were you able to trap the error, and more precisely what it means? I've looked in all of the log files, and like I said above, even in my own cflog I'm unable to learn anymore about what "Internal Server Error" means.
The one thing I have not yet tried which is actually next on my list (but I thought I'd fish on the forums before I try this) is to wrap up everything on my dev box for this client's site into a .CAR file and deploy onto their system. But now the actual problem isn't so much the bug, it's what's causing it that I must understand.
Thanks in advance for your help,
Rich
I have a relatively simple cfselect chain where the 2nd select is populated based on the selected value from the first.
select 1: <cfselect name="customerid" required="yes" query="allCompanies" value="id" display="name" />
select 2: <cfselect name="contactid" bind="cfc:Controller.Controller.getCustomerContact({customerid})" bindonload="yes" />
It works on my dev system, WAS working just fine on my client's production box but now throws the following error when the page gets requested:
"Error invoking CFC /controller/Controller.cfc : Internal Server Error. Add cfdebug to your url for more info."
What I know and have tried so far:
-As far as I know nothing was changed on the client's production box.
-I added cfdebug to the URL and all I get is "Internal Server Error", referencing the method in the cfc with the first value from select field 1. I'm unable to learn anymore about what exactly the "Internal Server Error" is; I've tried cftry/cfcatch, I've also tried cflog and cannot, for the life of me, pin down what the CF server means by "Internal Server Error".
-In my process of debugging I think: What is different from my system and the client's system? And/or, what could have changed causing it to break?
-The data from the database, which I scrubbed and replaced any potentially troubling characters (ampersands, single quotes, etc. - even though CF has handled them just fine in the past).
-The browsers, the exact versions of ColdFusion and the database drivers all appear to be exactly the same on both systems.
Anyone have any experience with the cfselect bind suddenly failing? How were you able to trap the error, and more precisely what it means? I've looked in all of the log files, and like I said above, even in my own cflog I'm unable to learn anymore about what "Internal Server Error" means.
The one thing I have not yet tried which is actually next on my list (but I thought I'd fish on the forums before I try this) is to wrap up everything on my dev box for this client's site into a .CAR file and deploy onto their system. But now the actual problem isn't so much the bug, it's what's causing it that I must understand.
Thanks in advance for your help,
Rich
AdChoices