I think I read somewhere (Ben Forts's book?) that using bind parameters actually speeds up database operations as, if the DBMS doesn't have to parse, analyze, and validate the text of a query, it'll be able to respond to requests quicker and more efficiently. Apparently, by using <CFQUERYPARAM> you get some of the benefits of stored procedures without having to write one!
So it may be that this 'Oracle' solution benefits us non-Oracle users too! Regards Ian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Bowers Sent: 19 March 2004 01:20 To: FarCry Developers Subject: [farcry-dev] Re: Database Problem Brendan Sisson wrote: > 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 ---------------------------------------------------- This E-mail scanned for viruses by Harlaxton College ---------------------------------------------------- ---------------------------------------------------- This E-mail scanned for viruses by Harlaxton College ---------------------------------------------------- --- 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
