Hi,
Just ported my app to work on IIS, Oracle and cake_1.2.0.5146alpha.
After some teething problems everything is pretty much working except
one small problem.
In my controller I have the following
function index()
{
$data = $this->Sitepage->read();
$this->set('data', $data);
}
Which issues the following warning when viewing index.ctp
Warning (2): ociexecute() [function.ociexecute]: ORA-00907: missing
right parenthesis [/usr/local/lib/cake/cake_1.2.0.5146alpha/cake/libs/
model/datasources/dbo/dbo_oracle.php, line 291]
The SQL query which is the cause of this error is (as output when
DEBUG set to 3):
SELECT Link.id, Link.url, Link.title, Link.info, Link.sitepage_id,
Link.keywords, Link.enabled, Link.submitted_by, Link.display_order,
Link.timestamp, Link.filename, Link.filesize, Link.orgfile, Link.mime,
Link.link_broken FROM links Link WHERE Link.sitepage_id IN (''1'')
ORDER BY display_order ASC
As far as I can see, double quotes are being placed around the
sitepage ID, so Oracle throws a wobbler.
Any ideas?
Cheers,
Winston
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
