Sure, there are two problems. It appears that when the last property of the object being created is an array an extra comma is included at the end of the SQL statement. So the SQL ends up looking like:
INSERT INTO owner.table (Col1, Col2,) VALUES (Val1, Val2,) Another possible issue is that Oracle may have problems inserting CLOB data -- you need to use cfqueryparam to work with CLOB data in Oracle. This problem doesn't pop up too often because most objects are first created with minimal data (with out long CLOB values) and then updated. Brendan made changes to setData that addressed both of these issues. It shouldn't be too difficult to bring those changes into createData, the methods are fairly similar, I just don't have time to make the changes and test right now. --Nathan >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Geoff Bowers >Sent: Wednesday, October 13, 2004 6:25 PM >To: FarCry Developers >Subject: [farcry-dev] Re: Container Problem (fixed) > >Nathan Mische wrote: > > The issue turned out to be that while >> the container's rules were being copied and entries were being made >> for copied containers in the REFCONTAINERS and CONTAINER_ARULES >> tables, the actual containers themselves were not being copied and >> created in the CONTAINER table. This is more of a workaround than a >> true fix as the problem is in the createData method of >fourq, not the >> container cfc. I suspect that a true fix would require a re-write of >> the createData method, similar to what Brendan did several >months ago >> with the setData method. > >Great work! Can you elaborate on what you believe is wrong >with createData()? > >-- geoff >http://www.daemon.com.au/ > >--- >You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >[EMAIL PROTECTED] >Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
