[BlueOnyx:11405] Re: Fund-raising for a modern BlueOnyx theme

[Michael Stauber]

Hi Steven,

> There is documentation for accessing the CODB from PHP/Perl 
> scripts so it's not exactly all closed-doors. It is a bit
> 'cross your fingers and sacrifice a chicken' at times if
> you're writing stuff to work with it.

Ah, it ain't that bad. There is the command line tool
/usr/sausalito/bin/cceclient and from within a PHP or Perl script you
also have full access to CODB to do as you please. The only tricky part
from within a script is using the correct syntax to find the one object
you want to manipulate. Once you know the object number you can easily
use a "SET" transaction for modifications or can destroy() the object.

"cceclient" is great for debugging and with it alone you can do anything
that the GUI can also do. Even more than that, as the GUI won't let you
change some things which are "fair game" with "cceclient". At least as
long as you don't try to shove a square pig through a round hole. Like
storing an email address into a database field that only accepts integers.

But yes, the documentation is hard to find (it's in SVN, though) and
it's typically best to take a working example from a GUI page or a
handler/constructor and to "borrow" the code fragment that you need for
the purpose.

-- 
With best regards

Michael Stauber