dplaut
|
| Posted: 01/15/2002, 8:33 AM |
|
The TaskMan demo from the web site and the one supplied in my examples directory behaves differently in ColdFusion.
The one downloaded from the web site works fine.
The one installed into my examples folder (upon installing CodeCharge) causes an ODBC error that the resolution field cannot be a zero length field. Everything else works fine.
I can't figure out what the difference is between the two version that would be causing this error.
Note: I converted the TaskMan in the example folder from ASP to ColdFusion.
What the heck is the fix?
|
|
|
 |
Alex Alexapolsky
|
| Posted: 01/16/2002, 2:46 AM |
|
For the time being I can just tell that there may be some differences between
examples in CC and the ones on this site as the latter may be generated with
earlier version of CC. Does it happen on all pages in this example ?
What about other examples ?
|
|
|
|
dplaut
|
| Posted: 01/17/2002, 5:32 AM |
|
In this particular app this only happens when trying to insert or update a task. It does not happen in the admin features, such as updating lookup tables.
The problem is that if you leave a memo field blank (such as the resolution field) CC tries to insert a zero length string into the field which causes an error. But the older example works OK and I can't figure out why.
I have not had a chance to check other examples. The two examples were definately made with different version of CC. The one that works correctly (the one on the examples web page) was made with an earlier version of CC.
>>For the time being I can just tell that there may be some differences between
examples in CC and the ones on this site as the latter may be generated with
earlier version of CC. Does it happen on all pages in this example ?
What about other examples ? <<
|
|
|
|
megan_g
|
| Posted: 01/17/2002, 8:19 AM |
|
Hi~
try opening up the database (I am assuminging it's access) and then go to design view of the table that is having the problem. click on that field and then in the little panel underneath the list of fields set the allow zero length to yes - and save - that should fix it (hopefully). meg
|
|
|
|
dplaut
|
| Posted: 01/17/2002, 8:27 AM |
|
I found the solution (although I don't know why the old version from the web site worked). IMO setting the field property to allow zero length strings is not appropriate.
In the file tosql.cfm that is generated for ColdFusion the below changes should be made.
CC code:
<CFCASE VALUE="TEXT">
Corrected code:
<CFCASE VALUE="TEXT,MEMO">
Also the following should also be generated into the tosql.cfm:
<CFCASE VALUE="DATE">
<CFIF Param NEQ "">
<CFSET Param = "##" & Param & "##">
<CFELSE>
<CFSET Param = "Null">
</CFIF>
</CFCASE>
Do the CodeCharge developers read this forum? I feel very strongly that the above changes should be made to the product. I'm using 2.0.4
|
|
|
|
