change your column type to CLOB -----Original Message----- From: Tim Dempsey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 11:45 AM To: CF-Talk Subject: Help: I need to insert long strings into an Oracle table Hi, all. I am working on a CF application that administers a survey to its clients. The surveys span a number of web pages. On each page there are 2 buttons: 1 for the user to save the page's answers and continue to the next, and 1 to save the current session and exit. Each page presented to the user is described in a CF structure and there is a CF array of those structures to represent the current survey session. This approach was originally taken to be able to keep track of things if the user pressed the browser's Back button. Now I want to save that array of pages as part of implementing the "Save Session and Exit" button. I convert it to a CF string using the CFWDDX tag and then save the string in an Oracle table along with identifying info so it can be retrieved to resume the session. The problem is that the variable will exceed Oracle's limit of 4000 characters for a literal string variable. Is there a way for my to insert my arbitrarily long string into my Oracle table from CF? Oracle's error message suggest to use bind variables. Can they be used in CF? Has anyone every tried to insert very long strings into Oracle? Please help... Thanks, -- Tim Dempsey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
