Dave,
Yeah, this topic has to be revisited at some point. I have also been
busy developing an application using CakePHP & Oracle. I now wish I
had never been strong-armed to use Oracle, but that besides the point.
;-) Nate had some ideas about trying to fix this issue, but at this
point I'm just so frustrated with this implementation, I'm putting it
aside for now.
Amazingly, some developers are using this driver in the outlined ways
you have described. It works, but it's not pretty. ;-) Of course,
anyone else is welcome to write patches with associated tests. If
patches/enhancements come with tests, they make it into the core much
quicker also. ;-)
Regards,
jeff
On Fri, May 23, 2008 at 1:18 PM, Bensoft <[EMAIL PROTECTED]> wrote:
>
> On May 23, 7:02 am, "Jeff Loiselle" <[EMAIL PROTECTED]> wrote:
>
>> Welcome to being me.
>
> Hi Jeff,
>
> Great job by the way (considering) and thank you for dbo_oracle.php
>
> I was shocked to find there was no way to get Oracle to return the
> full table.column specifier in OCI_ASSOC. If we could get that then
> the OCI_ASSOC to OCI_NUM conversion (and inline _map build) would work
> just find. I thought about doing OCI_ASSOC to OCI_NUM mapping to load
> the column names and then just scraping the query for tables and
> assigning them that way, logically there is a way to pair those up
> (and support * queries), however, I've got to get a project complete
> (grin).
>
> The real answer would be a better PHP OCI driver with something
> equivilent to [OJ]DBC MetaData. I was surprised this was not
> available. I also considered using dbo_odbc, but it seems as everyone
> else is targeting OCI and that would prove a better cross platform
> solution as my Production environment will be Linux.
>
> For what it's worth, here is the function I wrote in an attempt to
> extract MetaData from an OCI_ASSOC call:
>
> /**
> * Convert associative results to numeric results. We get the
> * associative results so we can extract metadata. This function
> * Also builds the _map array that contains returned column and
> * table names. This function manipulates the
> * _results, _assocResults and _map properties directly to
> * conserve server memory. _assocResults is zapped
> * after call.
> *
> */
> function assocToNum() {
> $rowcount=0;
> $this->_results=array();
> $this->_map = array();
> foreach ($this->_assocResults as $arow) {
> $nrow=array();
> foreach ($arow as $cname => $cvalue) {
> // build metadata map
> if ($rowcount == 0) {
> $e = explode('.', $cname);
> if (count($e) > 1) {
> $table = $e[0];
> $field = strtolower($e[1]);
> } else {
> $table = 0;
> $field = strtolower($e[0]);
> }
> $this->_map[] = array($table, $field);
> }
> // convert OCI_ASSOC row to OCI_NUM row
> $nrow[]=$cvalue;
> }
> $this->_results[]=$nrow;
> $rowcount++;
> }
> //clobber _assocResults to conserve memory
> $this->_assocResults=array();
> }
>
> --Dave
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
