This will be my first post regarding an I.T. related topic. Great thing about it is that it’s what I am into :D. For those who are into CodeCharge and SQL and PHP, the following will be very useful:
$sql = CCBuildSQL($componentObj->ds->SQL, $componentObj->ds->Where, $componentObj->ds->Order);
It took me a while to realize that there is the existence of CCBuildSQL function in CodeCharge 4. The following, {SQL_Where} and {SQL_OrderBy} gave me a bit of a headache when they are incorporated into what the value of my $directory_items->ds->SQL. Without CCBuildSQL function, I would yet to build my own replace and concatenation function.
A peek into Willowdan's life ... 