OK i have a string that is longer than 2000 chars. Oracle won't allow more
than 2000 chars on an insert.
What is the SQL command to add a substring to the end of what is already in
the db?
For those interested here is the code?
NOTe: update is where i'm getting the problems
<cftransaction>
<cfloop index="i" from="1" to="#variables.contentLen#" step="2000">
<cfset variables.content = Mid(form.content, i, 2000)>
<cfif i EQ 1>
<cfquery name="insertArticle"
datasource="#application.dsn#">
INSERT INTO PressRelease
(Header, Content, PressReleaseDate)
VALUES
('#form.header#', '#variables.Content#',
TO_DATE('#form.PressReleaseDate#', 'mm/dd/yyyy'))
</cfquery>
<cfelse>
<cfquery name="update" datasource="#application.dsn#">
UPDATE PressRelease
SET Content = Content + '#variables.content#'
<----THIS IS WHERE THE PROBLEM IS
WHERE sq_PressRelease.currval
</cfquery>
</cfif>
</cfloop>
</cftransaction>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
