Thanks Brendan. I will try this patch tomorrow and let you know if I can get it working with my configuration. >So is this a driver issue? A known CFMX issue? This is what I'm trying to confirm. Apparently MM has used the Oracle Thin Driver successfully, I'm hoping I can as well. Thanks again for all the help. --Nathan
________________________________ From: [EMAIL PROTECTED] on behalf of Brendan Sisson Sent: Thu 3/18/2004 4:06 PM To: FarCry Developers Subject: [farcry-dev] Re: Database Problem Nathan Mische wrote: > <cfquery name="updateClob" datasource="farcry_fbhc"> > UPDATE > FARCRY_FBHC.DMHTML > SET > BODY = <cfqueryparam value="#clobstring#" > cfsqltype="CF_SQL_LONGVARCHAR"/> > WHERE > OBJECTID = <cfqueryparam > value="B096EC8D-E0B8-16B3-5AB4A96D921C7031" cfsqltype="CF_SQL_VARCHAR"/> > </cfquery> Nathan you were on the right track here. I had been working with Alex off list trying to resolve this issue and the above had worked for us also, so 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? I have attached the file in question (fourq/_fourq/setData.cfm). -Brendan http://farcry.daemon.com.au
<<winmail.dat>>
--- 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
