I've found that using <cfqueryparam cfsqltype="CF_SQL_CLOB"> allows much larger strings than does <cfsqltype="CF_SQL_LONGVARCHAR"> for Oracle. However, I believe you need to have updated to the latest version of ColdFusion.
If line 104 in \fourq\_fourq\setData.cfm is changed to use 'CF_SQL_CLOB', it would be very helpful. On Wed, 13 Oct 2004 18:48:41 -0400, Nathan Mische <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
