Yesterday I re-wrote the fourq setData method to use cfqueryparam instead of building up a standard query string. Alex has just confirmed that this change works! So is this a driver issue? A known CFMX issue?
Oracle handles SQL slightly differently to other database drivers. It has a limit on the actual size of the SQL statement it will pass through the driver. Large values are supposed to be passed attached to the statement as bind parameters. FarCry v2.1 passes all content in the SQL statement itself *without* using bind parameters.
Consequently in Oracle when the size a statement incorporating the associated data goes above the 4k limit the driver chokes.
Brendan has modified the database abstraction layer to pass all values as bind parameters for updates. We're currently testing this in our own production environment (MSSQL server) and it appears to be working well.
-- 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]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
